hi... to all
i've created ssrs reports local following is my code..
public void source(string tbname,string Rptname)
ReportViewer1.Visible = true;
string myQuery = "select * from " + tbname;
SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
SqlDataAdapter da = new SqlDataAdapter(myCommand);
DataSet dt = new DataSet();
//ReportParameter p = new ReportParameter;
//p = new ReportParameter("@p_dno", "5");
//DataSet dt = new DataSet();
//dt = p;
ReportViewer1.LocalReport.ReportPath = Rptname + ".rdlc" ;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportDataSource datasource = new ReportDataSource("employeeDataSet_" + tbname , dt.Tables);
now it works good..
as i expected...
but i want to pass the datasource connection string from here is there any
way to pass the datasource programatically....