how to search datatable value by using tetbox by loops

Question

i tried fallowing any am unable how to generate loops to comparision datatable string searchExpression = SearchBox.Text; DataRow[] foundrows = dt.Select(searchExpression); dt.DefaultView.RowFilter = searchExpression; dt.DefaultView.RowFilter = string.Format("[{0}] LIKE '%{1}%'", searchExpression);

Piyush Pansuriya · Answer

You can try this: DataRow[] tdr = dt.Select( "Name LIKE '%" + SearchBox.Text + "%'" ); dt1 = tdr.CopyToDataTable(); gridtest.ItemsSource = null ; gridtest.ItemsSource = dt1;

Piyush Pansuriya · Answer

Hi, I am giving example: string searchExpression = SearchBox.Text; DataRow[] foundrows = dt.Select(searchExpression); dt = foundrows.CopyToDataTable(); In this you can filter datatable by searchExpression.

Jignesh Kumar · Answer

Hi Nagendra, Please change in else part please as below and check else { DataView dataView = dt.DefaultView; if (! string .IsNullOrEmpty(searchExpression)) { dataView.RowFilter = string .Format( "[{0}] LIKE '%{1}%'" , "Name" , searchExpression); } dt.Clear(); dt1 = dataView.ToTable(); gridtest.ItemsSource = null ; gridtest.ItemsSource = dt1; }

Nagendra Panyam · Answer

i tried this one but am not getting search result to table am taking two tables dt,dt1 in sending grid if (dt.Rows.Count { DataColumn dc1 = new DataColumn("Name", typeof(string)); DataColumn dc2 = new DataColumn("Id", typeof(int)); DataColumn dc3 = new DataColumn("Age", typeof(int)); DataColumn dc4 = new DataColumn("Title", typeof(string)); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Rows.Add(txtName.Text, txtId.Text, txtAge.Text, txtTitle.Text); gridtest.ItemsSource = dt.DefaultView; //gridtest.DataContext = dt.DefaultView; // gridtest.DataContext = dt; } else { dt.Rows.Add(txtName.Text, txtId.Text, txtAge.Text, txtTitle.Text); gridtest.ItemsSource = dt.DefaultView; } searching grid if (String.IsNullOrEmpty(SearchBox.Text)&& String.IsNullOrEmpty(srchID.Text)) { gridtest.ItemsSource = dt.DefaultView; MessageBox.Show("Please Enter the values to Search", "Prompt", MessageBoxButton.OK); } else { dt1.Clear(); DataRow[] tdr = dt.Select("Name LIKE '%" + SearchBox.Text + "%'"); foreach (DataRow rar in tdr) { dt1.ImportRow(rar); } gridtest.ItemsSource = null; gridtest.ItemsSource = dt1.DefaultView;

Jignesh Kumar · Answer

Hi, Please try below link with simple example string searchExpression = SearchBox.Text; DataView dataView = dt.DefaultView; if (! string .IsNullOrEmpty(searchExpression)) { dataView.RowFilter = string.Format("[{0}] LIKE '% {1}%'", "YourCoulmnForFilterCondition", searchExpression); } https://www.aspforums.net/Threads/174065/Use-LIKE-filter-in-DataTable-Select-function-using-CNet/ https://www.aspsnippets.com/Articles/Filter-DataTable-based-on-Column-value-using-C-and-VBNet.aspx