Unable to retrieve data from MySQL
Posted: Mon Jul 25, 2011 4:52 pm
I am trying to evaluate Stimulsoft Reports but I am having trouble retrieving any data.
In a C# application (Visual Studio 2010) I added a DataSet (DataSet1) and using the Server Explorer added one of my database tables. When I right-click on the table and click Preview Data it shows the records from the table. On my form I added a typed dataset as an instance of that DataSet1 class. I put a StiReport on the form, right-click Choose Data Sources, and selected DataSet1.
Now when I right-click the StiReport and select Design Report, DataSet1 is listed under Data Sources. My table is listed under DataSet1 with all of the columns, but when I right-click on the table and select View Data there are no records in the list. If I create a Data band with that table it doesn't print anything.
I can see the records from Visual Studio but I can't get them to show up in the report. What am I doing wrong?
Thank you very much.
In a C# application (Visual Studio 2010) I added a DataSet (DataSet1) and using the Server Explorer added one of my database tables. When I right-click on the table and click Preview Data it shows the records from the table. On my form I added a typed dataset as an instance of that DataSet1 class. I put a StiReport on the form, right-click Choose Data Sources, and selected DataSet1.
Now when I right-click the StiReport and select Design Report, DataSet1 is listed under Data Sources. My table is listed under DataSet1 with all of the columns, but when I right-click on the table and select View Data there are no records in the list. If I create a Data band with that table it doesn't print anything.
I can see the records from Visual Studio but I can't get them to show up in the report. What am I doing wrong?
Thank you very much.