C# Report viewer doesn't refresh on data changes (SOLVED)

Question

Good evening everyone I've made a ReportViewer using a dataset with the wizards. My problem is that everytime a change is made in the database the changes don't reflect in my ReportViewer graphic at runtime-unless I close my form and open again but of course that it's not the best. I'm using MySQL and had no problems creating the dataset. I've tried: private void button1_Click(object sender EventArgs e) { reportViewer1.Clear(); reportViewer1.RefreshReport(); } The graphic blinks at it is refreshing but the data displayed is the old one. Please help me I'm very close to a deadline and nothing I've found on Google has worked... I'm using Visual Studio 2010. Regards

Sam Hobbs · Answer

Did you create the data source in the data sources window? Are you sure there is not any generated code? I understand that you used the wizard but there is probably some code generated by it. Please look for it.

Binu Rajan · Answer

how I can call fill() again ..... Its very urgent please help me

juanaGris · Answer

-.- Yeah the code generated was this (and as simple as the following code seems this might help someone because I wasn't able to find it in any of the forums I searched into): this.datosTableAdapter.Fill(this.lineasembocenDataSet.datos); this.reportViewer1.RefreshReport(); Which is automatically generated in the load method of the form. I was using the second line but not the first one (very few sleep lately) Problem solved thanks for your attention Sam.

juanaGris · Answer

Thanks Sam! What I mean by wizard is the one that Visual Studio shows when grabbing a graph from the toolbox once a ReportViewer is inserted into the form. I made my datasource though it. Since I used this wizard I don't have any methods in my form -I didn't manually program the report. Should I manually program the report? If I should could you please help me to do so? I'm a newbie in this report thing as you can see. The database is updated outside the application. For testing I'm making inserts myself in a MySQL shell. Thanks a lot.

Sam Hobbs · Answer

Welcome to C# Corner. How is the database updated? Unless it is updated by the same datasource that the report is created from you will need to refresh the data source. Refreshing the report will not help as you know. I do not remember all the details and I am not sure what you mean by with the wizards. Probably there is a call to a Fill or FillBy method somewhere in your program. I think that you can call that again to get the data refreshed. Let me know if you understand.