Pls help me

hoailing22 · May 20th, 2005, 06:43 AM

Hi, I want to add 7 days to the Due_Date, but i know
New_Due_Date = Due_Date + 7 Days
is wrong, but i don't know how to do that, then pass the value to table in database.

Code:

 New_Due_Date = Due_Date + 7 Days 
            sql = "INSERT INTO Renewal Values (@User_id, @Title, @Title_id, @New_Due_Date)"
            SqlDataAdapter3.InsertCommand.Parameters.Add(New _
                SqlParameter("@User_id", SqlDbType.Char, 10))
            SqlDataAdapter3.InsertCommand.Parameters.Add(New _
                SqlParameter("@Title", SqlDbType.VarChar, 100))
            SqlDataAdapter3.InsertCommand.Parameters.Add(New _
                SqlParameter("@Title_id", SqlDbType.Char, 10))
            SqlDataAdapter3.InsertCommand.Parameters.Add(New _
                SqlParameter("@New_Due_Date", SqlDbType.DateTime, 8))
            con.Open()
            SqlDataAdapter1.SelectCommand.ExecuteNonQuery()
            con.Close()

What should i write for that purpose?

Thanks!

Irene

planoie · May 20th, 2005, 08:46 AM

Have you spent any time looking over a book, tutorial or documentation for the .NET framework? You have been asking a lot of trivial questions that could be answered within a few minutes with a google search. Many of these question can be answered with the extensive contents of MSDN library online (http://msdn.microsoft.com/libary).

The DateTime datatype has many methods for doing date math such as:

DateTime.AddDays()

http://msdn.microsoft.com/library/en...dDaysTopic.asp

In your case:

New_Due_Date = Due_Date.AddDays(7)

-Peter

hoailing22 · May 23rd, 2005, 07:33 PM

Hi Peter,

I usually look for the solutions in books n through forums, websites. If i want to utilise the msdn site, how should i go for? because in msdn site, there are many technical articles.

planoie · May 24th, 2005, 11:08 AM

I'm not sure what your point is. Programming is a technical undertaking. Microsoft has provided us with complete documentation of the framework with lots of articles about the classes and methods in it. There are also many articles, tutorials, how-tos and other writings about the different things you can do in .NET. Very often when people ask questions here, I just do a search on google for a link to the answer. I if you are still getting familiar with the framework, I'd suggest just browsing over the framework namespace. I've found a lot of interesting just by looking at the list of classes available and then reading the docs about it.

-Peter