Click here to Skip to main content
12,634,422 members (27,147 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
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 16-Dec-12 0:18am
Updated 21-Feb-13 11: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..
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 4

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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!!
  Permalink  
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.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

Send ur project i ll send the solution...My email id s [Email Removed]
  Permalink  
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 22 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100