yes, i did myself .... both with name and number i can search .... :)
here is the logic :)
DataTable dt = new DataTable();
OleDbCommand cmdd = new OleDbCommand("SELECT addimage,addname,addnumber1 FROM addcontact", conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);
da.Fill(ds);
view.Table = ds.Tables[0];
System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("^[a-zA-Z ]+$");
if(r.IsMatch(SearchBox.Text))
{
view.RowFilter = "addname like '%" + SearchBox.Text + "%'";
dataGrid1.ItemsSource = view;
}
else
{
view.RowFilter = "addnumber1 like '%" + SearchBox.Text + "%'";
dataGrid1.ItemsSource = view;
}