title: No data exists for the row/column in vb.net using sql serverce 2008
body: <pre><code>   Try
                  If conn.State &lt;&gt; ConnectionState.Open Then
                      conn.Open()
                  End If
                  scmd.CommandText = "select bal, billamnt  from bills "
                  Dim drr2 As SqlCeDataReader
                  drr2 = scmd.ExecuteReader
                  If drr2.Read Then
                      bal = dta(drr("bal"))
                  End If
              Catch ex As Exception
  
              End Try
  
          Catch ex As Exception
  
          End Try
  </code></pre>
  
  <p>i am getting error in drr2  the error is :No data exists for the row/column while drr1 is executing </p>
  
  <p>please sove it in vb.net </p>