将SQLite数据库data.db中的表显示到窗体的DataGridView控件中

string ConnectStr = "Data Source=data.db";

            string SearchComm = "select * from abgc";

            SQLiteConnection selectConnection = new SQLiteConnection(ConnectStr);

            DataSet dataSet = new DataSet();

            if (selectConnection.State != System.Data.ConnectionState.Open) {

                selectConnection.Open();

                SQLiteCommand cmd = selectConnection.CreateCommand();

                cmd.CommandText = SearchComm;

                SQLiteDataAdapter adapter = new SQLiteDataAdapter(cmd);

                adapter.Fill(dataSet);

                selectConnection.Close();

            }

            dataGridView1.DataSource = dataSet.Tables[0];