Adding Dataview or datatables to static DataSet

  • Thread starter Thread starter Rico
  • Start date Start date
R

Rico

hello,

I have a Dataset that I've created without using a data adapter. What I
want to do is add values to this dataset (two fields) ad the user goes along
i.e.

user receives three bikes in this order and enters one line to receive the
bikes, but is prompted to enter three serial numbers.

Next line the user receives 4 books, enters one line for the books, and is
prompted to enter four ISBN numbers

When the user is done, I would like to cycle through the dataset and add
this info to a database. The problem is, I don't know how to keep the
dataset
static, or how to refer to it an add the rows as needed.

Any direction would be great.

Thanks!
 
Rico,

Ignoring the dataadapter is in my opinion not the way in this case.
You can fill in advance your empty dataset with the DataAdapter.FillSchema
Than you can use the commandbuilder to build the insertcommand
Than you can use the dataadapter.update

What you want probably is use the dataset in a global way, in that way it
exist for your complete class (form).

If you want it shared over all your classe, than you can create your own
dataset as a new class and share it while inheriting it from the standard
dataset.

I hope this helps,

Cor
 
Back
Top