ASP. NET link to MySQL database

Connect to MySQL in Asp.net, use MySQL. Data. dll, complete ADO. Net access mode, and perform operations as conveniently as SQL Server

MySQL. Data. dll: http://dev.mysql.com/downloads/
Http://free5.ys168.com /? Dotnetly

UsingMySQL. Data. mysqlclient;

Public Partial Class MSG: system. Web. UI. Page
{
Protected   Void Page_load ( Object Sender, eventargs E)
{
String Conn = "Data Source = 127.0.0.1; user id = root; Password = 123; database = newdb; charset = gb2312 ;";
Mysqlconnection con =   New Mysqlconnection (conn );
Con. open ();
Mysqlcommand cmd =   New Mysqlcommand ( " Select * from book " , Con );
Mysqldatareader Dr = Cmd. executereader ();
Gridview1.datasource = Dr;
Gridview1.databind ();
Dr. Close ();
Con. Close ();
}
}

It should be noted that the parameterization in MySQL is different from that in sqlserver
SQL Server parameterization:
Mycommand. Parameters. Add (New sqlparameter ("@ address", sqldbtype. nvarchar, 40 ));
Mycommand. Parameters ["@ address"]. value = address. value;

Parameterization of MySQL:
Cmd. Parameters. Add (New mysqlparameter ("? P_bname ", mysqldbtype. varchar, 50 ));
Cmd. Parameters ["? P_bname "]. value = book. text;