private void Home_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'myInventorySystemDataSet13.Products' table. You can move, or remove it, as needed.
this.productsTableAdapter2.Fill(this.myInventorySystemDataSet13.Products);
// TODO: This line of code loads data into the 'myInventorySystemDataSet9.SubCategory' table. You can move, or remove it, as needed.
this.subCategoryTableAdapter1.Fill(this.myInventorySystemDataSet9.SubCategory);
// TODO: This line of code loads data into the 'myInventorySystemDataSet8.Products' table. You can move, or remove it, as needed.
this.productsTableAdapter1.Fill(this.myInventorySystemDataSet8.Products);
// TODO: This line of code loads data into the 'myInventorySystemDataSet5.SubCategory' table. You can move, or remove it, as needed.
this.subCategoryTableAdapter.Fill(this.myInventorySystemDataSet5.SubCategory);
// TODO: This line of code loads data into the 'myInventorySystemDataSet4.Unit' table. You can move, or remove it, as needed.
this.unitTableAdapter.Fill(this.myInventorySystemDataSet4.Unit);
// TODO: This line of code loads data into the 'myInventorySystemDataSet3.Category' table. You can move, or remove it, as needed.
this.categoryTableAdapter.Fill(this.myInventorySystemDataSet3.Category);
// TODO: This line of code loads data into the 'myInventorySystemDataSet2.Customers' table. You can move, or remove it, as needed.
this.customersTableAdapter.Fill(this.myInventorySystemDataSet2.Customers);
// TODO: This line of code loads data into the 'myInventorySystemDataSet1.Products' table. You can move, or remove it, as needed.
this.productsTableAdapter.Fill(this.myInventorySystemDataSet1.Products);
// TODO: This line of code loads data into the 'myInventorySystemDataSet.Users' table. You can move, or remove it, as needed.
this.usersTableAdapter.Fill(this.myInventorySystemDataSet.Users);
CrystalReportTransection rTrn = new CrystalReportTransection();
crystalReportViewerTransection.ReportSource = rTrn;
CrystalReportCustomer rCus = new CrystalReportCustomer();
crystalReportViewerCustomer.ReportSource = rCus;
CrystalReportProduct rPRo = new CrystalReportProduct();
crystalReportViewerProduct.ReportSource = rPRo;
}
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT Customer_name, Customer_email_id, Mobile_No, Customer_address FROM dbo.Customer WHERE Active=@a";
cmd.Parameters.AddWithValue("@a", "yes");
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
CrystalReportCustomer cr = new CrystalReportCustomer();
cr.SetDataSource(dt);
CrystalReportViewer1.ReportSource = cr;
CrystalReportViewer1.Zoom(75);
}
