Disconnected DataSet and DataTable

[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

 

[Uri Dor]

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

 

[Garry]

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

 

[Paul Clement]

¤ 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".

If you want to create a DataTable dynamically the following article should help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data05312002.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Amnon]

Thanks Paul

Actually, I found this article which is far more pertinant to my needs and
has an excellent .NET code example although the DataColumn object certainly
is worth reading about.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvb04/html/vb04h4.asp

Amnon