How to minus two datagridview columns value in third column

Question

0.00/5 (No votes)

See more:

Hi,
i Have Same Columns in My DataGridView in C# WinForm

LastDate TodayDate RemainingDay
18/05/2020 01/05/2020 17

I Need in my DataGridView (LastDate) and (TodayDate) Columns Values Minus Automatic and Show in My (RemainingDay) Columns

What I have tried:

i Try Same Method But Not Work Properly

so Please Help me

Posted 1-May-20 2:15am

Amar chand123

Updated 1-May-20 22:43pm

Add a Solution

4 solutions

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)

MadMyche · Answer 1 · 2020-05-01T02:25:00

Solution 1

Perhaps you could use the DateTime.Subtract()[^] method to populate that column.

Reference:
DateTime.Subtract Method (System) | Microsoft Docs[^]

Posted 1-May-20 2:25am

MadMyche

phil.o · Answer 2 · 2020-05-01T02:31:00

Solution 3

C#

int remainingDays = (lastDate - todayDate).Days;

Posted 1-May-20 2:31am

phil.o

Comments

MadMyche 1-May-20 8:44am

+5 Hopefully these columns truly are dates and not strings

phil.o 1-May-20 8:49am

Thanks :) I wondered the same, but we can just ammend the answer if strings were used instead of proper datatype.

Amar chand123 1-May-20 9:06am

private void LoadSr()
{

foreach (DataGridViewRow row in dataGridView2.Rows)
{
DateTime dt = Convert.ToDateTime(dataGridView2.CurrentRow.Cells["LasttDate"].Value);
DateTime dt1 = Convert.ToDateTime(dataGridView2.CurrentRow.Cells["TodayDate"].Value);
int d12 = (dt - dt1).Days;

row.Cells["DueDay"].Value = d12;

}
}
sir, i Try This Code But Show Error i am is new in Programming so can you help

An unhandled exception of type 'System.InvalidCastException' occurred in mscorlib.dll

Additional information: Object cannot be cast from DBNull to other types.

phil.o 1-May-20 9:22am

It means that one of the column has not been provided any value, and thus is null.
As a side note, please do NOT use Convert class to handle valuetype's parsing; use DateTime.TryParse() method instead.

if (!DateTime.TryParse(dataGridView2.CurrentRow.Cells["LasttDate"].Value, out DateTime lastDate))
{
   // Problem: lastDate could not be properly parsed. You have to decide what to do in that case.
   // ...
}
if (!DateTime.TryParse(dataGridView2.CurrentRow.Cells["TodayDate"].Value, out DateTime todayDate))
{
   // Problem: todayDate could not be properly parsed. You have to decide what to do in that case.
   // ...
}
int remaining = (lastDate - todayDate).Days;

OriginalGriff · Answer 3 · 2020-05-01T02:30:00

IFf this is just for display purposes, then the easiest way is to handle the CellPainti8ng event for the DGV, check if it's the "difference column", and if it is, calculate it and show the value. I do something similar with couling DGV cells to indicate anomalous values: Colouring DataGridView Cells According to their Content in WinForms[^] - it's should be pretty easy to do what you wanted from that.

If you want it persisted back to your DB, then you would need to work on the data source, not the DGV .

Mohamed Aboelkheer · Answer 4 · 2020-05-01T22:44:00

Solution 4

Maybe you can use the difference between a date in sql query

SELECT LastDate ,TodayDate ,DATEDIFF(day, LastDate, TodayDate) AS RemainingDay

Posted 1-May-20 22:44pm

Mohamed Aboelkheer