public void DataViewDemo() { DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable(); CategoryTableAdapter catAdap = new CategoryTableAdapter(); catAdap.Fill(Category); DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable(); ProductsTableAdapter prodAdap = new ProductsTableAdapter(); prodAdap.Fill(Products); var result = from item in Products select item; DataView view = result.AsDataView(); view.Sort = "ProductName desc"; view.RowFilter = "CategoryID = 65985"; GridView7.DataSource = view; GridView7.DataBind(); DataSet1.ProductsRow row = null; List <DataSet1.ProductsRow> myList = new List <DataSet1.ProductsRow>(); foreach (DataRowView item in view) { row = (DataSet1.ProductsRow)item.Row; myList.Add(row); } GridView8.DataSource = myList; GridView8.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable(); CategoryTableAdapter catAdap = new CategoryTableAdapter(); DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable(); ProductsTableAdapter prodAdap = new ProductsTableAdapter(); catAdap.Fill(Category); prodAdap.Fill(Products); var result = from item in Products select item; DataTable queriedProducts = result.CopyToDataTable <DataSet1.ProductsRow>(); queriedProducts.TableName = "queriedProducts"; DataSet1 ds = new DataSet1(); ds.Tables.Add(queriedProducts); //DataView view = result.AsDataView<DataSet1.ProductsRow>(); //view.RowFilter = "CategoryID = 65985"; GridView1.DataSource = ds.Tables["queriedProducts"]; GridView1.DataBind(); }
public void StronglyTypedDataSet() { DataSet1.CategoryDataTable CategoryDT = new DataSet1.CategoryDataTable(); CategoryTableAdapter CategoryTBAdapter = new CategoryTableAdapter(); DataSet1.ProductsDataTable ProductsDT = new DataSet1.ProductsDataTable(); ProductsTableAdapter ProductsTBAdapter = new ProductsTableAdapter(); CategoryTBAdapter.Fill(CategoryDT); ProductsTBAdapter.Fill(ProductsDT); var result = from cat in CategoryDT join prod in ProductsDT on cat.CategoryID equals prod.CategoryID where cat.CategoryID == 65985 select new { CategoryName = cat.CategoryName, ProductName = prod.ProductName, UnitPrice = prod.UnitPrice }; GridView6.DataSource = result; GridView6.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable(); CategoryTableAdapter catAdap = new CategoryTableAdapter(); DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable(); ProductsTableAdapter prodAdap = new ProductsTableAdapter(); catAdap.Fill(Category); prodAdap.Fill(Products); var result = from item in Products select item; DataTable queriedProducts = result.CopyToDataTable<DataSet1.ProductsRow>(); queriedProducts.TableName = "queriedProducts"; DataSet1 ds = new DataSet1(); ds.Tables.Add(queriedProducts); //DataView view = result.AsDataView<DataSet1.ProductsRow>(); //view.RowFilter = "CategoryID = 65985"; GridView1.DataSource = ds.Tables["queriedProducts"]; GridView1.DataBind(); }
public void DataViewDemo() { DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable(); CategoryTableAdapter catAdap = new CategoryTableAdapter(); catAdap.Fill(Category); DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable(); ProductsTableAdapter prodAdap = new ProductsTableAdapter(); prodAdap.Fill(Products); var result = from item in Products select item; DataView view = result.AsDataView(); view.Sort = "ProductName desc"; view.RowFilter = "CategoryID = 65985"; GridView7.DataSource = view; GridView7.DataBind(); DataSet1.ProductsRow row = null; List<DataSet1.ProductsRow> myList = new List<DataSet1.ProductsRow>(); foreach (DataRowView item in view) { row = (DataSet1.ProductsRow)item.Row; myList.Add(row); } GridView8.DataSource = myList; GridView8.DataBind(); }