i'm lost!

[ValiantKhan]

Howdy, I've just finally migrated from VB 6 and have been trying to wonder about the database programming area. but it seems to have changed quite a bit from vb6 or maybe i'm just not doing things right.

 

I'm used to taking recordsets out of my sql db using the ole adodb stuff. Rs!Field = variable etc etc. That's how I always did my stuff before. but i think it's a lot different than that.. maybe not..

 

Does anyone know of anywhere they can point me that has some good newbie stuff for SQL database with .net? Because i'm lost and am in need of some good help.

 

I thank ya'll for any help. Thanks!

 

--Val

[dpifer]

This is what helped me out...and yes it is totally different yet very very powerful!

 

Between this site, vbCity.com forums, vbdotnetheaven.com and this book - Microsoft ADO.NET (Core Reference)

I was able to get up to speed fairly quickly.....

 

 

Hope this helps,

 

Dave

[mutant]

This page has some useful info, and some short tutorials:

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/adoplus/adoplusoverview.aspx

[ValiantKhan]

Kewl Kewl, thanks for the input guys.

 

Got a few questions maybe you all can answer for me.

 

--SQL commands.

 

I'm making a basic little program that the user enters a username to search thru the database ( MySQL) and then if it finds that username in the db it fills some text boxes in with some other information about that user.

 

The whole database adapter, connection, readers etc. thing has got me kinda confused. If say I wanted to get the text from the username box and compare it to the field 'username' in my db. how am i supposed to execute the command to select the field ... before i always did like Rs!Field = variable, etc etc. How am i supposed to exec. commands now? I saw that i can still reference to some adodb stuff and have some of the old commands but i've read something about having a new way to query commands to the db.

 

Anywho.. i'm probably rambling nonsense. I'll see if i can go read some more and understand this a bit better. Thanks for the links guys. Appreciate it.

 

--Val

[ValiantKhan]

Ok, I think I answered my own question, but anywho.

 

In VB6, you had to make a reference to ado for your project, then you could use adodb recordsets , connections, etc.

 

Can you still use this method in .NET? Or is it taken over by the dataadapters, readers etc. ?

 

If so, which way is easiest and most secure?

 

Thanks for any input.

 

--Val