c# String Query to find top 10 records in database

[Booney440]

I have asked this question before but didn’t explain correctly what was needed. I will try again please bear with me.

I have an access database and I want to look at one column and count how many times a number is repeated, sort highest to lower order. The code I have so far will show the top 10 rows. I need it to count and if it’s a repeated entry to sum it and list it high to low.

private void btn_Top_10_Click(object sender, EventArgs e)
{
string queryString = "SELECT SheetID, Part FROM ILC";
queryString = "select top 10 Part,Part from ILC";
loadDataGrid(queryString);
}

data base on left, results I'm getting so far on right.

It should show 123 is repeated 5 times and should be at the top.

the number 1 is repeated 3 times and should be next and so on.

Thanks






Booney440

Continue reading...