public void Insert(object sender, EventArgs e) { DBADataContext db = new DBADataContext(); user u = new user { username = textunm.Text, firstname = textfnm.Text, lastname = textlnm.Text, mobile_no = textmob.Text, email_id = textemail.Text, password = textpass.Text, user_type = listut.Text }; db.users.InsertOnSubmit(u); db.SubmitChanges(); updateUser(); textunm.Text = ""; textfnm.Text = ""; textlnm.Text = ""; textmob.Text = ""; textemail.Text = ""; textpass.Text = ""; Response.Write("<script>alert('Record insert Success');</script>"); }
public void onRowDelete(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(grid_user.DataKeys[e.RowIndex].Values[0]); user u = db.users.FirstOrDefault(x => x.uid == id); db.users.DeleteOnSubmit(u); db.SubmitChanges(); Page_Load(sender, e); }
protected void btnsubmit_Click(object sender, EventArgs e) { Exapance_DB ex = new Exapance_DB { type_of_expance = txtex.Text, amount = Convert.ToInt32(txtamount.Text), message = txtmsg.Text, Log = "Entry Added by -" + Session["unm"], Date = Convert.ToDateTime(DateTime.Today.ToString("MM-dd-yyyy")) }; db.Exapance_DBs.InsertOnSubmit(ex); db.SubmitChanges(); txtamount.Text = ""; txtex.Text = ""; txtmsg.Text = ""; Page_Load(sender, e); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt16(Request.QueryString.Get("id").Trim()); DBADataContext db = new DBADataContext(); user u = db.users.FirstOrDefault(x => x.uid == id); //var use = from d in db.users where d.uid == id select d; if (u != null) { db.users.DeleteOnSubmit(u); db.SubmitChanges(); Response.Write("Delete Success"); } else { Response.Write("Not deleted Data"); } }