Report designer and MySQL
Hi!
I am using a MySql database and can't seem to find a way to connect the report designer to it . There is no problem with feeding the data at runtime via the RegisterData(DataTable^, String^ name) method. It is very frustrating to build a nice looking report without the designer (auto generated tables with the Table1_ManualBuild event/function are not the best FastReport.net can offer).
Since I'm using VS C++ Express edition the only option is to build(manually) an empty DataSet with a replica of all the tables in the database and then use the rows for design. Any other suggestions?
(though I am still playing with the option of a DataAdapter object that will connect to MySql database, but ... its VS Express)
I am using a MySql database and can't seem to find a way to connect the report designer to it . There is no problem with feeding the data at runtime via the RegisterData(DataTable^, String^ name) method. It is very frustrating to build a nice looking report without the designer (auto generated tables with the Table1_ManualBuild event/function are not the best FastReport.net can offer).
Since I'm using VS C++ Express edition the only option is to build(manually) an empty DataSet with a replica of all the tables in the database and then use the rows for design. Any other suggestions?
(though I am still playing with the option of a DataAdapter object that will connect to MySql database, but ... its VS Express)
Comments
I can create a connector for MySQL. Which MySQL data provider library do you use (where can I download it?)
MySql connector .net 5.2
Thank you!