SQL Vb.net read table : i have database and table name restaurant..
in this table there is columns name "time" and "tableno",this table have 20 rows,
i also have this code:

         
        Dim connString As String = "server=DESKTOP-69QA9LH\SQLEXPRESS; database=servicedb; integrated security=true"
        Dim conn As New SqlConnection(connString)
        Dim command As SqlCommand
        Dim reader As SqlDataReader
         
        conn.Open()
        Dim query As String
        query = "select time,tableno from restaurant "
        command = New SqlCommand(query, conn)
        reader = command.ExecuteReader
        reader.Read()
        Dim d1 As DateTime = ToolStripStatusLabel1.Text
        Dim d2 As DateTime = reader("time")
        Dim diff As Short = DateDiff(DateInterval.Minute, d2, d1)
    
        If reader("tableno") = "2" AndAlso diff = "5" Then

            Button3.BackColor = Color.LawnGreen
         End If
        
        
       If reader("tableno") = "2" AndAlso diff = "10" Then

            Button3.BackColor = Color.LawnGreen
        End If
       
    
       If reader("tableno") = "2" AndAlso diff = "15" Then

            Button3.BackColor = Color.LawnGreen
        End If

        If reader("tableno") = "1" AndAlso diff = "5" Then
            Button1.BackColor = Color.Brown
        End If
   
        If reader("tableno") = "1" AndAlso diff = "10" Then
            Button1.BackColor = Color.Brown

         End If
         If reader("tableno") = "1" AndAlso diff = "15" Then
            Button1.BackColor = Color.Brown

        End If




its work well,but problem is that its only read only 1st row in database.
i mean,when i click button to process this code ,buttons change background color based only on first row from database.
row with table 2 is 1st row,and i can change background color.
but table 1 is 2nd row and i cant read this row to change background color.


how can i make it work with others rows.
thanks