Click here to Skip to main content
15,875,643 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am developing a estimating software program to help me with work. The program has two datagridciews where one holds a database and one acts like a spreadsheet. The grid that acts as a spreadsheet cross calculates and gives a totals when info from the database is dragged and dropped to spreadsheet. My question is:

Can a datagridview be programmed to do the calculations or do I have to do use a calc engin?

Oh , and I'm new at this and I am stumped. I have been working on this for over a year. Any answers would be greatly recieved!

I can email my project to anyone who would like a better understanding of what I'm talking about.
My email address is [Email Removed]

Thank you,

Steve
Posted
Updated 21-Feb-13 10:49am
v3
Comments
ridoy 16-Dec-12 6:06am    
I think you can calculate.In some examples i saw,datagridview column values are sum up and show in the footer of it.Though i don't know whether your requirement will match it..

DataGridview cannot perform the auto calculation as you expected. You still need to write your own calc engine but DataGridView with DataTable as a datasource will do lot for you.
 
Share this answer
 
I recommend you go for a commercial grid control. Implementing a functioning grid with calculations is a huge amount of work, it's much easier to take something off-the-shelf.
 
Share this answer
 
I have seen two calc engins on the Code Project-would one of these engins work for my use? I did download one but I am having a hard time tieing it into my program. Any comments or assitance would be greatly appricated!!! Would you sugest a third party engin?

Thank you!!
 
Share this answer
 
Comments
Jibesh 16-Dec-12 23:42pm    
Please share your experience with the code you tried and where you stuck. Also please use the 'Improve Question' link to update your question and not the solution field. Its suppose meant to enter solution only.

share the code link you tried too.
Send ur project i ll send the solution...My email id s [Email Removed]
 
Share this answer
 
v2
Comments
Steve_Scott1 12-Jun-13 17:15pm    
Balamurugan1989,
Your addy was removed from your post. Thank you for offering to help me! Sorry I/m so late getting back to you. My addy is steve-scott hotmal if you will send me a message I can return it with my solution. ty ty Thank you

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