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();
}
private void Form1_Load(object sender, EventArgs e)
{
DataSet1.ProductsDataTable dt = new DataSet1.ProductsDataTable();
DataSet1TableAdapters.ProductsTableAdapter da = new DataSet1TableAdapters.ProductsTableAdapter();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
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();
}
public virtual DataSet1.ProductsDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
DataSet1.ProductsDataTable dataTable = new DataSet1.ProductsDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual int Fill(DataSet1.ProductsDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true))
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return(returnValue);
}
private void button1_Click(object sender, EventArgs e)
{
DataSet1.ProductsDataTable dt = new DataSet1.ProductsDataTable();
DataSet1TableAdapters.ProductsTableAdapter da = new DataSet1TableAdapters.ProductsTableAdapter();
da.FillByProductID(dt, 1);
DataTable dt1 = da.GetDataByProductID(1);
string prodname = dt1.Rows[0][1].ToString();
string prodprice = dt1.Rows[0]["UnitPrice"].ToString();
MessageBox.Show(prodname);
MessageBox.Show(prodprice);
}
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();
}
static void Main(string[] args)
{
DataSet1.categoriesDataTable dtc = new DataSet1.categoriesDataTable();
DataSet1.categoriesRow dr = dtc.NewcategoriesRow();
DataSet1.categoriesRow dr1 = dtc.NewcategoriesRow();
dr["Name"] = "IT";
dr1["Name"] = "OOP";
dtc.Rows.Add(dr);
dtc.Rows.Add(dr1);
foreach (DataRow item in dtc.Rows)
{
Console.WriteLine("categoryId: {0}, category Name: '{1}'", item["Id"], item["Name"]);
}
for (int i = 0; i < dtc.Rows.Count; i++)
{
Console.WriteLine("categoryId: {0}, category Name: '{1}'", dtc.Rows[i]["Id"], dtc.Rows[i]["Name"]);
}
Console.WriteLine();
DataSet1.ProductsDataTable p1 = new DataSet1.ProductsDataTable();
for (int i = 0; i < 10; i++)
{
DataSet1.ProductsRow pr = p1.NewProductsRow();
pr["Id"] = i + 1;
pr["Name"] = "Product " + (i + 1);
p1.Rows.Add(pr);
}
foreach (DataRow item in p1.Rows)
{
Console.WriteLine("product Id: {0} , product Name: '{1}'", item["Id"], item["Name"]);
}
Console.ReadKey();
}
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 virtual int Update(DataSet1.ProductsDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
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();
}
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();
}
