code for identifying current user of website

Question

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

shamshad c · Answer

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  alert('Invalid Username and Password') ); } con.Close();

Jaganathan Bantheswaran · Answer

How is you Login logic? Can you show us the code?

Anubhav Chaudhary · Answer

This will solve your problem: http://asp-net-example.blogspot.in/2008/10/loginname-example-how-to-show-login.html