How to Use report Viewer in c# with Ms Access database ?

Question

I have developed c# desktop app with Ms Access database. I want to use Report Viewer but I have not information how to use it?

Rajkiran Swain · Answer

Here are the steps to use the Report Viewer in C# with MS Access database: Create a new Windows Forms Application project in Visual Studio. Add a new DataSet to the project by right-clicking on the project name in the Solution Explorer, selecting "Add" -> "New Item", and selecting "DataSet" under the "Data" category. In the DataSet designer, create a new table adapter by right-clicking on the surface and selecting "Add" -> "TableAdapter". Configure the table adapter to connect to your MS Access database and select the data you want to display in your report. Add a new report to the project by right-clicking on the project name in the Solution Explorer, selecting "Add" -> "New Item", and selecting "Report" under the "Reporting" category. In the Report Designer, drag and drop the fields you want to display from the Data Sources window onto the report surface. Add a new form to the project by right-clicking on the project name in the Solution Explorer, selecting "Add" -> "New Item", and selecting "Windows Form" under the "Windows Forms" category. Drag and drop a ReportViewer control onto the form from the Toolbox. Set the ReportViewer control's "ProcessingMode" property to "Local". Set the ReportViewer control's "LocalReport.ReportPath" property to the path of your report file. Set the ReportViewer control's "LocalReport.DataSources" property to a new instance of a "ReportDataSource" object, passing in the name of your DataSet and the name of the table adapter you created. In the form's code-behind file, add code to load the data into the DataSet, then call the ReportViewer control's "RefreshReport" method to display the report. Here is an example code snippet: private void Form1_Load(object sender, EventArgs e) { // Load the data into the DataSet myDataSet1.EnforceConstraints = false; myTableAdapter1.Fill(myDataSet1.myTable); // Set the ReportViewer control's properties reportViewer1.ProcessingMode = ProcessingMode.Local; reportViewer1.LocalReport.ReportPath = "MyReport.rdlc"; reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("MyDataSet_myTable", myDataSet1.Tables["myTable"])); // Refresh the report reportViewer1.RefreshReport(); } Note that in this example, "myDataSet1" is the name of the DataSet, "myTableAdapter1" is the name of the table adapter, and "myTable" is the name of the table in the DataSet that contains the data to display in the report. Replace these names with the appropriate names for your own project.

How to Use report Viewer in c# with Ms Access database ?

Answers (1)