Click here to Skip to main content
15,881,172 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am looking for a way to filter a Datagridview to another Datagridview and by using a reference number in the first column and searching for a sum of the values of this reference number in another column

Datagridview 1

For datagridview 1 in doesn't have any data table or database just get data from some text boxes


What I have tried:

can someone help me..? thanks.

sorry for my bad english.
Posted
Updated 30-May-20 23:57pm

1 solution

You could apply these steps:

  • Read the value in the first column of the first datagrid.
  • Use this value to build a (parameterized) query, selecting the data relevant to the value obtained in first step.
  • Bind the result of the query to the second datagrid.
 
Share this answer
 
Comments
colanlog 31-May-20 6:51am    
i didn't understand can you explain more please.?? am just beginner in programming
phil.o 31-May-20 7:41am    
Well, explaining all of it may take quite an amount of time, and goes far beyond the purpose of a quick answers forum. If you could use the green "Improve Question" button, and qualify your question with the relevant part of the code that you have so far, then it would be easier to provide a concrete solution.
If you really are a total beginner, I would advise to put your current project on hold, and invest some time in learning the basics of the language first. It wouldn't be a waste of time, but instead will make your learning curve much smoother, in the long term.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900