VB 2008 / SQL Server 2008 - Recordset Retrieval via Stored Proc.

[bmccollum]

I'm pretty new with Visual Studio 2008 but have done VB6 development for the past 8 years straight.

I'm trying to figure out how to rewrite a couple of personal VB6 apps. at home just for fun and for a learning experience w/VB 2008.

I typically don't retrieve any data into my VB apps. w/just straight SQL queries... I always utilize stored procedures in SQL and call those via the VB apps... much cleaner VB coding that way in my opinion.

(I'm talking about Windows Forms development here... just an FYI...)

I can't for the life of me figure out the exact syntax that I'll need to use in Visual Basic 2008 in order to (for example) retrieve a list of values, let's say, into a combobox. I can do that in my sleep in VB6, but I'm just behind the learning curve w/the syntax in .NET to do that.

Anyone have any specific code snippets/examples that they could post for me in knowing the appropriate syntax to use in retrieving records into a recordset in VB.NET via a SQL Server stored procedure?

Many thanks!

[kmoorman]

bmccollum,

Is there a reason why you want to use ADO with VS2008 instead of ADO.Net?

Kerry Moorman

[Phil Weber]

You may find this helpful: http://msdn.microsoft.com/en-us/library/ms973824.aspx

[bmccollum]

I'm perfectly fine using ADO.Net... as I mentioned before, I'm way behind the learning curve in having been doing VB6 development for so long, so I'm likely unaware of several new/preferred technologies with VB 2003/2005/2008.

bmccollum,

Is there a reason why you want to use ADO with VS2008 instead of ADO.Net?

Kerry Moorman

[bmccollum]

I typically use unbound recordsets (aka disconnected recordsets) in VB6... do you have the choice of bound/unbound recordsets in VB.net 2008 or are they all unbound, all bound, etc?

[kmoorman]

bmccollum,

Recordsets as such don't exist in ADO.Net.

ADO.Net is a completely disconnected data architecture. There is no direct support for server-side cursors, etc.

You might want to start by looking into ADO.Net's connection, command and datareader classes.

Another area to invesigate is ADO.Net's dataadapter, dataset and datatable classes.

Also keep in mind that the various data access classes are grouped together based on the particular database being accessed. So, for example, SQL Server uses the SQLClient namespace with its SQLConnection, SQLCommand and SQLDataReader classes. MS Access uses the OleDb namespace with its OleDbConnection, OleDbCommand and OleDbDataReader classes. Etc.

Kerry Moorman

[bmccollum]

Many thanks for all of the helpful postings... I'll check into the various items/links a few of you posted... thanks again...

[Hack]

Hopefully you will find this helpful with respect to ADO.NET