MYSQL-TOOLS

Comparison of graphical tools for MySQL

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: / 254
PoorBest 

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 http://dev.mysql.com/downloads/connector/net/


 

Comments 

 
0 #2 2012-05-09 06:49
hello,
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
Quote
 
 
+1 #1 2010-07-27 17:44
Where is the MxSQL of this list?
Quote
 

Add comment


Security code
Refresh

mysql tools

How create data source in Visual Studio with data from My SQL tables with FK. more...

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...