Dispaly Data from MySQL 5.5.16 using ASP.NET 3.5

Connecting to MySQL

Before establishing the connection make sure that our MySQL server is running. we can start the server from the command line as shown in the next figure.



Click the Change... button to open the Change Data Source window as shown in the next figure.




This window shows a number of Data Sources one of which is the MySQL Database and click OK. This will bring we back to the Add Connection window with form controls appropriate for making a connection to a MySQL Database.




The Server name; user name and Password are appropriate to the MySQL Server on the local computer and you should enter those appropriate for our installation. we may also test the connection as shown. Click OK after the connection is successful. This adds the connection information to the Configure Data Source wizard. we may expand the connection string item to review the connection string created by our entries.



Click Next. Here shown an option to save the connection string to the Application Configuration File. This is a recommended practice and hence shown checked.



Click Next. Here we will be selecting the set of columns that you want to bring in to your application. It has already chosen the 'persons' table on the MySQL database mcn .




Choose several columns from the list of columns. The SELECT statement is shown at the bottom of the above figure. If i want to click Next then would be probably face a page which throws an exception. The square braces [ ] shown for each of the columns is not acceptable to the server. Click on the first option, "Specify a custom SQL Statement or stored procedure" and then click Next. This opens the "Define Custom Statements or Stored Procedures" page with a Query Builder... button. Here you can not only select columns but also other data modification operations such as Update, Insert and Delete. For now we will be doing just a selection.



Click OK to the Query Builder and click Next. This brings you to the page where you can test the query and review the results as shown.



Click Finish and returned to the Default.aspx page. The GridView now has the column names we chose in configuring SQLDataSource1. The smart tasks list has grown with some additional tasks. From adding new columns to editing the template you can carry out additional tasks.

In the GridView's properties window we can set many of the formatting properties.



In Auto Format... link at the bottom of the above window we can change auto format to choose a scheme for the window as shown.



After choosing the scheme build the project and browse to the Default.aspx page on browser to display the page as shown given below.



In order to implement sorting of the data by column headers you need to choose the option Enable Sorting at design time as shown.

After you download and run the MySQL connector program you will find the MySQL.Data in the References folder of Visual Studio as shown above. Even the splash screen of Visual Studio shows MySQL as one of the products with which it is integrated.