How to filter datagridview by making any change in the textbox

Question

Using Linq to sql through bindingsource control in WinForms, I could not get this to work:

private void textBox1_TextChanged(object sender, EventArgs e)
{
this.productBindingSource.Filter = string.Format("dataGridViewTextBoxColumn1 like '%{0}%'", textBox1.Text.Trim().Replace("'", "''"));
productDataGridView.DataSource = productBindingSource;
}
When I type some letter in the textbox nothing happens in the datagridview.
Thanks for advices ...

Samio · Answer

This is the answer, and it is simple: var searchValue = textBox1.Text.Trim(); var qry = (from p in dc.Products where p.ProductName .StartsWith(searchValue) select p).ToList(); productDataGridView.DataSource = qry;

Santhosh Kumar Jayaraman · Answer

Have you checked this? http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdatasource.filterexpression.aspx There is an example for filtering also

Samio · Answer

Sorry, this method will complicate things for me, and I would keep it simple. please is there a way to avoid using dataset and this kind of conversions ? Thank you.

Santhosh Kumar Jayaraman · Answer

Check this article. This method will convert objectdatasource to dataset. private DataSet GetDS( ObjectDataSource ods) { var ds = new DataSet(); var dv = (DataView)ods.Select(); if (dv != null && dv.Count > 0) { var dt = dv.ToTable(); ds.Tables.Add(dt); } return ds; } source: http://www.aspdotnet-suresh.com/2010/09/how-to-bind-dataset-with.html

Samio · Answer

Thanks for your reply Santhosh, I tried your sample but it did not work for me, data is not loaded to the datagrid, as you can see I am binding my grid to a bindingsource control which is bound to L2S datasource object. You provided a project with dataset and dataview, I failed to use dataview with databinding to L2S, could you please show how it is possible to do that? Thank you in advance.

Santhosh Kumar Jayaraman · Answer

Please see the attached project. I fill all my entities to DataSet, then casting it to Dataview. Bind gridview to Dataview, then filter it with textbox value. Here i have used XML as datasource. FOr stored Proc or linq, directly fetch into Dataset. My XML File xml version="1.0" standalone="yes" ?> - NewDataSet > - Table1 > Server > Server1 Server > Database > Database1 Database > Table1 > - Table1 > Server > Server2 Server > Database > Database2 Database > Table1 > - Table1 > Server > Server3 Server > Database > Database3 Database > Table1 > NewDataSet >

How to filter datagridview by making any change in the textbox

Answers (6)