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?

> 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

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

Does the stored procedure have any parameters?

"NuB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
>
>