Update using Session

Question

Hi I am trying to update db using session but unable to do it..below is my code..redirect is working fine but I have added update on second page and to update using session but its not working ... string t = Session[s].ToString(); cn.Open(); cmd.Connection = cn; cmd.CommandText = Update Labtest_Table set Name=' + tbName.Text + ' Desgn=' + tbDesg.Text + ' Cata=' + tbCat.Text + ' where ID = @ID2; cmd.Parameters.AddWithValue(@ID2t); int row = cmd.ExecuteNonQuery(); cn.Close(); tbName.Text = ; tbDesg.Text = ; tbCat.Text = ; plz help....

Sanjeeb Lenka · Answer

hi put you pageload code within Is not post back .like below and check protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { int t = Convert.ToInt32(Session[s]); cn.Open(); cmd.Connection = cn; cmd.CommandText = Select * From Labtest_Table Where ID=@ID; cmd.Parameters.AddWithValue(@ID t); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { tbName.Text = dr[Name].ToString(); tbDesg.Text = dr[Desgn].ToString(); tbCat.Text = dr[Cata].ToString(); } cn.Close(); } }

Sanjeeb Lenka · Answer

hi you can do it in rowcommand event of gridview. if any prblm reply

Aman Jen · Answer

here's one more..how to redirect from link button on gridview for selected row or value in selected row using session .. plz help...

Aman Jen · Answer

Thnx Bro..:)

Aman Jen · Answer

No Frnd...that is what I am trying..but not working...

Sanjeeb Lenka · Answer

hi is your query updating data in database on update button click.

Aman Jen · Answer

Yes I m getting value to t coz based on data is fetching in textboxes on second page but I am unable to update from second page.... code: FirstPage public partial class SessionNQuerystring : System.Web.UI.Page { string constr = ConfigurationManager.ConnectionStrings[myconstr].ConnectionString; public SqlConnection cn; public SessionNQuerystring() { cn = new SqlConnection(constr); } public SqlCommand cmd = new SqlCommand(); protected void Button1_Click(object sender EventArgs e) { StoreSessionInfo(); } public void StoreSessionInfo() { int s = Convert.ToInt32(TextBox1.Text); Session[s] = s; Response.Redirect(Details.aspx); } --------------------------------------------------- code on second page using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace AddressNTelephone { public partial class Details : System.Web.UI.Page { string constr = ConfigurationManager.ConnectionStrings[myconstr].ConnectionString; public SqlConnection cn; public Details() { cn = new SqlConnection(constr); } public SqlCommand cmd = new SqlCommand(); protected void Page_Load(object sender EventArgs e) { int t = Convert.ToInt32(Session[s]); cn.Open(); cmd.Connection = cn; cmd.CommandText = Select * From Labtest_Table Where ID=@ID; cmd.Parameters.AddWithValue(@IDt); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { tbName.Text=dr[Name].ToString(); tbDesg.Text=dr[Desgn].ToString(); tbCat.Text=dr[Cata].ToString(); } cn.Close(); } protected void Button5_Click(object sender EventArgs e) { int t = Convert.ToInt32(Session[s]); cn.Open(); cmd.Connection = cn; cmd.CommandText = Update Labtest_Table set Name=' + tbName.Text + ' Desgn=' + tbDesg.Text + ' Cata=' + tbCat.Text + ' where ID = @ID2; cmd.Parameters.AddWithValue(@ID2t); int row = cmd.ExecuteNonQuery(); cn.Close(); tbName.Text = ; tbDesg.Text = ; tbCat.Text = ; } } } plz help..

Sanjeeb Lenka · Answer

hi just put a debug point and check are you getting value from session to t.