can't execute SP

[NuB]

I'm trying to fill my gridview (asp.net 2.0) from a sp, When I create my
SQLDataSource connection and test it, the SP works, but when I run my page,
my grid does not load with the data.
I tried to run a SP against a test DB (northwind) and it works, but I can't
get it working against my database. What am I missing here?

 

[Hans Kesting]

I'm trying to fill my gridview (asp.net 2.0) from a sp, When I create my

SQLDataSource connection and test it, the SP works, but when I run my page,
my grid does not load with the data.
I tried to run a SP against a test DB (northwind) and it works, but I can't
get it working against my database. What am I missing here?

Some questions to debug this:
* does your SP run (check SqlProfiler)?
* does it return data? Try filling a DataSet and examine that
* are table and column-mappings correct (does the grid expect the data
in the table where it is returned, do you mention specific columns and
are they really present in the DataSet?)
* any errors that you maybe ignore (just a wild guess)?

Hans Kesting

 

[joshuacoad]

You may want to check that the proper permissions are set on the stored
procedure as well.

 

[Kim Quigley]

Does the stored procedure have any parameters?