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();
}