Migrating from ADODB(RECORDSET) to VB.NET

See more:

VB

SQL-Server-2008

Hi, I just want to ask about my problem in my vb.NET project since I was before using ADODB(from my past experience on vb6).

I'm just NEW on using SQLClient namespace on vb.NET and find out that it works or fits on my project perfectly.

My question is this,

"Is there any way or a code using SQL command property or anything, that will function just the same as "rs.EOF" from my previous project that was using ADODB(Recordset/rs)? Is there also a property of SQLCommand that will functioned the same as ".EOF" property of recordset?"

Thanks for who might help me.

What I have tried:

If Not rs.EOF Then
  If Not rs = DBNull.Value Then
  'DateReceived = rs![Date]
   xlApp.Sheets("Sheet1").Cells(RPos, "D").NumberFormat = "mm/dd/yy"
   xlApp.Sheets("Sheet1").Cells(RPos, "D").Value = DateReceived
  End If
End If

~ rs codes were from my previous project that was using adodb namespace, I'm now using sqlclient namespace so I need to convert these codes to work for my new namespace.