How to pass both datasource and parameter values to rdlc rep
private void Test_Load(object sender, EventArgs e)
{
try
{
string sql = "[companyid] ,[companyname] ,[Shopid] ,[shopname],[shopaddress],[shopphone],[fax], [footermsg],[footermsg_ar] FROM [shop] Where id = '1' ";
DataAccess.ExecuteSQL(sql);
DataTable dt = DataAccess.GetDataTable(sql);
ReportDataSource reportDSDetail = new ReportDataSource("DataSet1", dt);
string sqli = "SELECT [logo] FROM [logo] Where id= '1' ";
DataAccess.ExecuteSQL(sql);
DataTable dts = DataAccess.GetDataTable(sql);
string path = Application.StartupPath + @"\LOGO\";
string imagePath = path + dts.Rows[0].ItemArray[0].ToString();
ReportParameter pImageUrl = new ReportParameter("pName", "file://" + imagePath, true);
this.reportViewer1.LocalReport.ReportPath =path+@"Rep.rdlc";
this.reportViewer1.LocalReport.EnableExternalImages = true;
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { pImageUrl });
this.reportViewer1.LocalReport.DataSources.Add(reportDSDetail);
this.reportViewer1.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show("Exception=" + ex);
}
}