How to use Datagridview 1st row for filter purpose.

Question

I have datagridview which contains more then 50 columns,binding using IdataReader, now i want to use first row of datagridview to be use as datagridview row filter how to do.
if i have less then10 columns then i can give 10 textboxes for filter datagridview data using dataset and dataview

Amit Mohanty · Answer

Hey try this TextBox oTextBox; DataTable dtData; // To bind datagridview on page load. Stored all Data of datagridview. string strFilterColumnName = "" ; private void dataGridView1_CellClick( object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == 0) { if (oTextBox != null ) oTextBox.Visible = false ; strFilterColumnName = dtData.Columns[e.ColumnIndex].ColumnName; oTextBox = new TextBox(); dataGridView1.Controls.Add(oTextBox); oTextBox.Visible = false ; oTextBox.TextChanged += new EventHandler(oTextBox_TextChanged); oTextBox.Visible = true ; oTextBox.BringToFront(); oTextBox.Text = "" ; System.Drawing.Rectangle oRectangle = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true ); oTextBox.Size = new Size(oRectangle.Width, oRectangle.Height); oTextBox.Location = new Point(oRectangle.X, oRectangle.Y); } } private void oTextBox_TextChanged( object sender, EventArgs e) { if (oTextBox.Text == "" ) { (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = "" ; } else { string rowFilter = string .Format( "[{0}] LIKE '{1}*'" , strFilterColumnName, oTextBox.Text.ToString()); (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = rowFilter; } }

francisco cabrera · Answer

ERROR.Message: C# Using the generic type 'System.Collections.Generic.List ' requires 1 type arguments ERROR.line: private List people = new List (); SOLUTION: Fix it, comment it, and replace it with next line: public List people = new List ();

francisco cabrera · Answer

ERROR.Message: C# Using the generic type 'System.Collections.Generic.List ' requires 1 type arguments ERROR.line: private List people = new List (); SOLUTION: Fix it, by comment it, and replace it with next line: public List people = new List ();

Abubakr Mahdi · Answer

Hi Deepa , here a solution , i think this code works as you need . this is screen shot : public partial class Form2 : Form { public Form2() { InitializeComponent(); } private class Person { public Person( string fName, string lName, string address) { FirstName = fName; LastName = lName; Address = address; } public string FirstName { get ; set ; } public string LastName { get ; set ; } public string Address { get ; set ; } } private List people = new List (); private void FillGridView() { dataGridView1.Rows.Add( "" , "" , "" ); // add an empty row to use it as filter. //add some data to data source. Person p1 = new Person( "Mohmmed" , "Ahmed" , "Sudan" ); Person p2 = new Person( "John" , "Simth" , "USA" ); Person p3 = new Person( "Raj" , "Sharma" , "India" ); people.Add(p1); people.Add(p2); people.Add(p3); //fille data grid view foreach (Person person in people) { dataGridView1.Rows.Add(person.FirstName,person.LastName,person.Address); } } private void FilterGridViewByFirstRow( string colName, string filterValue) { foreach (Person person in people) { if (colName == "FirstName" ) { if (person.FirstName.Contains(filterValue)) { dataGridView1.Rows.Add(person.FirstName, person.LastName, person.Address); } } else if (colName == "LastName" ) { if (person.LastName.Contains(filterValue)) { dataGridView1.Rows.Add(person.FirstName, person.LastName, person.Address); } } else if (colName == "Address" ) { if (person.Address.Contains(filterValue)) { dataGridView1.Rows.Add(person.FirstName, person.LastName, person.Address); } } } } private void button1_Click( object sender, EventArgs e) { FillGridView(); } private void dataGridView1_CellEndEdit( object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == 0) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Index == 0) continue ; dataGridView1.Rows.Remove(row); } string bindedColName = dataGridView1.Columns[e.ColumnIndex].Name; FilterGridViewByFirstRow(bindedColName, dataGridView1.Rows[0].Cells[e.ColumnIndex].Value.ToString()); } } }

Deepa Ck · Answer

@ Chittaranjan your link is not my requirement I want like this as attached image, first row i left for filter rows if i type data at first row according to that it should filter rows

Chittaranjan Swain · Answer

Hi Deepa, Refer below link, https://stackoverflow.com/questions/5843537/filtering-datagridview-without-changing-datasource can you try this link, https://www.codeproject.com/Questions/661733/DataGridView-First-Row-Lost-When-I-Filter-It

How to use Datagridview 1st row for filter purpose.

Answers (6)