visual c# - How to get a column with a name from a DataTable ?

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  October 21, 2013 at 10:05 pm

  #284880

  I stored a result set from an sql query into a DataTable. I want to get a DataColumn with a particular name into a DataColumn object. How do I do it ?

  Pseudocode -

  DataTable dt = Already set. Don't worry about it.

  string columnName = "Address";

  DataColumn col = dt.getColumn(columnName)

  Can you show me how this would be done in C# ?

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  October 22, 2013 at 1:35 am

  #1660396

  DataColumn col = dt.Columns[columnName];

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537