C# 操作sqlite,实现增删改查
1. 添加sqlite引用
2.添加sqliteHelper类,实现增删改查功能,sqlite文件名默认:MydataBase.db
1 /// <summary> 2 /// 查询数据 3 /// </summary> 4 /// <param name="SQL"></param> 5 /// <param name="db"></param> 6 /// <returns></returns> 7 public static DataTable SelectDB(string SQL, string db = "MydataBase") 8 { 9 DataTable dt = new DataTable(); 10 try 11 { 12 LogHelper.ServiceLog("查询数据,SQL:"+SQL); 13 string dbFile = System.AppDomain.CurrentDomain.BaseDirectory + db + @".db"; 14 string connString = string.Format("Data Source={0};Pooling=true;FailIfMissing=false", dbFile); 15 SQLiteConnection conn = new SQLiteConnection(connString); 16 SQLiteDataAdapter adapter = new SQLiteDataAdapter(SQL, conn); 17 DataSet ds = new DataSet(); 18 adapter.Fill(ds); 19 dt = ds.Tables[0]; 20 //关闭连接,释放资源 21 conn.Close(); 22 conn.Dispose(); 23 adapter.Dispose(); 24 } 25 catch (Exception ex) 26 { 27 LogHelper.ServiceLog("查询异常:" + ex.ToString()); 28 return dt; 29 } 30 return dt; 31 } 32 33 #region 增删改数据 34 /// <summary> 35 /// 增删改数据 36 /// </summary> 37 /// <param name="SQL"></param> 38 /// <param name="db">操作的数据库名称</param> 39 /// <returns></returns> 40 public static bool OperationDB(string SQL, string db = "MydataBase") 41 { 42 43 try 44 { 45 LogHelper.ServiceLog("增删改数据,SQL:"+SQL); 46 string dbFile = System.AppDomain.CurrentDomain.BaseDirectory + db + @".db"; 47 string connString = string.Format("Data Source={0};Pooling=true;FailIfMissing=false", dbFile); 48 SQLiteConnection conn = new SQLiteConnection(connString); 49 conn.Open(); 50 string Sql = string.Format(SQL); 51 SQLiteCommand insertData = new SQLiteCommand(Sql,conn); 52 insertData.ExecuteNonQuery(); 53 conn.Close(); 54 } 55 catch (Exception ex) 56 { 57 LogHelper.ServiceLog("增删改数据,异常:" + ex.ToString()); 58 return false; 59 } 60 return true; 61 } 62 63 #endregion
3.调用sqliteHelper类
1 string sql = " select * from PayTable "; 2 var dt = SqliteHelper.SelectDB(sql); 3 string insertSql = "INSERT INTO PayTable( XmlDa 4 var dt= SqliteHelper.OperationDB(insertSql);