How to adjust values in datagridview windows C#

Question

0.00/5 (No votes)

See more:

I have one DataGridView and it contains five columns i.e. Name | Apr | May | Jun | July.
DataGridView represent values as

Name  |Apr | May | Jun | July 
Fee1  |100 | 100 | 100 | 100
Fee2  |500 | 500 | 500 | 500
Fee3  |700 | 700 | 700 | 700

note: this values come from a sql table

Now, my question is if I fill Rs.600 in a textBox and click on a button then I want to represent my DataGridView like

Name  |Apr | May| Jun| July 
Fee1  |100 |  0 |  0 |  0
Fee2  |500 |  0 |  0 |  0
Fee3  |  0 |  0 |  0 |  0

if I fill Rs. 1500 in a textBox and click on a button then I want to represent my DataGridView like

Name  |Apr | May| Jun| July 
Fee1  |100 |100 |  0 |  0
Fee2  |500 |100 |  0 |  0
Fee3  |700 |  0 |  0 |  0

similarly for all columns I want plz do help...........

Posted 6-Aug-16 20:41pm

Member 12245539

Updated 7-Aug-16 8:04am

Maciej Los

v2

Add a Solution

Comments

Karthik_Mahalingam 7-Aug-16 2:48am

does the gridview has always 3 rows only?

Member 12245539 7-Aug-16 3:35am

No it will increase as per requirement

Karthik_Mahalingam 7-Aug-16 3:37am

ok.

Karthik_Mahalingam 7-Aug-16 9:20am

are the columns fixed?

Member 12245539 7-Aug-16 9:26am

yes

Karthik_Mahalingam 7-Aug-16 14:04pm

check my solution.

Member 12245539 7-Aug-16 22:55pm

It is perfectly working and sorry for telling you late that. There is one more column is available before name e.i NameId and NameId is hidden. Without NameId column it is working perfectly but if I add nameId column then I get an error

"Input string was not in a correct perfomat"

Besides this If all columns sum is 10000 and I enter 10100 in textbox then it should show a message (Plz chech your entry).

Member 12245539 7-Aug-16 23:08pm

I got for ignoring column NameId
I can do

"for (int i = 2; i < dgv.Columns.Count; i++)"

instead of

for (int i = 1; i < dgv.Columns.Count; i++)

But message I need... for increasing amount......

Karthik_Mahalingam 7-Aug-16 23:13pm

for (int i = 1; i < dgv.Columns.Count; i++
this will do the job.

what message?

Member 12245539 7-Aug-16 23:16pm

If if all columns sum is 10000 and I enter 10100 in textbox then it should show a message (Plz chech your entry).

Karthik_Mahalingam 7-Aug-16 23:40pm

try this

int amount = Convert.ToInt32(textBox1.Text.Trim());
for (int i = 2; i < dgv.Columns.Count; i++)
{
foreach (DataGridViewRow row in dgv.Rows)
{
int value = Convert.ToInt32(row.Cells[i].Value);
if (amount >= value)
amount = amount - value;
else if (amount == 0)
row.Cells[i].Value = amount;
else
{
row.Cells[i].Value = amount;
amount = 0;
}
}
}
if (amount > 0)
{
MessageBox.Show("Please check the amount");
}

Member 12245539 8-Aug-16 0:00am

Thanks a lot!!!!!!

Karthik_Mahalingam 8-Aug-16 0:02am

Welcome

Member 12245539 29-Aug-16 22:44pm

Mr.Kartika plz do help plz!!!!!!!
The link is below.

http://www.codeproject.com/Questions/1121112/How-to-sum-datagridview-column-in-last-column-thro

Karthik_Mahalingam 29-Aug-16 23:19pm

Hii am bit busy today, will look into that later evening.

Member 12245539 29-Aug-16 23:22pm

OK THANKS

Karthik_Mahalingam 2-Sep-16 3:58am

seems the issue is solved.

Member 12245539 2-Sep-16 4:46am

No sir I am still waiting.......

Karthik_Mahalingam 2-Sep-16 7:07am

i am not getting the complete business logic.

Member 12245539 2-Sep-16 8:25am

This is a DataGridView Control. The values come from sql table.
S_Id | Apr | May | Jun | Fine | Total
1001 | 100 | 100 | 100 | 0 | 0
1002 | 0 | 200 | 200 | 0 | 0
1003 | 300 | 200 | 200 | 0 | 0

Besides this,
There are three checkboxes also available in right side of DataGridView in the name of Apr_CheckBox, May_CheckBox & Jun_CheckBox.

Now, my question if I click on Apr_CheckBox then the value of DataGridView Apr column should display in last column i.e. Total of all rows like

S_Id | Apr | May | Jun | Fine | Total
1001 | 100 | 100 | 100 | 0 | 100
1002 | 0 | 200 | 200 | 0 | 0
1003 | 300 | 200 | 200 | 0 | 100

besides this.
One formula should be there for fine column. If PC's(System) date is 20.04.2016 then it should count the days between 15.04.2016 to 20.04.2016 and multiply with 5. After multiplication it should show the multiplication values in fine column. like

Assume that between 16.04.2016 to 20.04.2016 days is 5.

S_Id | Apr | May | Jun | Fine | Total
1001 | 100 | 100 | 100 | 25 | 100
1002 | 200 | 200 | 200 | 0 | 100
1003 | 300 | 200 | 200 | 25 | 100

similar for two more columns May and June.

Perhaps it is understandable.......

Sir Plz see.......

Karthik_Mahalingam 5-Sep-16 7:04am

i understood first requiremnt
second one is fine from 15th day of the month ?

Karthik_Mahalingam 5-Sep-16 7:04am

do you have team viewer?

Member 12245539 7-Sep-16 0:02am

Yes I have........

Karthik_Mahalingam 7-Sep-16 0:05am

come online after 7pm IST

Member 12245539 7-Sep-16 0:06am

OK

Karthik_Mahalingam 7-Sep-16 0:07am

are you from india

Member 12245539 7-Sep-16 0:08am

Yes
India
New delhi

Karthik_Mahalingam 7-Sep-16 0:09am

Ok.. fine

Member 12245539 7-Sep-16 9:33am

Boss I am Back........

Karthik_Mahalingam 7-Sep-16 11:56am

sir, just now reached home, ping me if online

Member 12245539 7-Sep-16 11:59am

okShould I tell ID and Pass??

Karthik_Mahalingam 7-Sep-16 12:00pm

yes

Member 12245539 7-Sep-16 12:01pm

185 888 701

2330

Karthik_Mahalingam 7-Sep-16 12:07pm

wrong password

Member 12245539 7-Sep-16 12:07pm

6618

Karthik_Mahalingam 7-Sep-16 12:08pm

ok

Member 12245539 8-Sep-16 0:39am

Sir is it done???

Karthik_Mahalingam 9-Sep-16 0:44am

no sir, i havent looked into it.
the connectoin got disconnected on that day. coundnt see

Member 12245539 9-Sep-16 0:50am

Ok Sir...
As per your recommendation I have done. And sum of all rows is working.But Fine scheme it has to be implemented...

Karthik_Mahalingam 9-Sep-16 0:52am

take a pen and paper, draw the flowchart and convert it into an algorithm and then code it.
even i am going to do the same only, whatever ur logic is

Member 12245539 9-Sep-16 2:09am

okz....
Thanks......

Karthik_Mahalingam 9-Sep-16 2:11am

hmm

Member 12245539 22-Jul-21 3:29am

karthik Sir,
You have helped me a lot. Sir can you solve my one more question
the code is here..

private void button1_Click(object sender, EventArgs e)
{
int amount = Convert.ToInt32(textBox1.Text.Trim());
for (int i = 1; i < dgv.Columns.Count; i++)
{
foreach (DataGridViewRow row in dgv.Rows)
{
int value = Convert.ToInt32(row.Cells[i].Value);
if (amount >= value)
amount = amount - value;
else if (amount == 0)
row.Cells[i].Value = amount;
else
{
row.Cells[i].Value = amount;
amount = 0;
}
}
}
}

I want to covert this window to web and the same should work through javascrip

Karthik_Mahalingam 22-Jul-21 10:07am

Which control you are using!?

Member 12245539 22-Jul-21 14:08pm

Asp.net with C#

Member 12245539 7-Aug-16 3:13am

No it will increase as per requirement

Richard MacCutchan 7-Aug-16 3:36am

You need to write an event handler for the button click, to change the values as per your requirement. What is the problem?

Maciej Los 7-Aug-16 3:52am

Not clear! Please, be more specific and provide more details about your requirements. We can't read in your mind and we don't see your screen.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Karthik_Mahalingam · Accepted Answer · 2016-08-07T08:04:00

Try this

C#

private void button1_Click(object sender, EventArgs e)
       {
           int amount = Convert.ToInt32(textBox1.Text.Trim());
           for (int i = 1; i < dgv.Columns.Count; i++)
           {
               foreach (DataGridViewRow row in dgv.Rows)
               {
                   int value = Convert.ToInt32(row.Cells[i].Value);
                   if (amount >= value)
                       amount = amount - value;
                   else if (amount == 0)
                       row.Cells[i].Value = amount;
                   else
                   {
                       row.Cells[i].Value = amount;
                       amount = 0;
                   }
               }
           }
       }


       private void Form3_Load(object sender, EventArgs e)
       {
           DataTable dt = new DataTable();
           dt.Columns.Add("Name");
           dt.Columns.Add("Apr");
           dt.Columns.Add("May");
           dt.Columns.Add("Jun");
           dt.Columns.Add("July");
           dt.Rows.Add("Fee1", 100, 100, 100, 100);
           dt.Rows.Add("Fee2", 500, 500, 500, 500);
           dt.Rows.Add("Fee3", 700, 700, 700, 700);
           dgv.DataSource = dt;
           dgv.AllowUserToAddRows = false;
       }