Sample Code for MySQL DriverCS to connect to MySQL

The following article describes how to use MySQL DriverCS to connect to the MySQL database. This article mainly uses the actual application code to connect MySQL DriverCS to the MySQL database, the following describes the main content of the article.

Download MySql. Data. msi

Connection code:

 
 

  
  
MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("192.168.0.103","jery","root","root").AsString);   
  
  
DataSet ds = new DataSet();   
  
  
MySQLDataAdapter ada = new MySQLDataAdapter("select * from T_User",conn);   
  
  
try   
  
  
{   
  
  
conn.Open();   
  
  
ada.Fill(ds,"jery");   
  
  
conn.Close();   
  
  
this.DataGrid1.DataSource = ds.Tables[0].DefaultView;   
  
  
this.DataGrid1.DataBind();   
  
  
}   
  
  
catch(Exception ex)   
  
  
{   
  
  
Response.Write(ex.Message.ToString());   
  
  
}  
 
 

The above content describes how to use MySQLDriverCS to connect to the MySQL database. I hope it will help you in this regard.