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 Form1_Load(object sender, EventArgs e)
{
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
dataGridViewNorthWind.DataSource = ctx.Products;
cBoxCategory.DataSource = ctx.Categories;
cBoxCategory.DisplayMember = "CategoryName";
cBoxCategory.ValueMember = "CategoryID";
cBoxSupplier.DataSource = ctx.Suppliers;
cBoxSupplier.DisplayMember = "CompanyName";
cBoxSupplier.ValueMember = "SupplierID";
}
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 rdbProductName_CheckedChanged(object sender, EventArgs e)
{
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
if (rdbProductName.Checked)
{
dataGridViewNorthWind.DataSource = ctx.Products.OrderBy(x => x.ProductName);
}
else if (rdbUnitPrice.Checked)
{
dataGridViewNorthWind.DataSource = ctx.Products.OrderByDescending(x => x.UnitPrice);
}
else if (rdbUnitsInStcok.Checked)
{
dataGridViewNorthWind.DataSource = ctx.Products.OrderByDescending(x => x.UnitsInStock);
}
}
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;
}
private void txtFilter_TextChanged(object sender, EventArgs e)
{
KuzeyYeliDataContext ctx = new KuzeyYeliDataContext();
dataGridViewNorthWind.DataSource = ctx.Products.Where(x => x.ProductName.Contains(txtFilter.Text));
}