利用MySQLDriverCS连接MySql

最新推荐文章于 2024-11-09 21:51:58 发布

weixin_30725467

最新推荐文章于 2024-11-09 21:51:58 发布

阅读量65

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Jery/archive/2005/04/12/136233.html

版权

下载 MySql.Data.msi
连接代码：
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());
   }

转载于:https://www.cnblogs.com/Jery/archive/2005/04/12/136233.html