Sqlite数据库使用事务处理一例

Sqlite使用事务批量添加记录：(请多多支持)

        private void button3_Click(object sender, EventArgs e)
        {
            SQLiteConnection sconn = new SQLiteConnection(); //创建连接
            SQLiteCommand cmd = null;                                      
            SQLiteDataReader sdr = null;
            string _tel = telnum.Text;
            string _tel2 = "";
            sconn.ConnectionString = _connectionString;
            try
            {
               sconn.Open();
               using (SQLiteTransaction dbTrans = sconn.BeginTransaction()) //使用事务
               {
                   using (cmd = sconn.CreateCommand())
                   {
                     cmd.CommandText = "INSERT INTO webtel(tel,adddt) VALUES(?,?)";
                     SQLiteParameter Field1 = cmd.CreateParameter();   //添加字段
                     SQLiteParameter Field2 = cmd.CreateParameter();
                     cmd.Parameters.Add(Field1);
                     cmd.Parameters.Add(Field2);
                     for (int n = 0; n <= 100; n++)
                     {
                         _tel2 = "0000" + n.ToString();
                         Field1.Value =_tel.ToString()+_tel2.Substring((_tel2.Length-4),4).ToString(); //字符赋值
                         Field2.Value = System.DateTime.Now;
                         cmd.ExecuteNonQuery();
                     }
                   }
                   dbTrans.Commit();     //提交事务执行
                   textBox1.Text = _tel+"批量添加成功";
               }
            }
            catch
            {

            }
            finally
            {

                sconn.Close();
            }
           
        }