public void Grid() {
SqlConnection con = new SqlConnection("server=. ; integrated security=sspi; database = Ram");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from Ram ", con);
DataSet ds= new DataSet();
da.Fill(ds, "Ram");
GridView1.DataSource = ds;
GridView1.DataBind();
ListBox1.DataSource = ds;
ListBox1.DataTextField = ds.Tables[0].Columns[0].ToString();
ListBox1.DataBind();
con.Close();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {
Button lb = new Button();
TextBox txt1 = new TextBox();
txt1 = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0];
string str1 = Convert.ToString(txt1.Text);
TextBox txt4 = new TextBox();
txt4 = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0];
string str4 = Convert.ToString(txt4.Text);
TextBox txt2 = new TextBox();
txt2 = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0];
string str2 = Convert.ToString(txt2.Text);
TextBox txt3 = new TextBox();
txt3 = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0];
string str3 = Convert.ToString(txt3.Text);
SqlConnection con = new SqlConnection("server=. ; integrated security=sspi; database = Ram");
con.Open();
SqlCommand com = new SqlCommand("update Ram set NAME=@NAME,Fname=@age,address =@address where id=@lname", con);
com.Parameters.AddWithValue("@lname", str1);
com.Parameters.AddWithValue("@age", str2);
com.Parameters.AddWithValue("@address", str3);
com.Parameters.AddWithValue("@NAME", str4);
com.ExecuteNonQuery();
Response.Write("successfully updated");
GridView1.EditIndex = -1;
Grid();
}