Another VB .NET Question

[Magic Hat]

Ok what Im trying to do is create records in a loop.
What Im looking for is for the user to enter a start date and end date and have it enter the data into an sql database, increasing the date by a set number of days. Here is my code:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim inputdate, lastdate As Date
inputdate = Me.startdate.Value
lastdate = Me.enddate.Value

Do While inputdate < lastdate

inputdate.AddDays(7)
MsgBox(inputdate)
Loop
End Sub

The problem Im running into is it just keeps outputing the orginal date selected, never actually adding 7 days, and staying within the loop.

The msgbox is just for debugging right now, I want to replace it with code to enter that data in the sql db. Any help would be appreciated

 

[Skyruner2]

replace:

inputdate.AddDays(7)

with

inputdate = inputdate.AddDays(7)

and that should be it..

sure you can add 7 days to a date, but if you dont save that, what good will it do you..


edit:

i lookd this up on the MSDN:
http://msdn.microsoft.com/library/d...html/frlrfSystemDateTimeClassAddDaysTopic.asp

Remarks
This method does not change the value of this DateTime. Instead, a new DateTime is returned whose value is the result of this operation.

 

[Magic Hat]

Thanks it worked!.

Now time to figure out how to actually add a SQL record in VB.....this is alot harder than the old ms access db

 

[benamaster]

To add a record you'll need a SqlConnects, SqlDataAdapter, and a DataSet. That is the way I have always done it for viewing and updating records, depending on what you want to do you could use a DataGrid or GridView depending on what version of VB.NET you're using. I've never used 2002 just 2003 and 2005.