public static void ShowData() { //查询从50条起的20条记录 string sql = "select * from test3 order by id desc limit 50 offset 20"; SQLiteDBHelper db = new SQLiteDBHelper(testDatabaseName); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { Console.WriteLine("ID:{0},TypeName{1}", reader.GetInt64(0), reader.GetString(1)); } } }
protected override void UpdateUI() { SetCol(); dataGridView.Rows.Clear(); SQLiteDBHelper db = new SQLiteDBHelper(datebaseName); string sql = "select * from " + existFilessName; using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { int index = 0; while (reader.Read()) { dataGridView.Rows.Add(); dataGridView.Rows[index].Cells[GetColIndex("序号")].Value = index.ToString(); dataGridView.Rows[index].Cells[GetColIndex("文件名")].Value = reader["name"].ToString(); ++index; } } }
public void UpdataGridView(ArrayList FileInfoCollector) { SetCol(); dataGridView1.Rows.Clear(); dataGridView1.Rows.Insert(0, 100); int serialIndex = FileUtilty.GetDataGridViewIndex(dataGridView1, "序号"); int fileNameIndex = FileUtilty.GetDataGridViewIndex(dataGridView1, "文件名"); int pathIndex = FileUtilty.GetDataGridViewIndex(dataGridView1, "路径"); const string dbPath = ExistFiles.dbPath; if (!System.IO.File.Exists(dbPath)) { return; } SQLiteDBHelper db = new SQLiteDBHelper(dbPath); string sql = "select * from " + ExistFiles.existFilessName; using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { int index = 0; while (reader.Read()) { if (index > dataGridView1.Rows.Count - 2) { dataGridView1.Rows.Add(); } dataGridView1.Rows[index].Cells[serialIndex].Value = index.ToString(); dataGridView1.Rows[index].Cells[fileNameIndex].Value = reader["name"].ToString(); dataGridView1.Rows[index].Cells[pathIndex].Value = reader["filePath"].ToString(); ++index; } } }