.net odbc连接mysql数据库_c#连接MySql数据库的两种方法

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Drawing;using System.Linq; //vs2005好像没有这个命名空间，在c#2008下测试自动生成的

usingSystem.Text;usingSystem.Windows.Forms;usingMicrosoft.Data.Odbc;namespacemysql

{public partial classForm1 : Form

{publicForm1()

{

InitializeComponent();

}private void Form1_Load(objectsender, EventArgs e)

{string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +

"SERVER=localhost;" +

"DATABASE=inv;" +

"UID=root;" +

"PASSWORD=831025;" +

"OPTION=3";

OdbcConnection MyConnection= newOdbcConnection(MyConString);

MyConnection.Open();

Console.WriteLine(""n success, connected successfully !"n");string query = "insert into test values( 'hello', 'lucas', 'liu')";

OdbcCommand cmd= newOdbcCommand(query, MyConnection);//处理异常：插入重复记录有异常

try{

cmd.ExecuteNonQuery();

}catch(Exception ex){

Console.WriteLine("record duplicate.");

}finally{

cmd.Dispose();

}//***********************用read方法读数据到textbox**********************

string tmp1 = null;string tmp2 = null;string tmp3 = null;

query= "select * from test";

OdbcCommand cmd2= newOdbcCommand(query, MyConnection);

OdbcDataReader reader=cmd2.ExecuteReader();while(reader.Read())

{

tmp1= reader[0].ToString();

tmp2= reader[1].ToString();

tmp3= reader[2].ToString();

}this.textBox1.Text = tmp1 + " " + tmp2 + " " +tmp3;*/

//************************用datagridview控件显示数据表**************************

string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +

"SERVER=localhost;" +

"DATABASE=inv;" +

"UID=root;" +

"PASSWORD=831025;" +

"OPTION=3";

OdbcConnection MyConnection= newOdbcConnection(MyConString);

OdbcDataAdapter oda= new OdbcDataAdapter("select * from customer", MyConnection);

DataSet ds= newDataSet();

oda.Fill(ds,"employee");this.dataGridView1.DataSource = ds.Tables["employee"];*/MyConnection.Close();

}

}

}