MySql的OleDb连接到底怎么写

string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0Data source=D:sample"

string aa = "Select * From 表名"

System.Data.OleDb.OleDbConnection oleDbConnection = new System.Data.OleDb.OleDbConnection(ConnStr)

System.Data.OleDb.OleDbCommand oleDbCommand = new System.Data.OleDb.OleDbCommand(aa,oleDbConnection)

oleDbCommand.Connection.Open()

oleDbCommand.ExecuteNonQuery()

*

*

*

oleDbCommand.Connection.Close()

支持的

这样试试:

strcn="Provider=MSDAORA.1Data Source=db1UserID=user01Password=lgc"

conn.Open strcn

把数据库、用户id、口令都换成你自己的

---