private void btnDelete_Click(object sender, EventArgs e)
{
int productid = (int)dataGridViewNorthWind.CurrentRow.Cells["ProductID"].Value;
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
// Lambda expression
Product product = ctx.Products.SingleOrDefault(Lproduct => Lproduct.ProductID == productid);
ctx.Products.DeleteOnSubmit(product);
ctx.SubmitChanges();
dataGridViewNorthWind.DataSource = ctx.Products;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int productid = (int)txtProductName.Tag;
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
Product product = ctx.Products.SingleOrDefault(Lproduct => Lproduct.ProductID == productid);
product.ProductName = txtProductName.Text;
product.UnitPrice = numericUnitPrice.Value;
product.UnitsInStock = (short)numericUnitsInStock.Value;
product.SupplierID = (int)cBoxSupplier.SelectedValue;
product.CategoryID = (int)cBoxCategory.SelectedValue;
ctx.SubmitChanges();
dataGridViewNorthWind.DataSource = ctx.Products;
}
private void btnAdd_Click(object sender, EventArgs e)
{
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
Product product = new Product();
product.ProductName = txtProductName.Text;
product.UnitPrice = numericUnitPrice.Value;
product.UnitsInStock = (short)numericUnitsInStock.Value;
product.CategoryID = (int)cBoxCategory.SelectedValue;
product.SupplierID = (int)cBoxSupplier.SelectedValue;
ctx.Products.InsertOnSubmit(product);
ctx.SubmitChanges();
dataGridViewNorthWind.DataSource = ctx.Products;
}
