# FastReport.MySQL

**Repository Path**: cbscode/FastReport.MySQL

## Basic Information

- **Project Name**: FastReport.MySQL
- **Description**: MySQL8 .Net4.5.2
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2019-03-29
- **Last Updated**: 2022-04-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

MySQL data connection for FastReport.Net
----------------------------------------


How to compile:
---------------

- you need the MySQL .Net Data Provider to be installed. Obtain it
at http://dev.mysql.com/downloads/connector/net/6.0.html;
- open the .sln file;
- fix the "FastReport.dll" reference. By default, this dll is located in the
"C:\Program Files\FastReports\FastReport.Net Demo" folder;
- check that "MySql.Data.dll" reference is correct. 
If Visual Studio complains about it, fix this reference as well. By default,
this dll is located in the GAC;
- compile the project. You will get the "FastReport.MySQL.dll" file.


How to register this dll in FastReport:
---------------------------------------

You can do it in several ways:

1) register using the FastReport IDE
- open the report designer;
- go "View|Options..." menu;
- on the "Plugins" tab, add the FastReport.MySQL.dll;
- restart FastReport. If you are working in the Visual Studio IDE, restart 
it as well;

2) edit manually the FastReport.config file
- by default, this file is located in the "C:\Documents and Settings\user_name\
Local Settings\Application Data\FastReport" folder;
- close any running instances of FastReport.Net;
- open the config file in any text editor and modify it in the following way:
  <?xml version="1.0" encoding="utf-8"?>
  <Config>
    ...
    <Plugins>
      <Plugin Name="c:\.....\FastReport.MySQL.dll"/>
    </Plugins>
  </Config>

3) register the dll programmatically
- add the "FastReport.MySQL.dll" reference to your project;
- execute the following code once at the application start:
FastReport.Utils.RegisteredObjects.AddConnection(typeof(MySqlDataConnection));


How to use it:
--------------

- now you should be able to create a new MySQL data source in the 
"Data|Add Data Source..." menu.