Ad:

MS SQL Discussion Thread
Unsolved
Views: 747

Aug 17th, 2009

how can i get the column values

Expand Post »

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.

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.

Similar Threads

GridView Change Color to Column Values in ASP.NET
Update the null values of a particular column in MS SQL
Help with sql to select fields with equal values in MS SQL
Combo column width problem in Visual Basic 4 / 5 / 6
arrange values from row of database in php from max to min, from min to max and value in PHP

mohankumar554

Reputation Points: 7

Solved Threads: 0

Junior Poster in Training

Offline

55 posts
since May 2009

Permalink

Aug 17th, 2009

Re: how can i get the column values

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

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.

jbisono

Reputation Points: 56

Solved Threads: 56

Posting Pro in Training

Offline

432 posts
since May 2009

Permalink

Aug 18th, 2009

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

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.

mohankumar554

Reputation Points: 7

Solved Threads: 0

Junior Poster in Training

Offline

55 posts
since May 2009

Permalink

Aug 18th, 2009

Re: how can i get the column values

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.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: sql stored procedure rounding off?

Next Thread in MS SQL Forum Timeline: Website Form -> SQL Database injection help/guide?

DaniWeb Message

Cancel Changes

User Name
Password