DataView.Find() - how to search an item with wildcard?

[Sergey P]

DataView.Find() look for an item exactly:

MyDataView.Sort="FirstName";
strFind="Nick"
int nFind = MyDataView.Find(strFind);

If strFind will be like "Nic" - search failed

What to do?

[Administrator]

You can cheat and use a RowFilter on the view to look up all rows that start with a string, and then do an eact search. This does cause a flicker as the DataTable is filtered and quickly restored.

private void button1_Click(object sender, System.EventArgs e)
{
	DataView dv = this.dataSet11.Customers.DefaultView;
	dv.RowFilter = "[ContactName] LIKE 'B*'";
	string s = "";
	if(dv.Count > 0)
	{
		s = dv[0]["ContactName"].ToString();
	}
	dv.RowFilter = "";
	if( s != "")
	{
		int i = this.dataSet11.Customers.DefaultView.Find(s);
		Console.WriteLine(i.ToString());
	}
}

[Sergey P]

Thank you!

It may be done using Datatable.Select