protected void btnReport_Click(object sender, EventArgs e)
{
//**********************
reportViewer1.ProcessingMode = ProcessingMode.Local;
reportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
MyDigitalDevicesDataSet digitalTechDataSet = new MyDigitalDevicesDataSet();
String s = "SELECT [id],[uName],[pName],[brand],[img],[quantity],[price],userDB.FirstName,userDB.LastName,userDB.Mob,userDB.Adress,userDB.Email FROM [shoppingCart] inner join userDB on userDB.UserId=shoppingCart.uName where uName='" + ddlUsers.Text.Trim() + "';";
SqlDataAdapter da = new SqlDataAdapter(s, con);
DataTable dt = new DataTable();
da.Fill(digitalTechDataSet, digitalTechDataSet.Tables[0].TableName);
dt = digitalTechDataSet.Tables[0];
//YouTube. 2016. crystal report,how to create crystal report in C# net using Dataset,visual studio - YouTube. [ONLINE] Available at: https://www.youtube.com/watch?v=uRICO1sZ3Hc. [Accessed 29 Dec 2016].
ReportDataSource ReportDataSource = new ReportDataSource("shoppingCart", digitalTechDataSet.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(ReportDataSource);
this.reportViewer1.LocalReport.Refresh();
Generatereport(dt);
//***
// this.reportViewer1.ReportRefresh();
//************************
}
protected void btnReport_Click(object sender, EventArgs e)
{
//**********************
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/order_list.rdlc");
MyDigitalDevicesDataSet MyDigitalDevicesDataSet = new MyDigitalDevicesDataSet();
String s = "SELECT [productName] ,[image],[brand],[catagory],[desciption] ,[quantity] FROM [product]";
SqlDataAdapter da = new SqlDataAdapter(s, con);
DataTable dt = new DataTable();
da.Fill(MyDigitalDevicesDataSet, MyDigitalDevicesDataSet.Tables["product"].TableName);
dt = MyDigitalDevicesDataSet.Tables["product"];
//YouTube. 2016. crystal report,how to create crystal report in C# net using Dataset,visual studio - YouTube. [ONLINE] Available at: https://www.youtube.com/watch?v=uRICO1sZ3Hc. [Accessed 29 December 2016].
Generatereport(dt);
}
protected void btnReport_Click(object sender, EventArgs e)
{
Response.Write("8888");
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/inventory_new.rdlc");
MyDigitalDevicesDataSet MyDigitalDevicesDataSet = new MyDigitalDevicesDataSet();
String s = "SELECT [id],[productName] as 'Supplier_Inventory_product_name' ,[brand],[catagory],[desciption] ,[price],[rating],[comments] FROM [product]";
SqlDataAdapter da = new SqlDataAdapter(s, con);
DataTable dtable = new DataTable();
da.Fill(MyDigitalDevicesDataSet, MyDigitalDevicesDataSet.Tables["product"].TableName);
dtable = MyDigitalDevicesDataSet.Tables["product"];
//YouTube. 2016. how to create report in C# net using Dataset,visual studio - YouTube. [ONLINE] Available at: https://www.youtube.com/watch?v=uRICO1sZ3Hc. [Accessed 29 December 2016].
Generatereport(dtable);
}
