Visual Basic Help [Database Connections]

[pranavrules2007]

hello.. I am new to visual basic. I want to know,how to connect a form to a database. I am completely new to this stuff, so please be easy on me while replying.. I wanted to make a database which would store all the information seen below in the screenshot, like the username, password, etc.. Please help me from the basics such as what to use, [Oracle, MySQL, whatever] and how to create a database in it.. i know all the basic commands such as..

create table userreg
(
username varchar2(10),
empid number(4),
etc etc...
);

I am familiar with Oracle 9i, as we were taugh that in the second year of engineering.. But here, i see that everyone is using MySQL for dbs.. So please tell me the differences too.. also please tell me where/how to store the database. I want to show this in my college so also tell me how to carry a DB on a CD/Pendrive.. When i click on submit, the information in the text boxes should be sent to the database.. i.e, the tuples[rows] should be automatically updated i was for a long time for finding how to connect the db.. please help me out here.. thanks a million...

Regards,
Pranav

If you like, please mail me at:
pranav_s_2000@yahoo.com



*img69.imageshack.us/img69/3113/formvc6.jpg

well? anyone? please??

 

[RCuber]

Can you ( or anyone else ) please attach the image I cant see it (Imageshack blocked )

As you are still in the begining stage of learning how to connect to a database, I suggest you to work with MS Access Db's, It doesnot matter which database you are using because all the access methods will be the same.

I suggested MS Access because you wanted to carry your DB in a Pendrive. Oracle, MySQL and MS SQL Server are more powefull DBM's . One you get a small hold one the basics of DB access in VB you can easily shift to any other DBM's