Column Header Problem in DataTable Select Method

Hi All,

I am using data filter from DataTable using Select method.In my case Column Header have a special character so in filter section comes error.

Here is my Code...

In this case its working fine..

string sCondition = string.Format("[{0}] = '{1}'", "Country Name", "India");

DataRow[ ] dr = dtData.Select(sCondition);

Problem is occured in this case...

string sCondition = string.Format("[{0}] = '{1}'", "Unit [in Cr]", "INR");

DataRow[ ] dr = dtData.Select(sCondition);

In this case Column Name have brace '[ ] ' so my filter condition is not working..
Exception thrown: "Cannot interpret token ']' at position 11 "
Please any one suggest me how to filter this type of column using Select method.

Advance Thanks.... :(

Thanks,
T.Saravanan

[Resolved]
Reply | Reply with attachment | Alert Moderator