Disconnected DataSet and DataTable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone have code that generates a DataSet and DataTable from scratch using
code with a given connection, to MSAccess.
Does this disconnected DataTable track changes???
Can I turn off the "Tracking".

Help would be appreciated
 
Hi, Amnon,
If I understand correctly, you create the DS, DT and then use the
connection to write it to MSAcccess.
Once you wrote to Access, there are no changes - your data is the same
as in Access.
Any changes you make now to the DS are tracked. What's the problem with
that?

Uri
 
Uri Hi,

No. That is not quite the scenario that I want.

I would like code that built a datatable from scratch without any reference
to a connection

AND

I realize that a ReadOnly dataset would be disconnected anyway BUT

If i build a datatable from code and populate it with data, how do I make
sure that it is disconnected to save resources.

What parameters do I use make it as 'light' as possible.

Mostly it would be used as a property collection but would be 'bound' to the
rows and columns of a grid control and would enable me to sort and resort
the grid without inserting the values into the hidden grid columns which are
problematic when exporting to Excel. Also, any of the fields/columns could
be a SEARCH column.

I am moving from ADO.2 to ADO.NET in VS2005 and want to make the correct
choices. I used memory recordsets in VB6.

Code would be appreciated.

Links to relevant material would be much appreciated.

Thanks

Amnon

The
 
Back
Top