ExecuteReader() публичный Метод

执行一个查询语句,返回一个关联的SQLiteDataReader实例
public ExecuteReader ( string sql, SQLiteParameter parameters ) : SQLiteDataReader
sql string 要执行的查询语句
parameters System.Data.SQLite.SQLiteParameter 执行SQL查询语句所需要的参数,参数必须以它们在SQL语句中的顺序为准
Результат System.Data.SQLite.SQLiteDataReader
Пример #1
0
        public static void ShowData()
        {
            //查询从50条起的20条记录
            string         sql = "select * from test3 order by id desc limit 50 offset 20";
            SQLiteDBHelper db  = new SQLiteDBHelper("D:\\Demo.db3");

            using (SQLiteDataReader reader = db.ExecuteReader(sql, null))
            {
                while (reader.Read())
                {
                    Console.WriteLine("ID:{0},TypeName{1}", reader.GetInt64(0), reader.GetString(1));
                }
            }
        }