Firstly, this is my first post. Please let me know if it is in the incorrect forum.
I am using Visual Studio / Visual Basic

I am using a MSDE database to hold records of purchases.
I have four text boxes on my web form: For Example: One holds the Description of the product, one the QuantitySold, one the UnitPrice

I would like to add one record at a time to a dataset perhaps, and when I am finished, update the dataset to the database.

Should I be using a dataset to do this?, If so, I could use a little help.
Thanks

Hi,
From my point of view, best to use Datatable as it is easier, best way of doing this is create a table named after your purchases table in your MSDE database. Then use DataAdapter to fill schema to your database table. That way you will have same data structure table as your table. Add data to your table one at a time from your text boxes, and once you complete the task, use your DataAdapter & CommandBuilder objects to update to your MSDE database.
Once updated then, you can clear all the data in your table, but not to dispose the table or clear it's schema. So you can re-enter data and start the cycle again.
Hope this help, if not give me a buzz..

Cheers
Kasie

Hi again,
Just to says that if you only going to use only one table from your database then use datatable but if there are more than 1 table used then create a dataset and creates many tables as you like in it.
Sorry, forget to add this..
Thanks
Kasie