code for identifying current user of website

shamshad c

hi Team,

I am new web application , recently i had created one website using using asp.net with c# and sql express as back-end for online attendance, in that i have crate a separate log-in for instructors

My requirement is that i want to identify which user is currently loged in to the instructor page and want to display his name on the same page like welcome . kindly help me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

shamshad c12y ago
SqlConnection con = new SqlConnection(strcon);

con.Open();
SqlCommand cmd = new SqlCommand("select * from Login_Table where UserName =@username and Password=@Password", con);
cmd.Parameters.AddWithValue("@username", username.Text);
cmd.Parameters.AddWithValue("@password", password.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

if (dt.Rows.Count > 0)
{

if(dt.Rows[0]["Type"].ToString() == "Admin")
Response.Redirect("Administration.aspx");
else
Response.Redirect("Instructor.aspx");
}

else
{
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "");
}

con.Close();
Jaganathan Bantheswaran12y ago
How is you Login logic? Can you show us the code?
Anubhav Chaudhary12y ago
This will solve your problem:

http://asp-net-example.blogspot.in/2008/10/loginname-example-how-to-show-login.html