protected void btninsert_Click(object sender, EventArgs e) { TrainingDBEntities db = new TrainingDBEntities(); UserInfo ui = new UserInfo(); ui.name = txtname.Text; ui.status = txtstatus.Text; db.UserInfoes.Add(ui); var res = db.SaveChanges(); if (res > 0) { Response.Write("Data Inserted"); } }
protected void b1_Click(object sender, EventArgs e) { Button b = (Button)sender; GridViewRow r = (GridViewRow)b.NamingContainer; Response.Write(r.Cells[0].Text + "," + r.Cells[1].Text + "," + r.Cells[2].Text); int id = int.Parse(r.Cells[0].Text); var olddata = (from t in db.UserInfoes where t.Id == id select t).SingleOrDefault(); olddata.status = "active"; olddata.Id = id; var res = db.SaveChanges(); if (res > 0) { Response.Write("Status Updated"); } GridView1.DataBind(); }