If you're creating a web application using C# ASP .NET, you will more than likely be using one of the three top database engines MySQL, MSSQL (Microsoft SQL Server), or Oracle to store your online data. From the developer's view, all three databases are virtually the same. You use the same generic framework calls to connect, read, and write data. While it is more common to use Microsoft's MSSQL Server with a .NET application, a large number of web hosts offer the free MySQL database. Therefore, connecting to a MySQL database from C# ASP .NET is an important task and is actually quite easy to do.
Using MySQL with C# ASP .NET
MySQL is a free database and is used very heavily by the linux developers usually when programming with Perl, CGI, or Ruby on Rails. Because of this, MySQL is, for the most part, catered and optimized directly towards the linux developing platform. However, using MySQL from a Windows web application is also supported and MySQL offers several drivers just for Windows users.
The actual library you choose to connect to the database from C# ASP .NET can make a huge impact on the speed and reliability of your database transactions. In addition, your web server may only be configured to use a specific database library from within C#. Choosing the correct database library to use is an important decision in your web application design.
MySQL and MySQLDriverCS
MySQLDriverCS http://sourceforge.net/projects/mysqldrivercs is a free driver framework for connecting to MySQL from within a C# ASP .NET application. It uses the
public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
myConn = new MySQLConnection(new MySQLConnectionString("localhost", "databse", "User", "password").AsString);
MySQLDataAdapter da = new MySQLDataAdapter("select * from dental", myConn);
DataSet ds = new DataSet();
GridView1.DataSource = ds;