给一个源程序你看看就明白了:
前提条件是,你已经在窗体上放置了一datagrid控件
Dim connect As String = "server=JNSEVER1;database=xingxing;uid=sa;pwd="
Dim conn As New SqlConnection(connect)
Dim list As New SqlDataAdapter("select * from table1", conn)
Dim dt As New DataTable()
list.Fill(dt)
DataGrid1.DataSource = dt.DefaultView
就这么简单
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "作者")
MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub