在VB里
Dim cnstring As String
Dim cn As New SqlConnection
Dim com As New SqlCommand
Dim da As New SqlDataAdapter(com)
cnstring = "server=.;database=northwind;uid=sa;password=sa"
cn = New SqlConnection(cnstring)
cn.Open()
com.Connection = cn
com.CommandText = "select * from customers"
Dim ds As New DataSet
da.Fill(ds, "Customers")
DataGrid1.DataSource = ds.Tables(0).DefaultView
DataGrid1.DataBind()
C#