Pass a Date to stored procedure

[Mike Lopez]

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]

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

Thanks anyway,

Mike

"Mike Lopez" <MichaelLopez@inds.com> wrote in message
news:OS$YTDyAFHA.4044@TK2MSFTNGP10.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();
> }
>
>