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
2. On the wizard page "Shoose a Data Source Type" - select Database and press Next
3. Press button New Connection then press button Change in "Data Source" selection.
Then select Data source = Mysql Database and Data Provider = .NET Framework Data Porvider for MySQL and press Ok.
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.
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/
| < Prev | Next > |
|---|




Comments
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
RSS feed for comments to this post.