protected void Page_Load(object sender, EventArgs e) { using (TSQL2012Entities MyEntities = new TSQL2012Entities()) { var reviews = from review in MyEntities.Products select new { review.productid, ProductName = review.productname, Company = review.Supplier.companyname, Category = review.Category.categoryname, Price = review.unitprice, Discontinued = review.discontinued }; Products.DataSource = reviews.ToList(); Products.DataBind(); var suppid = (from rev in MyEntities.Suppliers select rev).ToList(); foreach (var item in suppid) { DropDownList1.Items.Add(new ListItem(item.companyname, item.supplierid.ToString())); } var catid = (from rev in MyEntities.Categories select rev).ToList(); foreach (var item in catid) { DropDownList2.Items.Add(new ListItem(item.categoryname, item.categoryid.ToString())); } } }
protected void Button1_Click1(object sender, EventArgs e) { using (TSQL2012Entities myEntities = new TSQL2012Entities()) { var del = (from review in myEntities.Products where review.productid == id select review).SingleOrDefault(); myEntities.Products.Remove(del); myEntities.SaveChanges(); } id_tx.Text = string.Empty; }
protected void update_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; var index = gvRow.RowIndex; id = int.Parse((Products.DataKeys[index].Value).ToString()); using (TSQL2012Entities myEntities = new TSQL2012Entities()) { var tb = (from review in myEntities.Products where review.productid == id select review).SingleOrDefault(); id_tx.Text = tb.productid.ToString(); } }
protected void Button1_Click(object sender, EventArgs e) { using (TSQL2012Entities myEntities = new TSQL2012Entities()) { var obj = new Product(); obj.productname = name_tx.Text; obj.supplierid = Convert.ToInt32(DropDownList1.SelectedValue); obj.categoryid = Convert.ToInt32(DropDownList2.SelectedValue); obj.unitprice = Convert.ToDecimal(price_tx.Text); obj.discontinued = Discont_check.Checked; myEntities.Products.Add(obj); myEntities.SaveChanges(); } name_tx.Text = string.Empty; price_tx.Text = string.Empty; Discont_check.Checked = false; grid.Visible = true; }
private void bindGridView() { using (TSQL2012Entities MyEntities = new TSQL2012Entities()) { var reviews = from review in MyEntities.Products select new { review.productid, ProductName = review.productname, Company = review.Supplier.companyname, Category = review.Category.categoryname, Price = review.unitprice, Discontinued = review.discontinued }; Products.DataSource = reviews.ToList(); Products.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { using (TSQL2012Entities MyEntities = new TSQL2012Entities()) { var reviews = from review in MyEntities.Products select new { review.productid, ProductName = review.productname, Company = review.Supplier.companyname, Category = review.Category.categoryname, Price = review.unitprice, Discontinued = review.discontinued }; Products.DataSource = reviews.ToList(); Products.DataBind(); } }
protected void update_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; var index = gvRow.RowIndex; id = int.Parse((Products.DataKeys[index].Value).ToString()); using (TSQL2012Entities myEntities = new TSQL2012Entities()) { var tb = (from review in myEntities.Products where review.productid == id select review).SingleOrDefault(); name_tx.Text = tb.productname; DropDownList1.SelectedValue = tb.supplierid.ToString(); DropDownList2.SelectedValue = tb.categoryid.ToString(); price_tx.Text = tb.unitprice.ToString(); Discont_check.Checked = tb.discontinued; } }
protected void Button1_Click(object sender, EventArgs e) { using (TSQL2012Entities myEntities = new TSQL2012Entities()) { var update = (from review in myEntities.Products where review.productid == id select review).SingleOrDefault(); update.productname = name_tx.Text; update.supplierid = Convert.ToInt32(DropDownList1.SelectedValue); update.categoryid = Convert.ToInt32(DropDownList2.SelectedValue); update.unitprice = Convert.ToDecimal(price_tx.Text); update.discontinued = Discont_check.Checked; myEntities.SaveChanges(); } name_tx.Text = string.Empty; price_tx.Text = string.Empty; Discont_check.Checked = false; grid.Visible = true; }