Hi all,

Hope someby can help me.

I am starting to design in Visual Studio 2008 and I am designing a web application that connects to a SQL database. In VB6 I could create a record set and read its contents as follows.

SQLCommand = "SELECT * FROM Tablename WHERE field = '" & data & "'"

Recordset.Open SQLCommand, Database, adOpenDynamic

If Recordset.EOF = True Then
MsgBox "Record does not exist!", , "Record does not exist"
End If

Then I would Bind the fields data to, say a text box like this

Textbox.Text=Recordset("Field1")

I am finding dificult to do this in Visual Studio 2008. Does anybody know how to create a recordset in Visual Basic 2008 as described above.

I have been reading a lot, watching traing videos, and researching on the Internet and I have not found any source which will explain how to do it.

Any help would be appreciated.

Thanks.