新人关于数据库有关问题

新人关于数据库问题
刚从DELPHI转到VB.NET，迷茫中~

有个问题想麻烦问下大家
 

我用SQL查询数据库
  Dim a As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;data source=system.accdb") '选择数据库
  Dim sql As New OleDbCommand
  sql.Connection = a
  sql.CommandText = "select * from 库存 where 类别 = '商品'"
 
然后查询到的值我怎么放到DataGridView控件中去呢？
 麻烦大家了~
 

[解决办法]

C# code

SqlDataAdapterprivate void button3_Click(object sender, EventArgs e)        {             string cnn_char = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDB.mdf;Integrated Security=True;User Instance=True";             using (SqlConnection conn = new SqlConnection(cnn_char))             {                 conn.Open();                 using (SqlCommand cmd = conn.CreateCommand())                 {                     cmd.CommandText = "Select * from T_User";                     DataSet dataset = new DataSet();                     SqlDataAdapter adapter = new SqlDataAdapter(cmd);//将SqlCommand与SqlDataAdapter绑定                     adapter.Fill(dataset);                     DataTable table = dataset.Tables[0];                     dataGridView1.AutoGenerateColumns = true;                     dataGridView1.DataSource = table; //赋值DataGridView的DataSource属性来绑定                      }             }        }
[解决办法]
VB.NET code
Dim cnn_char As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDB.mdf;Integrated Security=True;User Instance=True"dim conn As New SqlConnection(cnn_char)conn.Open()dim cmd As SqlCommand = conn.CreateCommand()        cmd.CommandText = "Select * from T_User"        Dim dataset As New DataSet()        Dim adapter As New SqlDataAdapter(cmd)        '将SqlCommand与SqlDataAdapter绑定        adapter.Fill(dataset)        Dim table As DataTable = dataset.Tables(0)        dataGridView1.AutoGenerateColumns = True            '赋值DataGridView的DataSource属性来绑定             dataGridView1.DataSource = table