How to find if dataTable contains column which name starts with abc

c# regex datatable dataset columnname
VilemRousi picture VilemRousi · Sep 3, 2012 · Viewed 10.5k times · Source

In my program I have a dataTable and I´d like to know if is there a column which name starts with abc. For example I have a DataTable and its name is abcdef. I like to find this column using something like this:

DataTable.Columns.Constains(ColumnName.StartWith(abc))

Because I know only part of the column name, I cannot use a Contains method. Is there any simple way how to do that?

Thanks a lot.

Answer

Kirill Bestemyanov picture Kirill Bestemyanov · Sep 3, 2012

You can use this:

 var datatable = new DataTable();
 var abccolumns = datatable.Columns.Cast<DataColumn>()
                                   .Where(c => c.ColumnName.StartsWith("abc"));

Related questions

Regular expression to check if password is "8 characters including 1 uppercase letter, 1 special character, alphanumeric characters"

I want a regular expression to check that a password must be eight characters including one uppercase letter, one special character and alphanumeric characters. And here is my validation expression which is for eight characters including one uppercase letter, one …

Read More
Regex that accepts only numbers (0-9) and NO characters

I need a regex that will accept only digits from 0-9 and nothing else. No letters, no characters. I thought this would work: ^[0-9] or even \d+ but these are accepting the characters : ^,$,(,), etc I thought that both the regexes …

Read More
Regex for numbers only

I haven't used regular expressions at all, so I'm having difficulty troubleshooting. I want the regex to match only when the contained string is all numbers; but with the two examples below it is matching a string that contains all …

Read More