Intersoft Community - WebGrid Enterprise - Example without DataAdapter for InitializeSelfReferenceDataSource needed

Example without DataAdapter for InitializeSelfReferenceDataSource needed

yudi@intersoftpt.com — Wed, 09 Sep 2009 22:34:51 GMT

Glad to hear that you’ve found a solution of your problem and share it with us.

Thank you very much for your contribution in our community forum. Should you find any other questions, suggestions, or problems regarding our products, please feel free to post them in our forum.

Example without DataAdapter for InitializeSelfReferenceDataSource needed

Eric — Wed, 09 Sep 2009 08:01:02 GMT

I solved this myself in the meantime. It is only partially related to WebGrid.

Here's the example:

Dim ds As DataSet = ... 'data to add

Dim dt As DataTable = CType(e.DataSource, DataTable)
dt.Merge(ds.Tables(0), True, MissingSchemaAction.Error)

Example without DataAdapter for InitializeSelfReferenceDataSource needed

Eric — Tue, 08 Sep 2009 12:49:42 GMT

When loading data on demand in a grid that has several nodes and the user clicks on one of these minus boxes, then the node should open and the next level of data be displayed.

For that is the InitializeSelfReferenceDataSource event. The parameter e.DataSource is read-only. Therefore the sample (in the documentation of this event) simply casts the e.DataSource into a DataTable. Then a DataAdapter fills in the data.

How would this work when I only have an existing DataSet? I also tried to cast the e.DataSource to a DataTable and assigned the existing DataSet.Table(0) to that DataTable. But the grid doesn't get the data somehow.

I also tried to copy the rows in a foreach loop, but I get a runtime error saying the rows belong to different tables.

If I don't have a DataAdapter, only a DataSet, how would this event fetch the data for the grid?