C# SQLite数据库操作类

01using?System; 02 System.Collections.Generic; 03 System.Linq; 04 System.Text; 05 System.Configuration; 06 System.Data.sqlite; 07 System.Data; 08 namespace?DBHelper.sqlite 09{ 10????public?class?sqliteHelper 11 ????12 ????????static?string?_connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; 13 ????????sqliteConnection _connection; 14 ? 15 public?sqliteHelper() 16 { 17 ????????????_connection =?new?sqliteConnection(_connectionString); 18 } 19 sqliteHelper(connectionString) 20 :this() 21 22 _connectionString = connectionString; 23 } 24 25 void?Open() 26 27 ????????????if?(_connection.State != ConnectionState.Open) 28 ????????????????_connection.Open(); 29 30 Close() 31 32 (_connection.State != ConnectionState.Closed) 33 _connection.Close(); 34 35 ? 36 DataSet Query(sql) 37 38 return?Query(sql,?null); 39 40 41 sql,153)!important; background:none!important">params?sqliteParameter[] parameters) 42 43 ????????????//this.Open(); 44 sqliteCommand command = ExcDbCommand(sql,parameters); 45 DataSet ds =?DataSet(); 46 sqliteDataAdapter da =?sqliteDataAdapter(command); 47 da.Fill(ds); 48 //this.Close(); 49 ds; 50 51 52 bool?Exc(53 54 Exc(sql,monospace!important; font-size:10pt!important; min-height:auto!important; display:block!important; background:none!important">55 56 sqliteParameter[] parameters) 57 58 59 .Open(); 60 int?result = command.ExecuteNonQuery(); 61 .Close(); 62 result > 0; 63 64 sqliteDataReader Read(65 66 Read(sql,monospace!important; font-size:10pt!important; min-height:auto!important; display:block!important; background:none!important">67 68 69 70 71 72 sqliteDataReader reader = command.ExecuteReader(); 73 //this.Close(); 74 reader; 75 76 sqliteCommand ExcDbCommand( 77 78 sqliteCommand command =?sqliteCommand(sql,_connection); 79 command.CommandType = CommandType.Text; 80 (parameters ==?null?|| parameters.Length == 0) 81 ????????????????command; 82 foreach?(sqliteParameter param?in?parameters) 83 84 if(param !=?) 85 ????????????????????command.Parameters.Add(param); 86 87 88 89 90 }

以上文件可保存文件名为：sqliteHelper.cs

（编辑：北几岛）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

C# sqlite数据库操作类，可建立sqliteConnection 数据库连接、Query数据库、执行ExcDbCommand sql命令，以及sqliteParameter[] 、ExecuteReader()、ExecuteNonQuery()、sqliteDataAdapter等操作。