protected void Delete_Click(object sender, EventArgs e) { NorthwindDataContext db = new NorthwindDataContext(); Product product = db.Products.Single(p => p.ProductName.StartsWith("Scott's")); db.Products.DeleteOnSubmit(product); db.SubmitChanges(); ShowProducts(); }
protected void Update_Click(object sender, EventArgs e) { NorthwindDataContext db = new NorthwindDataContext(); Product product = db.Products.First(p => p.ProductName.StartsWith("Scott's")); product.UnitPrice += 2.25m; db.SubmitChanges(); ShowProducts(); }
protected void Insert_Click(object sender, EventArgs e) { NorthwindDataContext db = new NorthwindDataContext(); Product p1 = new Product { CategoryID = 1, ProductName = "Scott's Apple Juice", UnitPrice = 4.23m }; db.Products.InsertOnSubmit(p1); db.SubmitChanges(); ShowProducts(); }
private void ShowProducts() { NorthwindDataContext db = new NorthwindDataContext(); var products = from p in db.Products where p.Category.CategoryName == "Beverages" orderby p.ProductID descending select new { p.ProductID, p.ProductName, p.Category.CategoryName, Price = p.UnitPrice }; GridView1.DataSource = products; GridView1.DataBind(); }