Remove DataColumn from DataTable with Data

Question

I have Datatable with Data. I called my postgres data base and get DataTable.

// get the new data from postgres
   var dataTable = pg.GetDataTable("SELECT * FROM " + '"'+table+'"');

Now I need to remove specific Column. assume that there are 5 columns with data.

ID     |   Name   | Address | Mobile | Home
_______________________________________________
    1  |  A       |AAA      | 123    | 345
    2  |  B       |BBB      | 234    | 456
    3  |  C       |CCC      | 345    | 567

So I need to remove "Home " DataColumn and Recreate this DataTable as following

  ID   |   Name   | Address | Mobile 
____________________________________
    1  |  A       |AAA      | 123    
    2  |  B       |BBB      | 234    
    3  |  C       |CCC      | 345

How can I do this ?

Appreciate your comments.

Thanks

Do you actually need the Home column between the query and when you want the column removing? If not, why not just select the columns in the SELECT statement rather than them all with the asterisk — horHAY
Thanks for your comment. This is really small piece of my code. So I need to remove specific column. this is not only for one table. :) — Gayan
Can't you just skip selecting it? It seems like your table already needs special treatment so maybe a generic sql select is not appropriate. — Mattias Nordqvist
Ok, so what if you create a new datatable and copy your data over to the new one? Or maybe as Tim Schmelter suggests. :) — Mattias Nordqvist
I would follow Taosique's answer, but whats the reason for removing that column anyway? — horHAY

Tim Schmelter Tim Schmelter · Accepted Answer · 2015-03-19T14:48:54

You just need to use the method DataTable.Columns.Remove(string name):

dataTable.Columns.Remove("Home");

Then the table doesn't contain this column anymore and all rows' data in this column is thrown away. However, omit this column in the first place and list the desired columns:

var dataTable = pg.GetDataTable("SELECT ID, Name, Address, Mobile FROM " + '"'+ table +'"');

Remove DataColumn from DataTable with Data

3 Answers