OleDbCommandBuilder 使用实例

         private void InsertBarData(string FilePath,string dataList)
        {
            string conString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + FilePath;
            OleDbConnection con = new OleDbConnection(conString);
            con.Open();

            OleDbCommand myCommand = new OleDbCommand("select * from BarCodeList", con);
            OleDbDataAdapter MyDataAdapter = new OleDbDataAdapter();                    //定义OleDbDataAdapte对象
            MyDataAdapter.SelectCommand = myCommand;                                    //设置OleDbDataAdapte对象的SelectCommand属性
            DataSet MyDataSet = new DataSet();                                          //定义DataSet
            MyDataAdapter.Fill(MyDataSet, "CodeList");                                  //通过OleDbDataAdapte对象的SelectCommand属性填充MyDataSet
            OleDbCommandBuilder MyCommandBuild =