VS 2005 ADO.Net Basics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 31 Oct 2007 17:13 GMT

Hi everyone,

I'm a VB6 developer who has recently installed Visual Studio 2005 and I want
to get my hands dirty with VB.NET 2005! I'm struggling with database
connections, and I mean floundering!

Most of the examples I've found have been using forms and controls but I
would like to do it all in code. You could set up a connection and recordset
very easily in classic ADO so I don't suppose it's that hard but I'm stuck.
All I want to do is create a connection to a SQL database, query a table (any
table) and then set the value of a string variable with the value of a field
in my returned records.

Can anyone give me a basic example to set me on my way?

I would really appreciate it.

Thanks in advance for any help
Paul

Reply to this Message

Jan Hyde (VB MVP) - 31 Oct 2007 17:48 GMT

Paul <Paul@discussions.microsoft.com>'s wild thoughts were
released on Wed, 31 Oct 2007 09:13:00 -0700 bearing the
following fruit:

>Hi everyone,
>
[quoted text clipped - 10 lines]
>
>Can anyone give me a basic example to set me on my way?

First step would to post to a dotnet group, this is a VB6
one.

Look for groups with 'dotnet' in the name.

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

Reply to this Message

William Vaughn - 31 Oct 2007 18:17 GMT

I wrote a book just for you. See www.betav.com. It has a wealth of examples
and best practices designed to help the VB6 developer move into .NET.

Connections can be a complex issue. See my whitepaper on ADO.NET connecting.
http://betav.com/blog/billva/2006/06/getting_and_staying_connected_1.html

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

> Hi everyone,
>
[quoted text clipped - 20 lines]
> Thanks in advance for any help
> Paul

Reply to this Message

VB Forum / Database Access / October 2007

VS 2005 ADO.Net Basics