G
Guest
Is there a way to re-order datacolumns? Assume I do a "Select * from (insert
table here)" and insert the return rows into a datatable, so the exact
fieldnames and order of the fields are not known at runtime.
Assume I have to move a column called Duration to appear after the column
EmailAddress but these are the only two columns I know about in the table and
there could be other unknown columns also. I have to keep this data in a
Datatable object if possible since our reporting system takes datatables as
input parameters. I have looked at Dataviews but I am not sure this is going
to get me my desired result.
Any help is much appreciated.
table here)" and insert the return rows into a datatable, so the exact
fieldnames and order of the fields are not known at runtime.
Assume I have to move a column called Duration to appear after the column
EmailAddress but these are the only two columns I know about in the table and
there could be other unknown columns also. I have to keep this data in a
Datatable object if possible since our reporting system takes datatables as
input parameters. I have looked at Dataviews but I am not sure this is going
to get me my desired result.
Any help is much appreciated.