This my code:
SqlDataAdapter adp = new SqlDataAdapter("Report",con);
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet set = new DataSet();
DataTable dtbl = new DataTable("DataTable1");
adp.SelectCommand.Parameters.AddWithValue("@clrk_Name", txtNameReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_Family",txtFamilyReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@AzTarikh",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@Ela", txtElaReport.Text);
adp.Fill(set, "DataTable1");
ReportDataSource source = new ReportDataSource("DataTable1",set);
reportViewer1.Visible = true;
reportViewer1.LocalReport.ReportPath = "Report1.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(source);
reportViewer1.LocalReport.Refresh();
When i run my project i get this error:
Error 1 The tablix 'Tablix2' is in the report body but the report has no dataset. Data regions are not allowed in reports without datasets. D:\Project\evaluation\WindowsFormsApplication1\WindowsFormsApplication1\Report1.rdlc WindowsFormsApplication1
I can't work with XML
elham deljooeiPosted Feb 3, 2013, 10:20 AM
excuse me
Satyapriya NayakPosted Feb 3, 2013, 9:23 AM
Please do not create duplicate thread
Thanks
elham deljooeiPosted Feb 3, 2013, 9:04 AM
http://www.c-sharpcorner.com/Forums/Thread/200622/fill-reportviewer-with-dataset.aspx
Satyapriya NayakPosted Feb 3, 2013, 8:50 AM
Duplicate thread
http://www.c-sharpcorner.com/Forums/Thread/200622/fill-reportviewer-with-dataset.aspx