sql database example

[TennesseeFox]

Hello, Ive been working on a sql server 2000 db with vb.net front end. Ive used the dataform wizard to create it and it works fine, it created it with oledbconnection and data adapters.
I have tried to make a sql connection and data form from scratch but It doesnt want to work for me.

Is there any difference between oledb and sqlconnections??? as far as usability and performance (is it worth trying to redo it with sql from scratch)
and

Does anyone have a good tutorial on how to make a sql dataform from scratch either program or link???

All the books ive looked thru want to use a datagrid.
I would like to have a single record form with a set of navagation buttons. with add,update, delete and cancel ability. Also ability to open a child form displaying the same record number as the main (and ability to update or even create a new one if it doesnt exist.)

I didnt think this would be too hard to find since it seems to be a typical database application.

Thanks for the help

Tenn

 

[hmckillop]

The gotdotnet site is very good for examples in both C# and VB.NET.
As far as I know sqlconnections have been designed specifically by Microsoft for their own product SQL Server and as such is likely to be more performant and also make use of all features available as opposed to the more generic oledb.

So have a look at either

http://samples.gotdotnet.com/quickstart/howto/

or

http://www.programmersheaven.com/2/VB-NET-School

I prefer the gotdotnet site, its got failry much everything you would need

"I'm living so far beyond my income that we may almost be said to be living apart