Resolved Select * from ...

[DekaFlash]

No data is returned to GridView even though matching data exists within my database.

Can anybody please assist?

Thanks

Private Sub PsButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PsButton.Click
        Dim sql As String = "SELECT * FROM VsrData WHERE PS=@PS"

        Try
            PsString = PS.Text
            psda = New SqlDataAdapter(sql, conn)

            psda.SelectCommand = New SqlCommand(sql, conn)
            psda.SelectCommand.Parameters.AddWithValue("@PS", PsString)

            builder = New SqlCommandBuilder(psda)

            conn.Open()

            psds.Clear()

            psda.Fill(racetypeds, "VsrData")

            VsrDataDataGridView.DataSource = psds.Tables("VsrData")

        Catch ex As Exception
            MsgBox(ex.ToString.Trim)
        End Try
        conn.Close()

    End Sub

 

[ScottyB]

Hi

You need to call DataBind as in the amended code below in order to bind your dataset to the grid.

Hope this helps

Regards

ScottyB

Private Sub PsButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PsButton.Click
        Dim sql As String = "SELECT * FROM VsrData WHERE PS=@PS"

        Try
            PsString = PS.Text
            psda = New SqlDataAdapter(sql, conn)

            psda.SelectCommand = New SqlCommand(sql, conn)
            psda.SelectCommand.Parameters.AddWithValue("@PS", PsString)

            builder = New SqlCommandBuilder(psda)

            conn.Open()

            psds.Clear()

            psda.Fill(racetypeds, "VsrData")

            VsrDataDataGridView.DataSource = psds.Tables("VsrData")
[B]            [COLOR=Red]VsrDataDataGridView.DataBind()[/COLOR][/B]


        Catch ex As Exception
            MsgBox(ex.ToString.Trim)
        End Try
        conn.Close()

    End Sub