C# Filtering datagrid without database

Question

I'm working on a project where I have to create an employee management system using Windows Forms Application in Visual Studio 2010. I have been asked to not use any database for this project. I have to programatically add values into a datagridview and allow the user to filter out rows. Eg: Filter names of the employees, filter employees who get paid more than $10,000, filter based on location, etc. I have managed to populate the datagrid view with details. I just don't understand how I could filter out the rows in the datagridview. I decided to create a button called "Filter" in Form1.cs which would open up a different form just for filtering. Any tips?

Manas Mohapatra · Answer

Hi Nikita, First create an employee list and bind it to your datagrid. Then your data will populate in your grid. Now you can go for search employees based on your condition. P lease follow below code, it is implemented in two ways: Here btnFilter_Click is value of OnClick attribute of button. public void btnFilter_Click(object sender, EventArgs e) { // Create Binding source Object and map it with Datagrid BindingSource bs = new BindingSource(); bs.DataSource = dataGridView1.DataSource; // Add your filter as per your requirement bs.Filter = dataGridView1.Colu mns[5].HeaderText.ToString() + " LIKE '%" + txtbxSearch.Text + "%'"; //bs.Filter = "Age dataGridView1.DataSource = bs; } or (dataGridViewFields.DataSource as DataTable).DefaultView.RowFilter = string.Format("Field = '{0}'", textBoxFilter.Text); Note: If you find anything useful in my answer please accept it.

Manas Mohapatra · Answer

Nikita, I added two types filters: // Add your filter as per your requirement bs.Filter = dataGridView1.Colu mns[5].HeaderText.ToString() + " LIKE '%" + txtbxSearch.Text + "%'"; or bs.Filter = "Age Colu mns[5] is your column name like empname. If you are not sure you can follow second one.

Manas Mohapatra · Answer

1. First Bind data to Datagrid. http://www.aspdotnet-suresh.com/2014/12/bind-data-to-datagridview-in-windows-application-in-csharp-vbnet.html In above article they are fetching data from Database. But as per your comment you need to create custom list. Add a class file called Employee.cs Then add following code: Public Class Employee { int Id {get; set;} string name {get; set;} double salary {get; set;} } // Create a list List empList = new List (){ new Employee{id=1, name="test", salary=200}, new Employee{id=2, name="test2", salary=300}, }; // Bind custom employee list to Datagrid dataGridView1.DataSource = empList; Then on button click write code for Filter // Create Binding source Object and map it with Datagrid BindingSource bs = new BindingSource(); bs.DataSource = dataGridView1.DataSource; // Add your filter as per your requirement //bs.Filter = dataGridView1.Colu mns[5].HeaderText.ToString() + " LIKE '%" + txtbxSearch.Text + "%'"; bs.Filter = "salary dataGridView1.DataSource = bs; Hope this one will help you.

Upendra Pratap Shahi · Answer

Hello, Go with this article- http://www.c-sharpcorner.com/UploadFile/77a82c/data-binding-control-using-listview-and-gridview/

Nikita Sudhir · Answer

Thank you everyone :) I figured it out with most of links given to me by you. :D

Nikita Sudhir · Answer

I've populated by datagridview from the form load method. I don't require a binding to be done. Is it possible to programmatically filter?

Nikita Sudhir · Answer

Can't seem to access it. It redirects me to c-sharpcorner's home page.

Nikita Sudhir · Answer

Yeah, I'm needed to use all the filters I've mentioned.

Nikita Sudhir · Answer

Hey, I'm trying to understand your code but I can't seem to. Could you explain what you meant by "Columns[5]". Why is that needed there? I'm not very familiar with BindingSource since I'm new to c#. I will read up on it now. Thank you for your post though. :) It sure did give me direction.

Upendra Pratap Shahi · Answer

Hello, Reopen this link- http://www.c-sharpcorner.com/UploadFile/77a82c/data-binding-control-using-listview-and-gridview/

C# Filtering datagrid without database

Answers (10)