文件名称:.net 连接mysql 安装包 mysqldrivercs
文件大小:3.44MB
文件格式:RAR
更新时间:2016-03-25 09:41:35
mysql C# Mysqldriver
此种方法经过本人开发使用,完全没有问题, 希望可以帮到你。 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.Odbc; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using MySQLDriverCS; namespace mysql { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { MySQLConnection conn = null; conn = new MySQLConnection(new MySQLConnectionString("localhost", "inv", "root", "831025").AsString); conn.Open(); MySQLCommand commn = new MySQLCommand("set names gb2312", conn); commn.ExecuteNonQuery(); string sql = "select * from exchange "; MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn); DataSet ds = new DataSet(); mda.Fill(ds, "table1"); this.dataGrid1.DataSource = ds.Tables["table1"]; conn.Close(); } } }
【文件预览】:
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe