i'm lost!

V

ValiantKhan

Member
Joined
Aug 4, 2003
Messages
8
Howdy, Ive 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 im just not doing things right.

Im used to taking recordsets out of my sql db using the ole adodb stuff. Rs!Field = variable etc etc. Thats how I always did my stuff before. but i think its 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 im lost and am in need of some good help.

I thank yall for any help. Thanks!

--Val
 
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
 
Kewl Kewl, thanks for the input guys.

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

--SQL commands.

Im 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 ive read something about having a new way to query commands to the db.

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

--Val
 
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
 
Back
Top