MySQL Tools Comparison.

  • Increase font size
  • Default font size
  • Decrease font size
Home Articles MySQL Add MySQL related tables into Data Source Visual Studio 2005

Add MySQL related tables into Data Source Visual Studio 2005

Print PDF
User Rating: / 295

How create data source in Visual Studio 2005  with data from MySQL tables with FK.

For example, create a new project C# Windows Application.

1. Select  menu  Data - Add New Data Source  Add new Data Source

2. On the wizard page "Shoose a Data Source Type" -  select Database and press Next

Choose a Data Source Type

3. Press button New Connection choose your data connection then  press button Change in "Data Source" selection.

Add connection

Then select Data source = Mysql Database and Data Provider = .NET Framework  Data Porvider for MySQL and press Ok.

Change data source


4. Specify the connection settings. Type field Server Name, User Name, Password. If necessary, change the specific settings by clicking Advanced.

Press "Test Connection" to verify the connection to the server MySQL. If successful click button OK.

Add new connection

5. On the wizard  press Next  then specify name of new connection.

6. On the wizard page "Shoose your database objects" - choose tables. Finish.


When you create a connection, use NET Framework Data Provider for MySQL
Connector-Net 6.2.2



0 #2 2012-05-09 06:49
There isn't any datasource mysql in my vs2010...!
i just install mysql connector 6.2 and still there isn't mysql datasource in my dataset creator
+1 #1 2010-07-27 17:44
Where is the MxSQL of this list?

Add comment

Security code