Member Avatar for xanawa

i have datagrid view which uses dataset..

i would like to filter my datagridview by idCardNumber (getting it from the textbox1)

how can i do so? could u explain pls?

  • 3 Contributors
  • 3 Replies
  • 95 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by xanawa
Member Avatar for jbisono

Hi
i believe you can do this.

DataView MyDataView = MyDataSet.Tables[0].DefaultView;

MyDataView.RowFilter = "IdCardNumber = "+Convert.ToInt32(textbox1.Text)+"";
MyDataGrid.DataSource = MyDataView;
MyDataGrid.DataBind();
Member Avatar for C#Jaap

This line helps me filtering a DataGridView:

My DataGridView.DataSource = <name>BindingSource
this.<name>BindingSource.Filter = String.Format("<columnname> LIKE '%{0}%'", TextBoxFilter.Text);

The DataGridView and BindingSource were generated automatically.

If you do not use the bindingsource, you can apply a filter by changing the DefaultView of the table which is shown in the grid.

Member Avatar for xanawa

done :) thx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.