private void Delete_Click(object sender, EventArgs e) { try { DataLinqToSqlDataContext dbdelete = new DataLinqToSqlDataContext(); int prodID = Convert.ToInt32(DataView.CurrentRow.Cells["ID"].Value); PRODUCT prod = dbdelete.PRODUCTs.SingleOrDefault(o => o.ID == prodID); dbdelete.PRODUCTs.DeleteOnSubmit(prod); dbdelete.SubmitChanges(); DataView.DataSource = dbdelete.PRODUCTs; } catch (Exception) { MessageBox.Show("Something went wrong! Retry please ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void Update_Click(object sender, EventArgs e) { try { DataLinqToSqlDataContext dbupcon = new DataLinqToSqlDataContext(); int prodId = Convert.ToInt32(Name.Tag); PRODUCT prod = dbupcon.PRODUCTs.SingleOrDefault(product => product.ID == prodId); prod.NAME = Name.Text; prod.CATEGORY = Category.Text; prod.MADED_BY = Maded_by.Text; prod.PRODUCT_DATE = Convert.ToDateTime(dateTimePicker1.Text); prod.PRICE = numericUpDown1.Value; dbupcon.SubmitChanges(); DataView.DataSource = dbupcon.PRODUCTs; } catch (Exception) { MessageBox.Show("Something went wrong :( , please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
partial void DeletePRODUCT(PRODUCT instance);
partial void UpdatePRODUCT(PRODUCT instance);
partial void InsertPRODUCT(PRODUCT instance);