关于使用C#数据库连接的问题

[luqiangchair]

兄弟们好，我最近正学着使用C#编写程序，想连接一个用MySql建立的数据库，库名为jopens 表为waveform 怎么建立给个例子代码就行呀，谢谢

[bdmh]

http://blog.sina.com.cn/s/blog_43eb83b90100mb08.html

[tianyunxiatian]

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 waveform ";

MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);


DataSet ds = new DataSet();

mda.Fill(ds, "table1");


this.dataGrid1.DataSource = ds.Tables["table1"];

conn.Close();


}