How to pass Id in the database to another page using session

Here's a quick example for your reference:

Suppose that you have this code for your login:

privatestringGetConnectionString(){
returnConfigurationManager.ConnectionStrings["YourConnectionStringKey"].ConnectionString;
}
protectedvoidButton1_Click(objectsender,EventArgse){
DataTabledt=newDataTable();
using(SqlConnectionconnection=newSqlConnection(GetConnectionString())){
connection.Open();
stringsql="SELECTID,UserNameFROMYourTableTABLE1WHEREUserName=@UserANDPassword=@Password";
using(SqlCommandcmd=newSqlCommand(sql,connection)){
cmd.Parameters.AddWithValue("@User",txtUser.Text);
cmd.Parameters.AddWithValue("@Password",txtPassword.Text);
using(SqlDataAdapterad=newSqlDataAdapter(cmd)){
ad.Fill(dt);
}
}
}
if(dt.Rows.Count>0){
//foundanyresult
//storethevalueinSession
Session["UserID"]=dt.Rows[0]["ID"].ToString();
//redirecttohomepage
Response.Redirect("Home.aspx");
}
}

Note that after we get the data from database we store the ID value in Session.iNote that in real scenario you may need to use FormsAuthentication.SetAuthCookie() and RedirectFromLoginPage() method to redirect authenticated users so you can use builtin methods provided.

now in your Home.aspx page you can do something like this to get the data from Session and then query your database:

protectedvoidPage_Load(objectsender,EventArgse){
if(Session["UserID"]!=null){
DataTabledt=newDataTable();
using(SqlConnectionconnection=newSqlConnection(GetConnectionString())){
connection.Open();
stringsql="SELECT*FROMYourTableTABLE1WHEREUserID=@ID";
using(SqlCommandcmd=newSqlCommand(sql,connection)){
cmd.Parameters.AddWithValue("@ID",Session["UserID"].ToString());
using(SqlDataAdapterad=newSqlDataAdapter(cmd)){
ad.Fill(dt);
}
}
}
if(dt.Rows.Count>0){
//getthedatahere
}
}
}

4 Replies

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

Vincent Maverick Durano10y ago
Accepted answer
Here's a quick example for your reference:
Suppose that you have this code for your login:
privatestringGetConnectionString(){
returnConfigurationManager.ConnectionStrings["YourConnectionStringKey"].ConnectionString;
}
protectedvoidButton1_Click(objectsender,EventArgse){
DataTabledt=newDataTable();
using(SqlConnectionconnection=newSqlConnection(GetConnectionString())){
connection.Open();
stringsql="SELECTID,UserNameFROMYourTableTABLE1WHEREUserName=@UserANDPassword=@Password";
using(SqlCommandcmd=newSqlCommand(sql,connection)){
cmd.Parameters.AddWithValue("@User",txtUser.Text);
cmd.Parameters.AddWithValue("@Password",txtPassword.Text);
using(SqlDataAdapterad=newSqlDataAdapter(cmd)){
ad.Fill(dt);
}
}
}
if(dt.Rows.Count>0){
//foundanyresult
//storethevalueinSession
Session["UserID"]=dt.Rows[0]["ID"].ToString();
//redirecttohomepage
Response.Redirect("Home.aspx");
}
}
Note that after we get the data from database we store the ID value in Session.iNote that in real scenario you may need to use FormsAuthentication.SetAuthCookie() and RedirectFromLoginPage() method to redirect authenticated users so you can use builtin methods provided.
now in your Home.aspx page you can do something like this to get the data from Session and then query your database:
protectedvoidPage_Load(objectsender,EventArgse){
if(Session["UserID"]!=null){
DataTabledt=newDataTable();
using(SqlConnectionconnection=newSqlConnection(GetConnectionString())){
connection.Open();
stringsql="SELECT*FROMYourTableTABLE1WHEREUserID=@ID";
using(SqlCommandcmd=newSqlCommand(sql,connection)){
cmd.Parameters.AddWithValue("@ID",Session["UserID"].ToString());
using(SqlDataAdapterad=newSqlDataAdapter(cmd)){
ad.Fill(dt);
}
}
}
if(dt.Rows.Count>0){
//getthedatahere
}
}
}
Shakti Singh Dulawat10y ago
For that you need to read database using ado or entity frame work and use it
sandeep sandy10y ago
I asked how to get id from table in database and pass it to next page in login click
Shakti Singh Dulawat10y ago
Please find below article this is the best way to pass values between pages in asp.net
https://msdn.microsoft.com/en-us/library/6c3yckfw.aspx