I am trying to retrieve data from a stored procedure. Our SP's are written to be generic so while they can have up to 24 parameters they only need one parameter (or many) to run. I have built a grid that puts a default value into one of 8 parameters for this SP. If I run a Test Query I get the data I expect back. When I try running the web page I get nothing (actually a thin gray bar across the top of the web page). I know the connection and page are setup correctly because if I run another SP that has no parameters I get data back. Any ideas on why this is occurring (or not)? Does this have something to do with binding?
TIA,
Joe B
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 24 Mar 2009, 11:20 AM
Hi Joe,
From the above post I guess the Grid is not getting bound the data. I am not sure how you are passing the parameters. May this code library will help you to use stored procedure in RadGrid.
Update/Insert/Delete with stored procedures and SqlDataSource control
Thanks
Shinu.
From the above post I guess the Grid is not getting bound the data. I am not sure how you are passing the parameters. May this code library will help you to use stored procedure in RadGrid.
Update/Insert/Delete with stored procedures and SqlDataSource control
Thanks
Shinu.