Adding Connection to Visual Studio 2010

I'm new to Visual Studio C#. I'm creating a timekeeping system. I have MySQL as a database sever. I already added MySQL.data as a reference. My question is how can i add connection in Visual Studio 2010

Answers


Goto "View" tab, select the "Server Explorer", right click on the "Data Connections" and select the "Add connection" in the context menu, to add a new connection to your MySQL database.

A "Choose Data Source" window will open asking you to select the database type, select "Other" item from the list, then selct then select the data provider you want from the dropdownlist. Click "continue". Then "Add connection" window will appear, select the "Data Source Specification" in it, over here you can select the data source name("Refresh if don't find MySQL") or you can provide the Connection String to connect to the database.

Provide the "UserName" and "Password". Then hit the "Test Connection" button to make sure everyt hing is working as expected.


Need Your Help

Simple JSP page is not working

java jsp

May be i am doing a blunder simplest mistake , and i know this platform is not suitable for asking this one simplest question.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.