View Full Version : adding values in a database
Nightingale
04-16-04, 02:03 PM
i have created a database in access. i have a form in VB. i have to input value in my VB form and the data should be stored in my database. how do i do this?
i know i have to use 'recordset'. but it doesn't work. i can't even enter values.
EvilHaider
04-19-04, 08:23 PM
Look up how to establish an ADO connection between your VB program and your database. You can then run SQL commands such as 'insert' on your database.
dazz417
04-30-04, 10:09 AM
i have created a database in access. i have a form in VB. i have to input value in my VB form and the data should be stored in my database. how do i do this?
i know i have to use 'recordset'. but it doesn't work. i can't even enter values.
Add the Microsoft ADO Data Control to the form, right-click on it and set the required connection properties, then create databound text boxes and bind them to the various fields you require. That way you don't have to fiddle with recordsets at all.
Go through this tutorial, it should be of some help:
http://www.devpapers.com/article/98
Nightingale
05-12-04, 09:07 AM
Thanks for ur help... Finally did it...
vBulletin® v3.6.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.