Session & login/validating/ problem HELP

[Patrick.O.Ige]

I have a code below.(It validates against a SQL DB(login page).thats is
giving me an error!
When i try to use :- Session["name"] = dr["username.Text"].ToString();
To catch the username so as to redirect the user logged in to another
page....PRINTING
Hello:- John .. for example

It says ERROR:- System.IndexOutOfRangeException: username.Text
What does this mean and how can i correct it
PLS HELP!!
Thx


void Login_Click(Object sender, EventArgs e)
{

SqlDataReader dr;

SqlConnection cn = new SqlConnection("Data Source=(local);Initial
Catalog=Northwind;Integrated Security=SSPI;");

cn.Open();

SqlCommand cmdQuestion = new SqlCommand("SELECT Password FROM Users WHERE
username = '" + username.Text + "'", cn);

dr=cmdQuestion.ExecuteReader();





if(dr.Read())

if(dr["Password"].ToString() == Password.Text)


// CookieAuthentication.RedirectFromLoginPage(Email.Text, false);
Response.Redirect("testlabel.aspx");

else
Msg.Text = "Invalid password.";


else
Msg.Text = "Email address not found.";


//Session["name"] = dr["username.Text"].ToString();
cn.Close();






}

 

[Fadi El-Eter]

Maybe dr["username.Text"] should be dr[username.Text] ?

 

[Rajiv R]

Hi patrick

Session["name"] = username.Text;

this wil work.

if you note, u r not selecting the username in your query and u r trying to
access it incorrectly.

 

[Patrick.O.Ige]

Thx for the reply..it worked..
but when i use a username for example dog for the first time it works but
later when i use cat for example it keeps showing
Hello:- Dog..
It keeps DOG in the session for long.

But i want to ge the USERNAME from the datbase and display it
so it catches only yhe username from the DB only..

Help if u can..PLease..look at te code properly
Thx

Hi patrick

Session["name"] = username.Text;

this wil work.

if you note, u r not selecting the username in your query and u r trying to
access it incorrectly.

--
Cheers!
Rajiv. R
Rajspace.Org

I have a code below.(It validates against a SQL DB(login page).thats is
giving me an error!
When i try to use :- Session["name"] = dr["username.Text"].ToString();
To catch the username so as to redirect the user logged in to another
page....PRINTING
Hello:- John .. for example

It says ERROR:- System.IndexOutOfRangeException: username.Text
What does this mean and how can i correct it
PLS HELP!!
Thx


void Login_Click(Object sender, EventArgs e)
{

SqlDataReader dr;

SqlConnection cn = new SqlConnection("Data Source=(local);Initial
Catalog=Northwind;Integrated Security=SSPI;");

cn.Open();

SqlCommand cmdQuestion = new SqlCommand("SELECT Password FROM Users WHERE
username = '" + username.Text + "'", cn);

dr=cmdQuestion.ExecuteReader();





if(dr.Read())

if(dr["Password"].ToString() == Password.Text)


// CookieAuthentication.RedirectFromLoginPage(Email.Text, false);
Response.Redirect("testlabel.aspx");

else
Msg.Text = "Invalid password.";


else
Msg.Text = "Email address not found.";


//Session["name"] = dr["username.Text"].ToString();
cn.Close();






}

 

[Patrick.O.Ige]

Can anybody hellp with the Session question!!!

Thx for the reply..it worked..
but when i use a username for example dog for the first time it works but
later when i use cat for example it keeps showing
Hello:- Dog..
It keeps DOG in the session for long.

But i want to ge the USERNAME from the datbase and display it
so it catches only yhe username from the DB only..

Help if u can..PLease..look at te code properly
Thx

Hi patrick

Session["name"] = username.Text;

this wil work.

if you note, u r not selecting the username in your query and u r trying to
access it incorrectly.

--
Cheers!
Rajiv. R
Rajspace.Org

I have a code below.(It validates against a SQL DB(login page).thats is
giving me an error!
When i try to use :- Session["name"] = dr["username.Text"].ToString();
To catch the username so as to redirect the user logged in to another
page....PRINTING
Hello:- John .. for example

It says ERROR:- System.IndexOutOfRangeException: username.Text
What does this mean and how can i correct it
PLS HELP!!
Thx


void Login_Click(Object sender, EventArgs e)
{

SqlDataReader dr;

SqlConnection cn = new SqlConnection("Data Source=(local);Initial
Catalog=Northwind;Integrated Security=SSPI;");

cn.Open();

SqlCommand cmdQuestion = new SqlCommand("SELECT Password FROM Users WHERE
username = '" + username.Text + "'", cn);

dr=cmdQuestion.ExecuteReader();





if(dr.Read())

if(dr["Password"].ToString() == Password.Text)


// CookieAuthentication.RedirectFromLoginPage(Email.Text, false);
Response.Redirect("testlabel.aspx");

else
Msg.Text = "Invalid password.";


else
Msg.Text = "Email address not found.";


//Session["name"] = dr["username.Text"].ToString();
cn.Close();






}