K
kavitha N via .NET 247
Hi All
I am trying to create crystal reports. In this concern i havecreated a command which execute a stored procedure. This storedprocedure takes three parameters which in turn i want to pass itfrom .aspx page. when i click on button parameters should passto that stored procedure.
for example
exec sp_example @date='{?selecteddate}'
here date and selected date are of type varchar() whenever i amadding this command in add command (which is there fieldexplorer -> database fields) it's saying failed to open a rowset.
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 havecreated a command which execute a stored procedure. This storedprocedure takes three parameters which in turn i want to pass itfrom .aspx page. when i click on button parameters should passto that stored procedure.
for example
exec sp_example @date='{?selecteddate}'
here date and selected date are of type varchar() whenever i amadding this command in add command (which is there fieldexplorer -> database fields) it's saying failed to open a rowset.
syntax error for converting datetime to string.
if you have any idea please do reply.