Database connectivity in ASP.NET

Question

I want to connect my database that I have created in SQLyog (version 9.2.02) to Visual Studio 2010 using C#.

I am working on an Online Reservation project, and I am not finding the appropriate steps to do it.

How to proceed?

There is nothing special about ASP.NET when it comes to database connectivity. Can you connect to the database from some other kind of application? Then do it the same way for ASP.NET. — John Saunders, Feb 29 '12 at 18:11
-1 : try explaining what you have tried so far, what exact error messages you encountered, etc. Your question is too general to be useful at present. — jwd, Feb 29 '12 at 18:11
no this is my first encounter with database connectivity.i just want a basic idea how to proceed.i used ado.net for connectivity but while using initial catalog in my connection string it is showing an error as keyword not defined. — user1240912, Feb 29 '12 at 18:15

score 1 · Answer 1 · answered Feb 29 '12 at 18:14

I assume you mean how do you connection to a MySQL database you created using SQLyog?

Check out this article on the MySQL site:

It provides three different connectors:

1.) The ODBC.NET Solution - MyODBC Driver

2.) Using MySQL Native .NET Providers

3.) Using the OLEDB.NET Solution - MyOLDDB Provider

You can get the connector library here:

1 Answers1