connect to sql server

what is wrong in my code? i cant see the records of the dataBase

Code:

---

  If (Not Page.IsPostBack) Then
            Dim con As SqlConnection = New SqlConnection  ("Server=localhost;Database = Northwind;Integrated Security = SSPI;")

            Dim cmd As SqlCommand = New SqlCommand("select * from Customers", con)
            cmd.Connection.Open()
            Dim reader As SqlDataReader
            reader = cmd.ExecuteReader()
            datagrid1.DataSource = reader
            datagrid1.DataBind()

            cmd.Connection.Close()
                End If

---

thanks in advanced

i would tried it this way

Code:

---

Dim con As SqlConnection = New SqlConnection  ("Server=localhost;Database = Northwind;Integrated Security = SSPI;")
        Dim da As New SqlDataAdapter()
        Dim dataset As New DataSet()
        Dim cmd As SqlCommand = New SqlCommand("select * from Customers", con)
        cmd.Connection.Open()
        da.SelectCommand = cmd
        da.Fill(DataSet, "Customers")
        Me.DataGrid1.SetDataBinding(dataset, "Customers")
          cmd.Connection.Close()

---

im getting an error on SetDataBinding so i tried to use dataSource+dataBind
but its still not working, i cant see anything.
what else can it be?

whts the error

'SetDataBinding' is not a member of 'System.Web.UI.WebControls.DataGrid'

try this instead of

Code:

---

datagrid1.dataBind
Me.dataBind

---

Take a look at this Sample