protected void btnAddProduct_Click(object sender, EventArgs e) { MembershipSystemContext dbContext = new MembershipSystemContext(); Product d = new Product { Name = txtName.Text, Details = txtDetails.Text, Price = decimal.Parse(txtPrice.Text) }; dbContext.Products.Add(d); dbContext.SaveChanges(); ClearPageTextboxes(); }
private object CreateDataSource() { DataTable dt = new DataTable(); DataRow dr; MembershipSystemContext DBConn = new MembershipSystemContext(); IEnumerable <Product> Products = DBConn.Products.ToList <Product>(); // Define the columns of the table. dt.Columns.Add(new DataColumn("ProductId", typeof(Int32))); dt.Columns.Add(new DataColumn("Name", typeof(String))); dt.Columns.Add(new DataColumn("Details", typeof(String))); dt.Columns.Add(new DataColumn("AmtVoted", typeof(decimal))); dt.Columns.Add(new DataColumn("Price", typeof(decimal))); dt.Columns.Add(new DataColumn("Score", typeof(Int32))); dt.Columns.Add(new DataColumn("Rating", typeof(decimal))); // Populate the table with sample values. foreach (Product x in Products) { dr = dt.NewRow(); dr[0] = x.ProductID; dr[1] = x.Name; dr[2] = x.Details; dr[3] = x.AmtVoted; dr[4] = x.Score; dr[5] = x.Price; dr[6] = x.Rating; dt.Rows.Add(dr); } DataView dv = new DataView(dt); return(dv); }