Need help filling datagridview from stored procedure which fills data reader

[DougP]

VB.NET 2010
I used this code in ASPNET 4.0 page with success. But now in the Desktop world not sure how to bind it?
If I take out the Me.DataGridView1.DataBindings line, I do not get an error but the grid is empty.
I takes a while to run so I am sure its filling the reader.

TIA

        Dim cnn As SqlConnection
        Dim cmd As New SqlCommand
        Dim Retval As String = ""
        Dim connStr As String = gblConnectionString
        cnn = New SqlConnection(connStr)
        Try
            cnn.Open()
            With cmd
                .Connection = cnn
                 .CommandText = "uspGetLdapHierarchyByTopEid"
                .CommandType = CommandType.StoredProcedure
                .Parameters.AddWithValue("sTopEid", Me.cboChooseEnterpriseID.Text)
                .Parameters(0).SqlDbType = SqlDbType.NVarChar
                Me.DataGridView1.DataSource = .ExecuteReader() 
                Me.DataGridView1.DataBindings(  <<<<< ????
            End With
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

DougP

 

[DougP]

I found this which is very simple and works great.
I have a stored procedure and am just calling it with one parameter in a SQL string.

       Dim cn As New SqlClient.SqlConnection
        cn.ConnectionString = gblConnectionString
        Dim strSQL As String = "EXEC uspGetLdapHierarchyByTopEid " & Me.cboChooseEnterpriseID.Text & ";"
        Dim strCon As String = gblConnectionString
        Dim dataAdapter As New SqlClient.SqlDataAdapter(strSQL, strCon)
        Dim table As New DataTable
        dataAdapter.Fill(table)
        DataGridView1.DataSource = table

DougP