Hello i have a problem in my c# project. I have a windows form that saves values from textboxes into a csv file. I then open the csv file in a datgrid where i'm supposed to search in it and highlight or filter particular rows and that is where i'm stuck.
I don't know how to filter the datagrid.

All i found on the internet is by using sql but i don't want to as i'm not connecting to sql server as i don't have a database but only one csv file.

This is what i'm using to open the file in datagrid. Now what i need is to filter for example who has surname "white".

public void openfile_Click(object sender, EventArgs e)
         List<string[]> testParse = parseCSV("c:\\TestParse.csv");    
         dv = new DataView(dt);
        dataGridView1.DataSource = dv;

         dt.Columns.Add("ID", typeof(int));
         dt.Columns.Add("Surname", typeof(string));
         dt.Columns.Add("Salary", typeof(int));
         dt.Columns.Add("Administrative", typeof(string));
         dt.Columns.Add("Programmer", typeof(string));
         dt.Columns.Add("C#", typeof(string));
         dt.Columns.Add("C++", typeof(string));
         dt.Columns.Add("Pascal", typeof(string));
         dt.Columns.Add("Java", typeof(string));
         dt.Columns.Add("SQL", typeof(string)); 

         foreach (string[] row in testParse)
         dv.Sort = "Id";   //sort field required for search


 public List<string[]> parseCSV(string path)
         List<string[]> parsedData = new List<string[]>();

         using (StreamReader readFile = new StreamReader(path))
            string line;
            string[] row;

            while ((line = readFile.ReadLine()) != null)
               row = line.Split(',');

         return parsedData;


//dv.RowFilter="Id=" + varName;
//dv.RowFilter="SurName like 'A%'";
This article has been dead for over six months. Start a new discussion instead.