akhil bk

akhil bk

  • 1.8k
  • 35
  • 453

How to pass both datasource and parameter values to rdlc rep

Dec 26 2018 12:04 AM
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);
}
}

Answers (1)