Hi All
I am trying to create crystal reports. In this concern i have created a command which execute a stored procedure. This stored procedure takes three parameters which in turn i want to pass it from .aspx page. when i click on button parameters should pass to that stored procedure.
for example
exec sp_example @date='{?select eddate}'
here date (varchar in stored procedure) and selected date (string type i selected) whenever i am adding this command in add command (which is there field explorer -> database fields) it's saying failed to open a row set.
syntax error for converting datetime to string.
if you have any idea please do reply.
I am trying to create crystal reports. In this concern i have created a command which execute a stored procedure. This stored procedure takes three parameters which in turn i want to pass it from .aspx page. when i click on button parameters should pass to that stored procedure.
for example
exec sp_example @date='{?select eddate}'
here date (varchar in stored procedure) and selected date (string type i selected) whenever i am adding this command in add command (which is there field explorer -> database fields) it's saying failed to open a row set.
syntax error for converting datetime to string.
if you have any idea please do reply.
Comment