hi,

I have been using MS ACCESS since I started working in VB. But now I am just starting with SQL SERVER(Desktop edition).

I would like to know how do I select a recordset in sqlserver as I did in MS ACCESS??

eg in Access I used

dim rs as adodb.recordset
dim str as string
set rs a= new adodb.recordset

str="select * from table1"

rs.open str,cn........ etc etc

if rs.recordcount>0 then
.
.
.
.end if
I want to know how do I do the same thing but with a table from SQL SERVER