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

Question

Hiii, can you explain how to pass the id in database to another page using session and getting the related data of that particular id after login. Thanks in advance.

Vincent Maverick Durano · Answer

Here's a quick example for your reference: Suppose that you have this code for your login: private string GetConnectionString(){ return ConfigurationManager.ConnectionStrings[ "YourConnectionStringKey" ].ConnectionString; } protected void Button1_Click( object sender,EventArgse){ DataTabledt= new DataTable(); using (SqlConnectionconnection= new SqlConnection(GetConnectionString())){ connection.Open(); string sql= "SELECTID,UserNameFROMYourTableTABLE1WHEREUserName=@UserANDPassword=@Password" ; using (SqlCommandcmd= new SqlCommand(sql,connection)){ cmd.Parameters.AddWithValue( "@User" ,txtUser.Text); cmd.Parameters.AddWithValue( "@Password" ,txtPassword.Text); using (SqlDataAdapterad= new SqlDataAdapter(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: protected void Page_Load( object sender,EventArgse){ if (Session[ "UserID" ]!= null ){ DataTabledt= new DataTable(); using (SqlConnectionconnection= new SqlConnection(GetConnectionString())){ connection.Open(); string sql= "SELECT*FROMYourTableTABLE1WHEREUserID=@ID" ; using (SqlCommandcmd= new SqlCommand(sql,connection)){ cmd.Parameters.AddWithValue( "@ID" ,Session[ "UserID" ].ToString()); using (SqlDataAdapterad= new SqlDataAdapter(cmd)){ ad.Fill(dt); } } } if (dt.Rows.Count>0){ //getthedatahere } } }

Shakti Singh Dulawat · Answer

For that you need to read database using ado or entity frame work and use it

sandeep sandy · Answer

I asked how to get id from table in database and pass it to next page in login click

Shakti Singh Dulawat · Answer

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