C# 調用Adodb對Access資料庫執行批量插入

C# 調用Adodb對Access資料庫執行批量插入

public void BatchInsertIntoAccess(DataTable dt)
        {
            ADODB.Connection cn;
            ADODB.Recordset rs;
            string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\FileTmp\MMSCRM.mdb;Persist Security Info=False";
            cn = new ADODB.Connection();
            cn.ConnectionString = strConn;
            //打開資料庫
            try
            {
                //cn.Open(strConn, "sa", "password", -1);
                cn.Open(strConn);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                Console.WriteLine(cn.State);
            }
            //打開記錄集
            rs = new ADODB.Recordset();
            rs.LockType = ADODB.LockTypeEnum.adLockPessimistic;
            rs.CursorType = ADODB.CursorTypeEnum.adOpenDynamic;
            rs.Open("MSG_Outbox",cn);
            //如果記錄集為空，輸出一個錯誤資訊
            for (int i = 0; i < 10;i++ )
            {
                rs.MoveLast();
                object missing = System.Reflection.Missing.Value;
                rs.AddNew(missing, missing);

                //第0列為自增列，忽略
                rs.Fields[1].Value = "2";
                rs.Fields[2].Value = "";
                rs.Fields[3].Value = "11111111";
                rs.Fields[4].Value = "0";
                rs.Fields[5].Value = "打發打發dfadafdadafde";
                rs.Fields[6].Value = "";
                rs.Fields[7].Value = "2016/10/1 22:23:48";
                rs.Fields[8].Value = 12;
                rs.Update();
            }

            rs.Close();
            cn.Close();


            

        }
           

posted on 2016-10-02 00:12 飄揚De黑夜 閱讀( ...) 評論( ...) 編輯 收藏

轉載于:https://www.cnblogs.com/volts0302/p/5926699.html