private void button1_Click(object sender, EventArgs e) { string strConn = GlobalHelp.DatabaseManagerDB; SQLiteHelper helper = new SQLiteHelper(strConn); DataTable dt = new DataTable(); DataColumn column = dt.Columns.Add("id"); column.AutoIncrement = true; DataColumn column1 = dt.Columns.Add("id1"); DataColumn column2 = dt.Columns.Add("id2"); DataColumn column3 = dt.Columns.Add("id3"); DataColumn column4 = dt.Columns.Add("id4"); for (int i = 0; i < int.Parse(textBox1.Text); i++) { DataRow dr = dt.NewRow(); for (int j = 1; j < dt.Columns.Count; j++) { dr[j] = Guid.NewGuid() + j.ToString(); } dt.Rows.Add(dr); } dt.TableName = "test1"; Stopwatch watch = new Stopwatch(); watch.Start(); helper.BatchInsert(dt); watch.Stop(); label1.Text = "耗时:" + watch.ElapsedMilliseconds; }