public DataTable GenerateDataTable() { InventoryDBEntities2 Context = new InventoryDBEntities2(); StockDetailsManager SDM = new StockDetailsManager(Context); DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("sellinValue"); dt.Columns.Add("quality"); var finalList = SDM.GetUpdatedStockDetails(); foreach (var list in finalList) { DataRow row = dt.NewRow(); row["ID"] = list.ID; row["sellinValue"] = list.sellinValue; row["quality"] = list.quality; dt.Rows.Add(row); } return(dt); }
protected void Application_Start() { InventoryDBEntities2 context = new InventoryDBEntities2(); StockDetailsManager SDM = new StockDetailsManager(context); AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); }