Professional Web Applications Themes

Pass a Date to stored procedure - ASP.NET Web Services

Hello. I have a stored procedure that accepts a Date field as one of its parameters. When I try to run the webservice that I wrote to call the SP I get an "Value in date, time, or timestamp string not valid." Below is the code. The parameter is "Vehicle_Inservice_date". When the code runs in an old ASP page, the parameter is defined as type "adDate" and it works fine. How do I pass a date field to a SP? I'm using C#. I guess I need the equivalent of "adDate"(?) Thanks in advance, Mike Here's the code: [WebMethod] public ...

  1. #1

    Default Pass a Date to stored procedure

    Hello.

    I have a stored procedure that accepts a Date field as one of its
    parameters.

    When I try to run the webservice that I wrote to call the SP I get an "Value
    in date, time, or timestamp string not valid."

    Below is the code. The parameter is "Vehicle_Inservice_date". When the code
    runs in an old ASP page, the parameter is defined as type "adDate" and it
    works fine.

    How do I pass a date field to a SP? I'm using C#. I guess I need the
    equivalent of "adDate"(?)

    Thanks in advance,

    Mike

    Here's the code:
    [WebMethod]
    public string Eligibility_Category(
    string Product_Code,
    string Vehicle_Make_Code,
    int Vehicle_Year,
    int Vehicle_Odometer,
    DateTime Vehicle_Inservice_Date)
    {
    cnAS400.Open();
    myReader = cmAS400.ExecuteReader(CommandBehavior.CloseConnect ion);
    return myReader.ToString();
    }


    Mike Lopez Guest

  2. #2

    Default Re: Pass a Date to stored procedure

    Nevermind. I wasn't assigning the input parameter values.

    Thanks anyway,

    Mike

    "Mike Lopez" <MichaelLopezinds.com> wrote in message
    news:OS$YTDyAFHA.4044TK2MSFTNGP10.phx.gbl...
    > Hello.
    >
    > I have a stored procedure that accepts a Date field as one of its
    > parameters.
    >
    > When I try to run the webservice that I wrote to call the SP I get an
    > "Value in date, time, or timestamp string not valid."
    >
    > Below is the code. The parameter is "Vehicle_Inservice_date". When the
    > code runs in an old ASP page, the parameter is defined as type "adDate"
    > and it works fine.
    >
    > How do I pass a date field to a SP? I'm using C#. I guess I need the
    > equivalent of "adDate"(?)
    >
    > Thanks in advance,
    >
    > Mike
    >
    > Here's the code:
    > [WebMethod]
    > public string Eligibility_Category(
    > string Product_Code,
    > string Vehicle_Make_Code,
    > int Vehicle_Year,
    > int Vehicle_Odometer,
    > DateTime Vehicle_Inservice_Date)
    > {
    > cnAS400.Open();
    > myReader = cmAS400.ExecuteReader(CommandBehavior.CloseConnect ion);
    > return myReader.ToString();
    > }
    >
    >

    Mike Lopez Guest

Similar Threads

  1. Using XML to pass data to an Oracle Stored Procedure
    By CF_DAWG in forum Coldfusion Database Access
    Replies: 4
    Last Post: July 21st, 02:52 PM
  2. date field in update stored procedure
    By lwd in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 28th, 09:26 PM
  3. Using query string to pass a value to a stored procedure parameter
    By Machelle Chandler in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: October 20th, 11:22 PM
  4. Need more help on how to pass parameters from stored procedure into trigger
    By Ricky in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 09:51 PM
  5. How to Pass stored procedure parameters inside trigger
    By Ricky in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 09:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139