Filtering Records in the datagridview

[BabliS1]

I am using Vb.net2005. I have a datagridview which displays some data. I want to filter the records based on some criteria given by the user at runtime. How can I do this. Please Help.

Thanks in Advance

[BabliS1]

@BabliS1
I have a datagridview which displays some data. I want to filter the records based on some criteria given by the user at runtime.The form also contains a combobox.

The datagridview has a column which contains some string seperated by commas. Example:hello,h ai

When the user selects an item from the combobox I want the datagridview to search the column data seperated by commas and display only those rows that includes the the specified string.
Currently I am using the Dataview to filter the records. But I dont understand how to search for a specified data within a string.

Could anyone please help me to filter the records in the dataview.

Thanks in Advance.

[PRR]

You can use datatable.Selec t method ....

string filterExp = "Status = 'Active'";
string sortExp = "City";
DataRow[] drarray;
drarray = dataSet1.Customers.Select(filterExp, sortExp, DataViewRowState.CurrentRows);
// clear your datatable
for (int i=0; i < drarray.Length; i++)
{
   //add rows to datatable 
}
// bind here
 

[BabliS1]

Thanks DeepBlue for your suggestion. But the problem is not solved.
Is it possible to use the split fuction with the RowFilter method.
If yes could you please tell me how.

[aryanbs]

dataview.RowFil ter = "columnname like '%" & combobox1.Text & "'%"

[BabliS1]

@aryanbs
But the above line will check if the cell value starts with the specified text.I guess I was not clear in explaining my question.

My form contains a datagridview which is filled during the runtime based on some query. The form also contains a combobox whose items are some words.
The DataGridView(DG V) contains a column whose values are different words(only the ones contained in the datagridview) seperated by commas(Each row has different combination of words)
Now when the user selects a word from the combo I want the datagridview to display only those rows wherein the values for that cell contains the selected word.

Is it possible to split the contents of each cell with "," as the seperator and then compared each word with the selected word and display only that row that satisfies the condition and remove other rows.Currently I am using DataView to filter the records but I dont understand how to split the contents of the cell and compare it with the selected word.

Hope you understand what I meant
Please Help