CODEWITHSUNDEEP
c#winformsdatagridviewdatatable
Nithesh Narayanan
Nithesh Narayanan

Reputation: 11775

Datatable Select() Method

I have a Datagridview and the Data Source is dtCustomer I just want to filter the content of grid view based on a search text. Itried the following code 

DataTable dtSearch =  dtCustomer;
dtSearch.Select("cust_Name like '" + txtSearch.Text + "%'");
grvCustomer.DataSource = dtSearch;

But this is not working. If any body knows the solution please share.

Upvotes: 11

Views: 92562

Answers (8)

Example
Example

Reputation: 21

You can do something like this.

DataView dv1 = dtDefault.DefaultView; 
dv1.RowFilter = "CusGroupId=1 and CustomerCode LIKE '"+txtCustomer.Text +"%'";  
DataTable dt=dv1.ToTable();

Upvotes: 2

Jayg
Jayg

Reputation: 21

dtCustomer.Rows.Cast<DataRow>().Select(dr => (string)dr["cust_Name"].Startswith("zzz")).ToList()

Upvotes: 2

Jason Politis
Jason Politis

Reputation: 71

I think this is what you're looking for?

//DataTable dtSearch =  dtCustomer;
//dtSearch.Select("cust_Name like '" + txtSearch.Text + "%'");


grvCustomer.DataSource = dtCustomer.Select("cust_Name like '" + txtSearch.Text + "%'");

And when you want to go back to the original data

grvCustomer.DataSource = dtCustomer;

Upvotes: 0

Delog
Delog

Reputation: 31

Or Try this;

dataGridView.Datasource = datatable.Select("....").CopyToDataTable()

Upvotes: 3

hungryMind
hungryMind

Reputation: 7009

DataTable.Select returns array of row, but you are binding entire data table not filtered rows. use this way or DataView

DataTable dtSearch =  dtCustomer;
var filter = dtSearch.Select("cust_Name like '" + txtSearch.Text + "%'");
grvCustomer.DataSource = filter.ToList();

Upvotes: 1

Paul Williams
Paul Williams

Reputation: 17040

The return value for DataTable.Select is a DataRow[] array. It returns a list of matching DataRows. Your code does nothing with those rows at the moment.

You can setup a DataView with a filter and set the grid's DataSource to the DataView:

DataView dv = new DataView(dtSearch);
dv.RowFilter = "...";
grvCustomer.DataSource = dv;

Upvotes: 8

ipr101
ipr101

Reputation: 24236

You could try using a DataView (code not tested) -

DataView dv = new DataView(dtSearch);
dv.RowFilter = "cust_Name like '" + txtSearch.Text + "%'";
grvCustomer.DataSource = dv;

Upvotes: 3

Boomer
Boomer

Reputation: 1478

Try this:

dtSearch.DefaultView.RowFilter = "cust_Name like '" + txtSearch.Text + "%'";

And check whatever there is space to be removed by triming the text.

Upvotes: 14

Related Questions