Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
Private da As SqlDataAdapter
Private ds As New DataSet()
Private cnn As New SqlConnection()
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cnn.ConnectionString = "server=servername;user id=userid;password=password;database=databasename"
cnn.Open()
da = New SqlDataAdapter("select * from tablename", cnn)
da.Fill(ds, "tablename")
DataGrid1.DataSource = ds.Tables(0)
End Sub
End Class