Show First Name in Master page

Login.aspx.cs
protected void btn_login_Click(object sender, EventArgs e)
{
string UserName = TextBox_user_name.Text.Trim();
string Password = TextBox_password.Text.Trim();
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "Select * from Login";
com = new SqlCommand(str);
sqlda = new SqlDataAdapter(com.CommandText, con);
dt = new DataTable();
sqlda.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
UserName = dt.Rows[i]["UserName"].ToString();
Password = dt.Rows[i]["Password"].ToString();
if (UserName == TextBox_user_name.Text && Password == TextBox_password.Text)
{
Session["UserName"] = UserName;
Response.Redirect("Details.aspx");
}
else
{
lb1.Text = "Invalid User Name or Password! Please try again!";
}
}
}
}
}

Details.aspx

public partial class Details : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
protected void Page_Load(object sender, EventArgs e)
{
lb1.Text = "" + "WELLCOME:: " + "" + "" + Session["UserName"] + "";
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Login where UserName='" + Session["UserName"] + "'";
com = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
lbl_UserName.Text = ds.Tables[0].Rows[0]["UserName"].ToString();
lbl_address.Text = ds.Tables[0].Rows[0]["address"].ToString();
lbl_sal.Text = ds.Tables[0].Rows[0]["sal"].ToString();
lbl_phone.Text = ds.Tables[0].Rows[0]["phone"].ToString();
}
}

2 Replies

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

Sundaram Subramanian9y ago
Accepted answer
Use Session and call the First Name of the User in the master page. Use a lable in master page and display the Name

Thanks is advance
Rajkiran Swain9y ago
2. Login.aspx.cs
4. protected void btn_login_Click(object sender, EventArgs e)
5. {
6. string UserName = TextBox_user_name.Text.Trim();
7. string Password = TextBox_password.Text.Trim();
8. SqlConnection con = new SqlConnection(strConnString);
9. con.Open();
10. str = "Select * from Login";
11. com = new SqlCommand(str);
12. sqlda = new SqlDataAdapter(com.CommandText, con);
13. dt = new DataTable();
14. sqlda.Fill(dt);
15. RowCount = dt.Rows.Count;
16. for (int i = 0; i < RowCount; i++)
17. {
18. UserName = dt.Rows[i]["UserName"].ToString();
19. Password = dt.Rows[i]["Password"].ToString();
20. if (UserName == TextBox_user_name.Text && Password == TextBox_password.Text)
21. {
22. Session["UserName"] = UserName;
23. Response.Redirect("Details.aspx");
24. }
25. else
26. {
27. lb1.Text = "Invalid User Name or Password! Please try again!";
28. }
29. }
30. }
31. }
32. }
Details.aspx
public partial class Details : System.Web.UI.Page
   {
       string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
       string str;
       SqlCommand com;

       protected void Page_Load(object sender, EventArgs e)
       {
           lb1.Text = "" + "WELLCOME:: " + "" + "" + Session["UserName"] + "";
           SqlConnection con = new SqlConnection(strConnString);
           con.Open();
           str = "select * from Login where UserName='" + Session["UserName"] + "'";
           com = new SqlCommand(str, con);
           SqlDataAdapter da = new SqlDataAdapter(com);
           DataSet ds = new DataSet();
           da.Fill(ds);
           lbl_UserName.Text = ds.Tables[0].Rows[0]["UserName"].ToString();
           lbl_address.Text = ds.Tables[0].Rows[0]["address"].ToString();
           lbl_sal.Text = ds.Tables[0].Rows[0]["sal"].ToString();
           lbl_phone.Text = ds.Tables[0].Rows[0]["phone"].ToString();

       }
   }