protected void Page_Load(object sender, EventArgs e)
{
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.categoriesTableAdapter da = new DataSet1TableAdapters.categoriesTableAdapter();
DataSet1.categoriesDataTable dt = (DataSet1.categoriesDataTable)ds.Tables["categories"];
da.Fill(dt);
DataSet1TableAdapters.productsTableAdapter da1 = new DataSet1TableAdapters.productsTableAdapter();
DataSet1.productsDataTable dt1 = (DataSet1.productsDataTable)ds.Tables["products"];
da1.Fill(dt1);
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(ds);
//rpt.Refresh();
this.CrystalReportViewer1.ReportSource = rpt;
}
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();
}
