I Want To Insert 24 Month From Current Month When Button Is Click...... How Can I Do ?

Question

0.00/5 (No votes)

See more:

C#

int Month = DateTime.Now.Month - 1;

for (int i = Month; i <= 11; i++)
{
   Month++;
   using (DataTableAdapters.AttendanceRegisterTableAdapter Reg = new RRHFOEM04.DataTableAdapters.AttendanceRegisterTableAdapter())
   {
      Reg.AttendanceRegister_Insert(txtStudentID.Text, Convert.ToString(DateTime.Now.Hour + ":" + DateTime.Now.Minute), Convert.ToString(Month), "2014", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
   }
}

Above code are insert only current year month... but i want to insert next 24 month from current month

Posted 19-May-14 3:21am

Harnis Findoliya

Updated 19-May-14 4:09am

Nelek

v2

Add a Solution

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)

OriginalGriff · Accepted Answer · 2014-05-19T03:35:00

Solution 1

Try:

C#

DateTime now = DateTime.Now;
int Month = now.Month - 1;
DateTime twoYearsAhead = now.AddMonths(24);
...

Then save that value.

(It's a good idea to only read the current time once when you need it, or it can cause intermittent odd errors which are very difficult to track down if the date or time changes between fetches, as happens at the end of each minute for example.

Posted 19-May-14 3:35am

OriginalGriff

Comments

Harnis Findoliya 19-May-14 9:54am

its right.... but i want to insert only month.... twoYearsAhead is print the allover date... so how can i do that ?

Harnis Findoliya 19-May-14 9:59am

i want to insert month and year in different column...

OriginalGriff 19-May-14 10:35am

Um...you are supposed to think about what to do, not just ask and expect an answer - particularly when the code you are using already does 99% of it...
So, a Very Big Clue: What you you think the DateTime.Month property returns in your original code?
int Month = DateTime.Now.Month - 1;
Is there anything there you could use? :laugh: