c# Search data grid column for top 10 repeaters

james james

I am sure this has been asked before but I cant find an example.

I have a Winform and want to search 1 column for the Top 10 repeaters. Can you show some examples of doing such?

This is one of my search function

private void btn_SearchPart_Click(object sender, EventArgs e)
{
string Part = textBox3.Text.ToString();
if (Part != "")
{
string queryString = "SELECT SheetID, Today, Part, Type FROM LC,movietype WHERE movietype.typeID = ILC.typeID AND LC.Part LIKE '" + Part + "%'";
loadDataGrid(queryString);
textBox3.Clear();
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah8y ago
still not able to understand your requirement.

but I can suggest you some thing to debug.

did you try to execute the SQL query from your code against the database ?

did you first get the expected output in your SQL query result. may be the SQL query needs some fixing?
james james8y ago
If a part shows up more than 1 time it moves to the to ten part recored.

12 showed up 30 times
25 showed up 20 times
5 showed up 15 times
7 showed up 10 times
10 showed up 8 times
36 showed up 5 times
19 showed up 4 times
5 showed up 3 times
50 showed up 2 times
3 showed up 1 times
Nilesh Shah8y ago
please provide more details, your problem is not understandable

post your code/project as zip file attachement if possible.