从已有的数据库读取数据显示到winform的datagridview控件,具体代码如下:
//判断有无表
if (sqliteConn.State == ConnectionState.Closed) sqliteConn.Open();
SQLiteCommand mDbCmd = sqliteConn.CreateCommand();
mDbCmd.CommandText = "SELECT COUNT(*) FROM sqlite_master where type='table' and name='" + TableDbFile + "';";
int row = Convert.ToInt32(mDbCmd.ExecuteScalar());
if (row <= 0)
{
MessageBox.Show("数据表不存在,无法查询");
return;
}
//初始化数据表
mAdapter = new SQLiteDataAdapter("SELECT * FROM [" + "SOPFileTable" + "]", sqliteConn);//这里写你的查询语句
DataSet ds = new DataSet();
mAdapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
sqliteConn.Close();