I've a gridview that I'm binding on a dropdownlist select index change event.
I've a stored procedure(which works fine when executed) which i pass in sqlcommand.
when i execute this sqlcommand it returns -1 as its value
what could possibly be wrong as my stored procedure is working find and i just cannot locate the error....
Loading

Amit ChoudharyPosted Feb 18, 2010, 2:03 AM
you can use SqlDataAdapter to fetch data into a Dataset.
RujutaPosted Feb 18, 2010, 3:27 AM
Thanks a ton for responding.
Well I figured that out myself, but still I'll give it to you......
Amit ChoudharyPosted Feb 18, 2010, 1:58 AM
Please post the error and stack trace so that i can identify the source of error.
RujutaPosted Feb 18, 2010, 1:54 AM
The parameters I passsed are right It was some other problem
SivaRamaKrishna RajuPosted Feb 18, 2010, 1:45 AM
from question i am getting something but not clear
when a statement returns -1 means it is not working well when you place the code then there is a chance to identify the bug.
some queries are work in sql editor but when coming to real work it causes error please check the parameters you passed to it once
Hadi KiwanPosted Feb 18, 2010, 1:41 AM