ADO.Net 之 Access批量Insert

 跟SQLServer批量insert步骤一样:

1,构造DataTable

        /// <summary>
        /// 构造Table
        /// </summary>
        /// <returns></returns>
        public DataTable BuildTable()
        {
            try
            {
                DataTable dt = new DataTable("Person");//与目标表名一致
                DataColumn ID = dt.Columns.Add("ID", typeof(String));
                ID.AllowDBNull = false;//空值
                ID.Unique = true;//唯一
                dt.Columns.Add("ksj", typeof(String));
                return dt;
            }
            catch (Exception ex)
            {
                return null;
            }
        }

2,封装并为Table赋值

            DataTable dt =BuildTable();
            for (int i = 0; i < 10000; i++)
            {
                DataRow dr = dt.NewRow();