Populating DataGridView Using LINQ Query

Question

I have a DataGridView with a source of DataSet filled by Adapter using data from Database. Now I want to query the DataSet with closed connection. What is the query to search a specific record?

This is the code that fetches all customers:

private void button2_Click(object sender, EventArgs e)
{
    DataSet CustList = new DataSet();
    CustList = gt.GetCustomers();
    dataGridView1.AutoGenerateColumns = false;
    dataGridView1.DataSource = CustList.Tables[0];
}

What will be done to query this DataSet CustList and throw the results back in the same DGV, Thanks.

Possible duplicate of [LINQ query on a DataTable](https://stackoverflow.com/questions/10855/linq-query-on-a-datatable) — Dhaval Asodariya, Jan 20 '18 at 06:29

score 0 · Answer 1 · answered Jan 20 '18 at 06:28

0

Try this..

var results = from myRow in myDataTable.AsEnumerable()
where myRow.Field<int>("RowNo") == 1
select myRow;

[Reference]

answered Jan 20 '18 at 06:28

Dhaval Asodariya

558
5
19

Populating DataGridView Using LINQ Query

1 Answers1