Update using Session

hi,

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

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

plz help...

hi,

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

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("@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();                    


        }


      


        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("@ID2",t);  
            int row = cmd.ExecuteNonQuery();
                cn.Close();
                tbName.Text = "";
                tbDesg.Text = "";
                tbCat.Text = "";
           
        }
    }
}

plz help..

hi,

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