c# - DataTable.Select -

i have datatable column called name.

datatable dt = new datatable(); datacolumn dc = new datacolumn(); dc.datatype = system.type.gettype("system.string"); dc.columnname = "name"; dt.columns.add(dc); 

i'm trying select datarows have what's in textbox, don't know how . here's want.

dt.select("string.compare(name.tolower().contains(" + textbox1.text.tolower() + ")"); 

is there way select / should attempting it?

you can use linq dataset (via asenumerable):

var results = dt.asenumerable().where(dr => dr.field<string>("name").tolower().contains(textbox1.text.tolower()));