connect to sql server

[ppl1]

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

  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

[aniskhan]

i would tried it this way

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()

[ppl1]

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?

[aniskhan]

whts the error

[ppl1]

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

[aniskhan]

try this instead of

datagrid1.dataBind
Me.dataBind

[aniskhan]

Take a look at this Sample