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;
}
}
}
