S
Somebody_Out_There
Hello,
I am trying to create a strongly typed datatable/dataset from an untyped
dataset or datatable returned from a stored proc.
The structure of the table cannot be static since the results are
dynamic which means that I am right now creating the schema/structure of
the datatable from a datareader using reader.GetSchemaTable() and then
looping thru the reader to populate values.
Is there any other efficient way of achieving this? GetSchemaTable() is
another round-trip to the DB that I am trying to avoid.
Thanks in advance
I am trying to create a strongly typed datatable/dataset from an untyped
dataset or datatable returned from a stored proc.
The structure of the table cannot be static since the results are
dynamic which means that I am right now creating the schema/structure of
the datatable from a datareader using reader.GetSchemaTable() and then
looping thru the reader to populate values.
Is there any other efficient way of achieving this? GetSchemaTable() is
another round-trip to the DB that I am trying to avoid.
Thanks in advance