|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Adding Dataview or datatables to static DataSetI 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
Splitting a large string variable into lines <= 70 chars
Custom size paper problem Scrolling a Datagrid with code BindingList: How to implement Find? XML Commenting Saving Rich Text to a SQL Database Sending Mail via MAPI - VB .NET 2005 Obtaining complete User List Adding images to image folder in vb.net New Dialog Result |
|||||||||||||||||||||||