How to fill a series of date using start date and end date in C#

Question

1.24/5 (3 votes)

See more:

i have create start date and end date successfully,but i need to insert first date to last date in c#.example,

start date:01/02/2018
02/02/2018
.
.
.
.
.
end date:22/05/2018.

and i need another code also.

when i insert a value =1000.
it will insert like
01/02/2018=100.
02/02/2018=100.
03/02/2018=100.
.
.
.
.
.
.
10/02/2018=100.

please give me a c# code thank u friends.

What I have tried:

i dont know how to upload my screenshot

Posted 12-Feb-18 3:49am

Pasupathy Msc

Updated 13-Feb-18 5:51am

Add a Solution

Comments

CHill60 12-Feb-18 10:13am

Don't upload a screen shot, just post the code you have tried, use the Improve Question link. It might help to clarify your question. Also if you want the answer in C# why have you tagged SQL?

3 solutions

Solution 2

The best way to achieve that is to create stored procedure[^] on SQL server level. See an SQL code sample.

SQL

USE YourDateBaseName;

CREATE PROCEDURE uspInsertDateRange
--input variables
    @startDate DATE,
    @endDate DATE,
    @myVal INT
AS
    SET NOCOUNT ON;

    --start recursive query
    ;WITH CTE AS 
    (
        --initial values
	SELECT @startDate AS myDate, @myVal AS myValue
	WHERE @startDate <= @endDate 
        -recursion part
	UNION ALL
	SELECT DATEADD(DD, 1, myDate) AS myDate, @myVal AS myValue
	FROM CTE
	WHERE DATEADD(DD, 1, myDate) <= @endDate 
    )
    --insert statement
    INSERT INTO YourTableName (myDate, myValue )
    SELECT myDate, myValue 
    FROM CTE
    OPTION (MAXRECURSION 0)

GO;

How to call it from code? Check this: How to: Set and Get Parameters for Command Objects[^]

In case you want to use a UI to achieve that, you'll need to create DataTable[^] and SqlBulkCopy Class (System.Data.SqlClient)[^]

Try!

Posted 12-Feb-18 6:05am

Maciej Los

Updated 12-Feb-18 9:15am

v2

Comments

Pasupathy Msc 13-Feb-18 0:43am

the above code cant be execute.its shows the error
Msg 111, Level 15, State 1, Procedure uspInsertDateRange, Line 9
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
Msg 4145, Level 15, State 1, Procedure uspInsertDateRange, Line 16
An expression of non-boolean type specified in a context where a condition is expected, near ';'.
Msg 4145, Level 15, State 1, Procedure uspInsertDateRange, Line 21
An expression of non-boolean type specified in a context where a condition is expected, near ';'.
Msg 102, Level 15, State 1, Procedure uspInsertDateRange, Line 29
Incorrect syntax near 'GO'.

Maciej Los 13-Feb-18 1:46am

What's your database server: MS SQL, MySQL, PostgreSQL, other?

Pasupathy Msc 13-Feb-18 3:32am

MS SQL sir

Maciej Los 13-Feb-18 5:22am

What's version?

Pasupathy Msc 13-Feb-18 6:06am

MS SQL 2014

Maciej Los 13-Feb-18 8:33am

Above query should be executed properly. You have to follow the link about creating stored procedure.

Solution 1

So for some reason you want a list of dates from a start-date to an end-date with a difference of one day?
Just use DateTime's AddDays method.

I don't get what you could mean with "when i insert a value =1000" - Please describe your scenario better (the whole question is not very clear - Better tell what you want to achieve)

Posted 12-Feb-18 4:12am

johannesnestler

Comments

Pasupathy Msc 13-Feb-18 0:44am

say example if i insert 1000 rupees the code will be automatically assign 10 days for 100 rupees.

#realJSOP 13-Feb-18 11:43am

How are we supposed to glean that from your question (as stated)?

Pasupathy Msc 13-Feb-18 0:45am

i dont have code sir

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)

#realJSOP · Accepted Answer · 2018-02-13T05:50:00

It looks like you're trying to calculate a payment schedule based on a minimum payment value.

Simply divide the loan amount by the minimum amount due (in this case, it's 10). This will establish how many payments need to be made. Of course, your code should also handle the possibility that the payment amount is not evenly divisible into the loan amount. After you've established how many payments need to be made, it's a simple matter to establish the date of the last payment using startDate.AddMonths(numberOfPayments). If you need the actual dates (which IMHO is preposterous, but programmer homework is often rife with preposterous requirements), then iterate the months from the start date to get each subsequent payment date)

If you don't understand the assignment, ask your instructor for clarification (or try to stay awake in class while your instructor is instructing). It ain't hard...

How to fill a series of date using start date and end date in C#

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us