ASP.Net: Check if SqlDataReader has no rows using VB.Net

Hi makumbi,

Use HasRows property of SqlDataReader class to check there is any record or not.

Dim strConnString As String = ConfigurationManager.ConnectionStrings("SMIS2022ConnectionString").ConnectionString
Using con As SqlConnection = New SqlConnection(strConnString)
    Using cmd As SqlCommand = New SqlCommand()
        cmd.CommandText = "SELECT * From Archivemax"
        ' cmd.Parameters.AddWithValue("@Id", ID)
        cmd.Connection = con
        con.Open()
        Dim sdr As SqlDataReader = cmd.ExecuteReader()
        If sdr.HasRows Then
            sdr.Read()
            Monthed.Text = sdr("Month").ToString()
            Expr2.Text = sdr("Expressed").ToString()
            types2term1.SelectedValue = sdr("Type").ToString()
            'k4.Text = sdr("r4").ToString()
        Else
            'Message to show does not have values.
        End If
        con.Close()
    End Using
End Using