how to search datatable value by using tetbox by loops

Nagendra Panyam

7y1.2kLearn iOS Programming

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);

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya7y ago
You can try this:
DataRow[] tdr = dt.Select("Name LIKE '%" + SearchBox.Text + "%'");
dt1 = tdr.CopyToDataTable();
gridtest.ItemsSource = null;
gridtest.ItemsSource = dt1;
+1
Jignesh Kumar7y ago
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;
}
0
Nagendra Panyam7y ago
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 <= 0)

{

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;
0
Jignesh Kumar7y ago
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
0
Piyush Pansuriya7y ago
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.
+1