GridView is not being populated with data

[dougancil]

I have the following code:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dt As DataTable
        Dim connectionString As String = "Initial Catalog=mdr;Data Source=xxxxx;uidxxxxx;password=xxxxx"
        Dim con As New SqlConnection(connectionString)
        Dim cmd As New SqlCommand
        con.Open()
        cmd.Connection = con
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "getoncall"
        cmd.Parameters.AddWithValue("@subschedule", TextBox1.Text)
        Using da As New SqlDataAdapter(cmd)
            dt = New DataTable
            da.Fill(dt)
            con.Close()
            GridView1.DataSource = dt
            GridView1.DataBind()
        End Using
 

and when I debug this code, I can see that my count in my Rows = {System.Data.DataRowCollection} is 1, which means that I'm getting the data, but I don't see anything in my datagridview. Can someone please tell me why?

Thank you

Doug

[vivek kapile]

Hi Doug,

Same code i tried in my PC, It was working fine.I think you are not getting data properly.please check
1.Check the connection.
2.Check the stored procedure what it accept parameter weather it is int or string.

Thanks
Vivek Kapile