本文共 1636 字，大约阅读时间需要 5 分钟。

1，查询表名集合

SELECT name FROM sqlite_masterWHERE type='table'ORDER BY name;

public static bool deleteAllData()        {            bool res = false;            SQLiteConnection conn = null;            DbTransaction trans = null;            try            {                string sql = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";                DataSet ds = new DataSet();                ds = CommonBll.getDataSetBySql(sql, Constant.SQLITE_FLAG);                if (ds != null && ds.Tables[0].Rows.Count > 0)                {                    using (conn = SqliteHelper.GetConnection())                    {                        var cmd = new SQLiteCommand(conn);                        //开始事务                        trans = conn.BeginTransaction();                        //while (dr.Read())                        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)                        {                            string dSql = "delete from " + ds.Tables[0].Rows[i][0].ToString();                            cmd.CommandText = dSql;                            cmd.ExecuteNonQuery();                        }                        //提交事务                        trans.Commit();                        Console.ReadLine();                        //ds.Close();                        //成功标识                        res = true;                    }                }            }            catch (Exception ex)            {                res = false;                trans.Rollback();            }            finally            {                trans.Dispose();            }            return res;        }

转载地址：http://pjbsi.baihongyu.com/