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?

Jan 20 '06 #1

Subscribe Reply

881

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

Jan 20 '06 #2

joshuacoad

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

Jan 20 '06 #3

Kim Quigley

Does the stored procedure have any parameters?

"NuB" <me@me.com> wrote in message
news:uM**************@TK2MSFTNGP09.phx.gbl...

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?

Jan 20 '06 #4

Similar topics

5276

Server.execute problem

by: PiGei | last post by:

hi all, I'm trying to use server.execute statement to include in an asp page another asp page with a parameter. That's because I've a parametric query in the second asp page and I have to pass...

ASP / Active Server Pages

8637

help with mysql cursor.execute()

by: William Gill | last post by:

I have been trying to pass parameters as indicated in the api. when I use: sql= 'select * from %s where cusid = %s ' % name,recID) Cursor.execute(sql) it works fine, but when I try : sql=...

Python

9338

Function to execute only once

by: PyPK | last post by:

Hi if I have a function called tmp=0 def execute(): tmp = tmp+1 return tmp also I have def func1(): execute() ....

Python

12391

Informix "foreach execute procedure": converting to DB2

by: Gustavo Randich | last post by:

Hello, I'm writing an automatic SQL parser and translator from Informix to DB2. Now I'm faced with one of the most difficult things to translate, the "foreach execute procedure" functionality...

DB2 Database

7603

ADO Execute or command execute?

by: Norman Fritag | last post by:

Hi there The below code executes some queries. As newbie I was wondering weather you are better of using connection execute or command execute to execute queries? I am asking as...

Microsoft Access / VBA

12353

can i set up a mysql db connection as a class ?

by: nephish | last post by:

hey there, i have a huge app that connects to MySQL. There are three threads that are continually connecting and disconnecting to the db. The problem is, if there is an error, it faults out...

Python

1969

using array as execute parameter in dbapi

by: gglegrp112 | last post by:

Is it possible to send an array as a parameter for an execute method in dbapi2 module? I'm using adodbapi and try to perfrom the following SQL query: select * from item where storeid in ('01',...

Python

4330

Response.Redirect & Server.Execute

by: RN1 | last post by:

When a server encounters the line Response.Redirect("abcd.asp") in a ASP script, the server tells the browser that it has to be redirected to another page (which is abcd.asp, in this case)....

ASP / Active Server Pages

4415

can a trigger do an execute immediate?

by: Oliver | last post by:

I'm fairly new to DB2. I have been assigned to build a delete trigger that finds the data type of each of the table's fields so that the trigger can then build a string consisting of OLD values...

DB2 Database

7169

How do I call ADODB Command.Execute() using JavaScript?

by: mikegolden | last post by:

An application I'm working on makes extensive use of output parameters and return values, thus forcing me to use the ADODB Command object to execute the stored procs. For recordset returning stored...

ASP / Active Server Pages

7379

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7098

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7521

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5084

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4745

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3221

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1591

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

798

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

455

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General