which way of inserting, updating data on tables?

[assimang]

Hello to everyone.
I am very new in vb 2005, and I am confused which is the best way of inserting, updating data on a database created in microsoft sql server management studio express 2005 with code. When user runs my application he inserts usernId and password and if he is a new user his usernID and password are save to users table. If he is a new user he begin to be taught typing through exercises. So, when he feel tiered he can stop and he can close the application. Before close the application, his userid, BookmarkID, ChapterKindID, ChapterID, ExerciseID are being save to a table bookmarks. That means that the next time this user logins he will continue his practise by the last exercise he stopped the previous time. This proccess will be repeated every time the user stop the practising and exits the program. I have red about command objects, command builters, adapter's update method I don't know what is the best way and their differences. Up to now I have used command objects and datasets in my application? But what about now? Can I have an example please?

Thanks anyone
in advanced.

 

[AlexCuse]

I'd go with the command objects. They are easier to work with.

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[assimang]

Thank you AlexCuse. Must I have to use relations and how exactly? If I go with command objects does the modifications are being directly or do I have to send it back to the data store via dataAddapter? And if I have to send it back to the database via dataAdapter can I have an example of doing this please?

Thanks again
in advanced.