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); myCommand.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); DataSet dt = new DataSet(); da.Fill(dt); //ReportParameter[] p = new ReportParameter[1]; //p[1] = new ReportParameter("@p_dno", "5"); //this.ReportViewer1.LocalReport.SetParameters(p); //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[0]); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)