protected void btnDelete_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txtId.Text); //var db = new DataClasses1DataContext(); var db = new Model1(); var deleteTitle = from title in db.tblTitles where title.id == id select title; if (deleteTitle.Any()) { // db.tblTitles. // db.tblTitles.DeleteOnSubmit(deleteTitle.First()); //db.tblTitles.Remove(deleteTitle); // db.SubmitChanges(); tblTitle title = deleteTitle.First(); db.tblTitles.Remove(title); db.SaveChanges(); GridTitle.DataBind(); } else { lblError.Text = "Title not deleted"; } }
protected void btnEdit_Click(object sender, EventArgs e) { string newTitle = txtTitleEd.Text; int id = Convert.ToInt32(txtIDEd.Text); var db = new Model1(); var titleUpdatequerry = from title in db.tblTitles where title.id == id select title; if (!titleUpdatequerry.Any()) { lblError.Text = "Title does not exsists"; } else { tblTitle til = new tblTitle(); tblTitle title = titleUpdatequerry.First(); title.Title = newTitle; db.SaveChanges(); // execute the query on the table GridTitle.DataBind(); // to refresh table } }
protected void btnRegister_Click(object sender, EventArgs e) { string title = txtTitle.Text; var db = new DataClasses1DataContext(); tblTitle til = new tblTitle(); til.Title = title; db.tblTitles.InsertOnSubmit(til); // basically the query and where it souuld execute db.SubmitChanges(); // execute the query on the table GridTitle.DataBind(); // to refresh table }
protected void btnRegister_Click(object sender, EventArgs e) { string title = txtTitle.Text; var db = new Model1(); tblTitle til = new tblTitle(); til.Title = title; db.tblTitles.Add(til); // basically the query and where it souuld execute db.SaveChanges(); // execute the query on the table GridTitle.DataBind(); // to refresh table }
partial void DeletetblTitle(tblTitle instance);
partial void UpdatetblTitle(tblTitle instance);
partial void InserttblTitle(tblTitle instance);