C# (CSharp) CreateTable SqlLiteDBHelper.ExecuteReader Beispiele

ExecuteReader() public method

执行一个查询语句，返回一个关联的SQLiteDataReader实例

public ExecuteReader ( string sql, SQLiteParameter parameters ) : SQLiteDataReader
sql	string	要执行的查询语句
parameters	System.Data.SQLite.SQLiteParameter	执行SQL查询语句所需要的参数，参数必须以它们在SQL语句中的顺序为准
return	System.Data.SQLite.SQLiteDataReader

Beispiel #1

        static void ShowPassWord()
        {
            string dbPath = "E:\\data.db";
            //查询从50条起的20条记录
            string sql = "select PassWord  from t_user where UserCode = @UserCode";

            SQLiteParameter[] parameters = new SQLiteParameter[] {
                new SQLiteParameter("@UserCode", "zealfung0")
            };
            SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);

            using (SQLiteDataReader reader = db.ExecuteReader(sql, parameters))
            {
                while (reader.Read())
                {
                    Console.WriteLine("PSWD:{0}", reader.GetString(0));
                }
            }
        }

Beispiel #2

 static void ShowData()
 {
     try
     {
         string dbPath = "E:\\data.db";
         //查询从50条起的20条记录
         string          sql = "select * from t_user";
         SqlLiteDBHelper db  = new SqlLiteDBHelper(dbPath);
         using (SQLiteDataReader reader = db.ExecuteReader(sql, null))
         {
             while (reader.Read())
             {
                 Console.WriteLine("ID:{0},TypeName{1}", reader.GetString(0), reader.GetString(1));
             }
         }
     }
     catch (Exception ex)
     {
         Console.WriteLine("ShowData失败：" + ex.ToString());
     }
 }

Beispiel #3

Datei: Program.cs Projekt: JimmyFung/DesktopHelper

 static void ShowPassWord()
 {
     string dbPath = "E:\\data.db";
     //查询从50条起的20条记录
     string sql = "select PassWord  from t_user where UserCode = @UserCode";
     SQLiteParameter[] parameters = new SQLiteParameter[]{
                                  new SQLiteParameter("@UserCode","zealfung0")
                                  };
     SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
     using (SQLiteDataReader reader = db.ExecuteReader(sql, parameters))
     {
         while (reader.Read())
         {
             Console.WriteLine("PSWD:{0}", reader.GetString(0));
         }
     }
 }

Beispiel #4

Datei: Program.cs Projekt: JimmyFung/DesktopHelper

 static void ShowData()
 {
     try
     {
         string dbPath = "E:\\data.db";
         //查询从50条起的20条记录
         string sql = "select * from t_user";
         SqlLiteDBHelper db = new SqlLiteDBHelper(dbPath);
         using (SQLiteDataReader reader = db.ExecuteReader(sql, null))
         {
             while (reader.Read())
             {
                 Console.WriteLine("ID:{0},TypeName{1}", reader.GetString(0), reader.GetString(1));
             }
         }
     }
     catch (Exception ex)
     {
         Console.WriteLine("ShowData失败：" + ex.ToString());
     }
 }