c# - Sharepoint list Column with space in name not able to apply filter -

i trying achieve filtering option on sharepoint list retrieved data-table applying row-filter on same (using code snippet listed below).

code snippet:

dt.defaultview.rowfilter = string.format("[column name] = '{0}'",no.text); jview= dt.defaultview; gvviewjobs.datasource = jview; gvviewjobs.databind(); 

but when execute line on row filter getting exception thrown 'column name' not valid, tried option of using 'x0020' in column name, giving out error. tried below snippet of using filter option directly in datatable shown below, no luck.

datatable filtering

datarow[] results = dt.select("[column name] =' " + no.text + "'"); 

can advise me of using referring column name filtering tried square bracket ([]) option too.

regards arvind

use caml builder internal name of field. ensure using appropriate expression row filter.

check dataview rowfilter syntax more details syntax.