ASP.NET - exception cannot convert string to datetime in C# application

i have written a procedure where input parameters are two varchar data type ... in those i am passing date or else i may pass empty strings ... in procedure this works fine even if i pass empty string for input parameters ,

but through asp.net application while i pass empty string to the above procedure it throws an exception where input string cannot be converted into datetime.

Datetime cannot be convert in c# eventhough it s working fine in sql

hi,

In place of blank just pass null to the @parameter and then try the code.

Hope this will help you

Hi,

only parameter is varchar datatype... but coloumn is datetime