关于C#里面SQLite读取数据的操作
时间:2022-03-13 22:55
做C#朋友的一个获取DataSet函数,对C#不熟,整理整理,了解怎么用
//挂载表格时候用
public static DataSet Query(string SQLString) { using (SQLiteConnection connection = new SQLiteConnection(connectionString)) { DataSet ds = new DataSet(); try { connection.Open(); SQLiteDataAdapter command = new SQLiteDataAdapter(SQLString, connection); command.Fill(ds, "ds"); } catch (System.Data.SQLite.SQLiteException ex) { throw new Exception(ex.Message); } return ds; //返回的是一个DataSet } }
应用:
挂载表格的时候直接用
Grd.DataSource=Query(SQL).Tables[0]
/// 执行查询语句,返回SQLiteDataReader//获取返回值用 /// </summary> /// <param name="strSQL">查询语句</param> /// <returns>SQLiteDataReader</returns> public static SQLiteDataReader ExecuteReader(string strSQL) { SQLiteConnection connection = new SQLiteConnection(connectionString); SQLiteCommand cmd = new SQLiteCommand(strSQL, connection); try { connection.Open(); SQLiteDataReader myReader = cmd.ExecuteReader(); return myReader; } catch (System.Data.SQLite.SQLiteException e) { throw new Exception(e.Message); } }
应用
SQLiteDataReader SqlDr = DbSQLite.ExecuteReader(sql); //SQLiteDataReader需要先引用,using System.Data.SQLite; try { while(SqlDr.Read()){ int rn = SqlDr.GetInt32(1); string rname=SqlDr.GetValue(0).ToString(); //字段读取方式 if (rn == 5) { //if (rname.Equals("1")) //{ // str += SqlDr.GetValue(2).ToString() + "是" + "\r\n"; //} //else { // str += SqlDr.GetValue(2).ToString() + "否" + "\r\n"; //} } }catch { }
关于C#里面SQLite读取数据的操作,布布扣,bubuko.com