求个c#连接ACCSEE的写法

来源:百度知道 编辑:UC知道 时间:2024/05/15 19:54:21
谁能教我一个c#连接ACCSEE的写法,并用datagridview1显示库里abc表里的所有字段.求教!
我不想用控件帮定库,想要写出来的连接

string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = Company.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT * FROM abc ";
//创建一个DataSet
DataSet myDataSet = new DataSet();
myConn.Open();
//用OleDbDataAdapter 得到一个数据集
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
//把Dataset绑定person数据表
myCommand.Fill(myDataSet, "abc");
dataGridView1.DataSource = myDataSet.Tables["abc"];
//关闭此OleDbConnection
myConn.Close();

string odbstr="provider=Microsoft.Jet.OleDb.4.0;DataSource=D:\c#\tablename.mdb";
OleDbConnection odb = new OleDbConnection(odbstr);
string selestr="select * from abc";
OleDbDataAdapter da=new OleDbDataAdapter(s