Copy single column in DataTable with data to new DataTable

[BG12424]

I'm using VB.NET in an ASP.NET application.

I have a datatable (DataSet.Tables(0)) which I've populated as a resultset from the database, but I need to perform special actions on distinct records for one particular column (I have a composite key as my primary key for this table), so I would like to copy one column from my current table to a new DataTable, then work of it. How can I do this?

Also, is it possible to fill a single column datatable with a specific column within my resultset if my resultset has multiple columns being returned? Thanks




regards,
Brian

http://www.gainesconsulting.com

 

[BG12424]

I was able to get this to work by merging into an existing dataset and using the MissingSchemaAction Enumeration with the Ignore value.


regards,
Brian

http://www.gainesconsulting.com