want to Display the selected table data in the report viewer

Question

hello friends i am developing a payslip application using C# and access DB. It works fine with single table to store and retrieve data to report viewer but now i have given a option to create a new table for each month for storing every months data separately. Now my problem is i want to show the selected months data in report viewer. i mean the table i select should be displayed in the custom designed report viewer. what should i do? i dono how to swap the table there. please help me regarding this problem ASAP.

Malick Ali · Answer

Did U solve the problem by this method??

vijay raj · Answer

let me try i got your point we should create a new dataset function.

Ish Bandhu · Answer

You can do that like: SqlConnection con=new SqlConnection( your connection string) string str=select * from + your table name +; SqlDataAdapter da=new SqlDataAdapter (strcon); con.open(); DataSet ds=new DataSet(); da.fill(ds) u can bind that ds to your report viewer.

vijay raj · Answer

Thank you for your support but i create a new table from inside the application for every month and i want to display it in the report viewer by selecting the table name.

Ish Bandhu · Answer

Goto-> addnew item -> add dataset.xsd in your web site and customized that dataset as per your requirement. U cab use that dataset with your crystal report. for more detail u can see the article given below: http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its