protected void btnEdit_Click(object sender, EventArgs e) { int newcID = Convert.ToInt32(ddCINew.SelectedItem.Value); int newfID = Convert.ToInt32(ddFidNew.SelectedItem.Value); int id = Convert.ToInt32(txtIDed.Text); var db = new Model1(); var clFurUpdatequerry = from cf in db.tblClientFurnitures where cf.id == id select cf; if (!clFurUpdatequerry.Any()) { lblError.Text = "ID does not exsist"; } else { tblClientFurniture cfur = clFurUpdatequerry.First(); cfur.clientId = newcID; cfur.furnitureId = newfID; db.SaveChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table } }
protected void btnRegister_Click(object sender, EventArgs e) { int clientID = Convert.ToInt32(ddCName.SelectedValue); int furnID = Convert.ToInt32(ddFName.SelectedValue); var db = new Model1(); tblClientFurniture cf = new tblClientFurniture(); cf.clientId = clientID; cf.furnitureId = furnID; cf.date = DateTime.Now; db.tblClientFurnitures.Add(cf); // basically the query and where it souuld execute db.SaveChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table }
protected void btnRegister_Click(object sender, EventArgs e) { int clientID = Convert.ToInt32(ddCName.SelectedItem); int furnID = Convert.ToInt32(ddFName.SelectedItem); var db = new DataClasses1DataContext(); tblClientFurniture cf = new tblClientFurniture(); cf.clientId = clientID; cf.furnitureId = furnID; cf.date = DateTime.Now; db.tblClientFurnitures.InsertOnSubmit(cf); // basically the query and where it souuld execute db.SubmitChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table }