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(); }