sql joins for login verification

Question

Hai all,

i have two tables ,first table contains id ,employee name,password.and seocnd table contains employe id ,details.when employee login at that time we display his details which are in second table by validating employee with his id and name.for this i put primary key for first table and foriegnkey for second table and i wrote some joins queries but i'm not satisfied .so i here to take some suggestions from seniors.can you guys help me out

Thanks and Regards

Sanjeeb Lenka · Answer

HI, Try like this: protected void btnSubmit_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"); SqlCommand cmd = new SqlCommand("select * from emp where UserName =@username and Password=@password",con); cmd.Parameters.AddWithValue("@username", nameforlogin.Text); cmd.Parameters.AddWithValue("@password", pwdforlogin.Tex); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if(dt.Rows.Count>0) { Session["name"] = nameforlogin.Text; Response.Redirect("Details.aspx"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "validation", " alert('Invalid Username and Password') "); } } in detai.aspx: in page load: string name=Session["name"].ToString(); SqlConnection con = new SqlConnection("Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"); SqlCommand cmd = new SqlCommand("select * from emp where UserName =@username",con); cmd.Parameters.AddWithValue("@username", name); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvDetails.DataSource = dt; gvDetails.DataBind();

Sanjeeb Lenka · Answer

remove test.aspx to login.aspx and don't check session in master page check it in child page

Sanjeeb Lenka · Answer

hi, From my understanding you did correct only.

Sanjeeb Lenka · Answer

hi , you can store at time of login you are storing the result set in datatable. so your datatable also contain the id . instead of name you can assign the id to session. Session["Id"] = dt.Rows[0]["EmpId"].ToString();

aditya immadi · Answer

Hai all, how can i call the records by id from above code instead of name. Thanks and Regards

Sanjeeb Lenka · Answer

hi, you are welcome. mark it as answered if it helps you.

aditya immadi · Answer

kk..thank you Sanjeeb

aditya immadi · Answer

hai Sanjeeb , just before your post i write code in master page load like this if (Session["nameforlogin"] != null) { lblmsg.Text = "welcome:" + Session["nameforlogin"].ToString(); } else { Response.Redirect("test2.aspx"); } but the login page did't appear it will moves directly to the test2.aspx.i mentioned login page as startup page but still i'm getting like that and one more question is the above code good ???

aditya immadi · Answer

SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables.Count > 0) { string status = ds.Tables[0].Rows[0][0].ToString(); if (status == "yes") Session["name"] = nameforlogin.Text; Session["password"] = pwdforlogin.Text; Response.Redirect(" .aspx"); } else { Response.Redirect("login.aspx"); } this code is or employee login and verification and after successfull login how can i show employee data in his account .??? THanks and Regards

Sanjeeb Lenka · Answer

provide me ur code i will resolve the problem

aditya immadi · Answer

No

aditya immadi · Answer

No

aditya immadi · Answer

Hai Sanjeeb, i'm struck with coding.if you don't mind can you provide some example code or something Thanks and Regards

aditya immadi · Answer

Thank you Sanjeeb.. can you please give me a sample query with above details.... Thanks and Regards

aditya immadi · Answer

Thank you Sanjeeb.. can you please give me a sample query with above details.... Thanks and Regards

Sanjeeb Lenka · Answer

hi, at the time of login check name and password in database table . if it match successfully then corresponding id to to session. if it not matched then show the login page again. After login using the id from session retrieve the details of employe and show it in your page. Note: In every page pageload check the session is null or not if null redirect to login page .

Suthish Nair · Answer

Issue Resolved?

sql joins for login verification

Answers (17)