Author: oluts | Posted on: 11/8/2010 1:43:54 PM | Views : 284

Hello All,
I have a sqlstatement on my code behind and would like to do 3 things
1) check if result is one or more that one(Even thou i dont have a count on my statement)
2) if its one row....read the first two columns
3) if its more than one....read the first two columns of each row.
Basically i can get the first two columns of a row... but i just do not know how to check for #of rows and read the rows if its more than one. Here is my code
Dim objConnection As SqlConnection
        Dim objCommand As SqlCommand
        Dim strSQLQueryBank As String
        Dim sqla As SqlDataReader



        objConnection = New SqlConnection("Data Source=CNU0025G7X;Initial Catalog=Sendero;Integrated Security=True")
        objConnection.Op ...

Go to the complete details ...