Problem with Database
-
SOLVED -- modified at 19:58 Wednesday 7th September, 2005
-
SOLVED -- modified at 19:58 Wednesday 7th September, 2005
maybe you mean...
szMyQuery.AppendFormat("SELECT User.Username, User.Password FROM [User] WHERE (((User.Username)='{0}'))", szQUser);You arent putting the value of szQUser into the sql, but literally "szQUser"! Better still, use a SqlParameter to add the username to the SQL. Hope this helps Philip Cole -
maybe you mean...
szMyQuery.AppendFormat("SELECT User.Username, User.Password FROM [User] WHERE (((User.Username)='{0}'))", szQUser);You arent putting the value of szQUser into the sql, but literally "szQUser"! Better still, use a SqlParameter to add the username to the SQL. Hope this helps Philip ColeAhh! Made that mistake before!!!! Thanks a bunch man.