MS SQL

how can i get the column values

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2009

Posts: 52

Reputation: mohankumar554 is an unknown quantity at this point

Solved Threads: 0

mohankumar554 mohankumar554 is offline

Offline

Junior Poster in Training

how can i get the column values

Aug 17th, 2009

hi,
i need to get the column values from the table login.it contais two columns ,userid and password. i want to check the userid and password values when the user logged in.so i have to compare the entered textbox value with the saved value. i am using the code is shown below.

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
rdr=cmd.executereader();
while(rdr.READ())
{
IF(txtbox1.text==rdr[0])
IF(txtbox2.text==rdr[0])
msg(" successfully loggedin");
}
rdr=cmd.executereader();
while(rdr.read())
{
if(txtbox1.text==rdr[0])
if(txtbox2.text==rdr[0])
msg(" successfully loggedin");
}

i am using the asp.net(C#.net )with sql server..
so can u tell me the solution for that.

Last edited by peter_budo; Aug 17th, 2009 at 4:45 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: May 2009

Posts: 196

Reputation: jbisono is an unknown quantity at this point

Solved Threads: 24

jbisono

Offline

Junior Poster

Re: how can i get the column values

Aug 17th, 2009

Why dont you include the parameters in the select statement something like

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
string st = "select user, pass from loggin where user = '"+txtbox1.text+"' and pass = '"+txtbox2.text+"'";
//Then pass that SELECT TO the command object
rdr=cmd.executereader();
IF(rdr.HasRows)
{
   msg(" successfully loggedin");
}
string st = "select user, pass from loggin where user = '"+txtbox1.text+"' and pass = '"+txtbox2.text+"'";
//Then pass that select to the command object
rdr=cmd.executereader();
if(rdr.HasRows)
{
   msg(" successfully loggedin");
}

Take care.

If your already resolved your issue, flag it as solved.
José Bisonó

•

Join Date: May 2009

Posts: 52

Reputation: mohankumar554 is an unknown quantity at this point

Solved Threads: 0

mohankumar554 mohankumar554 is offline

Offline

Junior Poster in Training

Re: how can match the userid and password with signed userid and pwd

Aug 18th, 2009

hi,
thank you very much. ur code is working.. but i need to compare the userid and password with the saved user id and password in the database. when the both are matched then we will give the msg box as" successfully loggedin" . so can u send the code for it.

•

Join Date: Feb 2009

Posts: 3,464

Reputation: sknake has much to be proud of

Solved Threads: 629

sknake

Offline

.NET Enthusiast

Re: how can i get the column values

Aug 18th, 2009

You do not want to bring the password back in a select statement for security reasons. Do what jbisono suggested and send the data to the database. If you try to select the user "Where username = @username and password = @password" then it will return 0 rows since the password did not match, thus the login failed. If you have a row then the login was OK.

Scott Knake
Custom Software Development
Apex Software, Inc.