How to check if a column exists in a datatable

Question

I have a datable generated with the content of a csv file  I use other information to map some column of the csv  now in the datatable  to information the user is required to fill   In the best world the mapping would be alway possible  But this is not reality    So before I try to map the datatable column value I would need to check if that column even exist  If I don t do this check I have an ArgumentException   Of course I can check this with some code like this    try         try to map here    catch  ArgumentException        but I have for now 3 columns to map and some or all might be existing missing  Is there a good way to check if a column exist in a datatable

User · Answer

For Multiple columns you can use code similar to one given below I was just going through this and found answer to check multiple columns in Datatable     private bool IsAllColumnExist DataTable tableNameToCheck  List lt string gt  columnsNames                bool iscolumnExist   true          try                       if  null    tableNameToCheck  amp  amp  tableNameToCheck Columns    null                                foreach  string columnName in columnsNames                                        if   tableNameToCheck Columns Contains columnName                                                 iscolumnExist   false                          break                                                                    else                               iscolumnExist   false                                              catch  Exception ex                               return iscolumnExist

User · Answer

You can look at the Columns property of a given DataTable  it is a list of all columns in the table   private void PrintValues DataTable table        foreach DataRow row in table Rows                foreach DataColumn column in table Columns                        Console WriteLine row column                        http   msdn microsoft com en-us library system data datatable columns aspx

User · Answer

DataColumnCollection col   datatable Columns          if   columns Contains  ColumnName1           Column1 Not Exists    if  columns Contains  ColumnName2           Column2 Exists

User · Answer

It is much more accurate to use IndexOf  If dt Columns IndexOf  quot ColumnName quot     -1 Then      Column not exist End If  If the Contains is used it would not differentiate between ColumName and ColumnName2

User · Answer

Base on accepted answer  I made an extension method to check column exist in table as I shared for whom concern   public static class DatatableHelper            public static bool ContainColumn this DataTable table  string columnName                        DataColumnCollection columns   table Columns              if  columns Contains columnName                                 return true                             return false               And use as dtTagData ContainColumn  quot SystemName quot

User · Answer

You can use operator Contains   private void ContainColumn string columnName  DataTable table        DataColumnCollection columns   table Columns              if  columns Contains columnName                               MSDN - DataColumnCollection Contains

User · Answer

myDataTable Columns Contains  col name

[c#] How to check if a column exists in a datatable

Examples related to c#

Examples related to datatable

Examples related to argumentexception