|
|
#1 |
|
New Member
Join Date: May 07
Location: Oakland, Ca
Posts: 3
![]() |
Q. How do I save (dataadapter, datatable) data?
vb2005 ATABASE .NET 2Newbie Question: I want to add a column to dataadapter data, display the dataadapter as the source to a datagrid and save the (updated) results to a connected database. The setup: a) Create DataSet: Add two tables: Table A and Table B b) Create Dataadapter: (with Query Builder) Add Table A and Table B Select data columns to display Add a *new* column (not in either table) c) Create Form Add a datagridview and set source = dataadapter d) Run the application <F5>: a. Datagridview shows results of dataadapter including the added column (which is empty) b. User adds data to new column Now that I have the data in the datagridview I have two questions: Q1. How do I save the datagrid contents to a local table and to my connected database (e.g., MsAccess)? If I save the results to a local table will the data be saved for the next session? Q2. How do I add to a DataTable in the DataSet and then save the contents to a connected database? I don't have a problem *getting* data and load it into controls (Fill) but I need help to learn how to save the data! Sorry for the vagueness and possible because I am a total vb 2005 newbie who is very confused with the multitude of data controls: DataSet, DataAdapter, DataTable, TableAdapter, and how they all connect together. I have read through the threads to find the answers to my questions but did not find a solution. Many thanks for any help or suggestions anyone may have. |
|
|
|
![]() |
|
||||||
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|