473,803 Members | 4,157 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sql Data Reader

I have a SQL stored procedures which evaluate the values passed in parameters
and then based on those values reads the appropriate records.

I run the stored procedure in VS 2005 Debug mode and it successfully
executes and I can see the @@ROWCOUNT has the expected number of rows.

When I actually do this with my program, the datareader is returned with no
execption, but no rows are found in the reader.

So I change my Stored procedure to not even look at the parameter values
being passed and just return rows. When I run this version of the stored
procedure, I get plenty of rows returned.

I change my stored procedure and create 2 output parameters so that I can
echo back the parameter values which were received by the program. When I
rerun the program, nothing is returned back in those parameters but a bunch
of rows are returned.

I have dumped the values of the parameters before the invoking the
DataReader method and it looks good to me. What could possibly be wrong?
Aug 14 '06 #1
1 1707
sql output parameters are not returned until after all result sets have been
processed. add this loop after you have read your rows, then you can access
the output parameters:

while (reader.NextRes ult()) ;

-- bruce (sqlwork.com)

"Jim Heavey" <Ji*******@disc ussions.microso ft.comwrote in message
news:CE******** *************** ***********@mic rosoft.com...
>I have a SQL stored procedures which evaluate the values passed in
parameters
and then based on those values reads the appropriate records.

I run the stored procedure in VS 2005 Debug mode and it successfully
executes and I can see the @@ROWCOUNT has the expected number of rows.

When I actually do this with my program, the datareader is returned with
no
execption, but no rows are found in the reader.

So I change my Stored procedure to not even look at the parameter values
being passed and just return rows. When I run this version of the stored
procedure, I get plenty of rows returned.

I change my stored procedure and create 2 output parameters so that I can
echo back the parameter values which were received by the program. When I
rerun the program, nothing is returned back in those parameters but a
bunch
of rows are returned.

I have dumped the values of the parameters before the invoking the
DataReader method and it looks good to me. What could possibly be wrong?

Aug 14 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
3328
by: Mike L | last post by:
I tried a sample of code in MSDN magazine, but now I'm stuck. What code has the best performance to populate a Data Grid with a SP? Below is the code I have, which might be completing the wrong way to populate a data grid. I like using code and not the server explorer. (I replaced the sa password for this post.) private void frmDealerSearch_Load(object sender, System.EventArgs e) { string sConnString = "Data
2
6552
by: Robert Smith jr. | last post by:
Hello, Please pardon my newbie question ... I am building an ASP.NET page that displays a recordset with a Delete statement enabled (this all works fine). I want to Insert the current row *that is going to be deleted* into another table, before the original data is deleted. I am trying to use the RowDeleting method to call an Update or Insert
4
1735
by: Ram | last post by:
I am using ADO.Net data reader to retrieve data from main frame. I am getting timestamp which is 26 (yyyy-mm-dd hh- mm-ss.123456) bytes as sqltimestamp data type. I am using data reader to retrieve this values and when i get it from data reader it is coverting as (yyyy-mm-dd hh-mm-ss AM or PM) and drops milliseconds. If any one of you come across this problem pls let me know how u have handled this situation.
2
7535
by: Joe | last post by:
Anyone can suggest the best method of reading XML and adding data to ListView? Here is the xml data structure:: <xml> <site> <url>http://www.yahoo.com</url> <lastupdate></lastupdate> <check>1</check>
0
1193
by: Crazy Cat | last post by:
In the following code I retrieve data from a stored procedure that returns multiple resultsets (the results of the stored procedure have been stored in a datareader called reader). On each iteration a tab page is added to a tab control and a datagridview is created on that the tab page. In the first iteration I can set all the values with no problems, however on the next iteration, even though there is definitely data in the data source,...
6
1478
by: Jim Heavey | last post by:
I am new to SqlServer, have been using Oracle in a prior life. I have written a very simple stored procedure in SQL Server and it (the query) looks like the following... Select AD_ID, First_Name, Last_Name, User_Type, Phone_Nbr, Email_Addr From dbo.User_Tbl Where UPPER(AD_ID) = UPPER(@AD_ID) and UPPER(User_Type) = UPPER(@User_Type)
1
2770
by: weird0 | last post by:
I have created a GridView and dynamically added data to it by creating a DataTable(as advised) and bound it with a reader. Then, assigned the DataSource of GridView to DataTable. But even that aint working as alternatively assigned reader obj. to datasource of GridView. Here is the code for the aspx.cs page: ( The reader surely cootains data as its HasRows property is true). Plz help. Never got stuck this bad with a problem. For more...
0
1161
by: bill | last post by:
Can someone please show me what to do with this to show the data in a dataGrid for example? I'm not really sure what to do with it. I'm used to Vb6. Dim Con = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;" & "data source=c:\_Archive\Documentation - Projects\Hardware Tracking - 2008\IT_Assets.mdb") Dim Cmd As New OleDb.OleDbCommand("SELECT * from tblAssets where asset_tag = @fn", Con)
1
3509
by: =?Utf-8?B?SkI=?= | last post by:
Hello My pgm1 (User Interface Level) passes an empty ArrayList to pgm2 (Business Logic Level). pgm2 then calls pgm3 (Data Access Level) to populate the ArrayList. Question1: When pgm2 gets the ArrayList back from pgm3 how to extract and separate the fields out fo the ArrayLists? Question2: When pgm3 gets ArrayList back from pgm2 how to separate the
1
2827
by: dotnetnovice | last post by:
Hi everybody... I want to show data in the data gridview placed in my form after getting data from my data access layer class through a class... Here is my code in the data access layer class. public class DBHandler { public List<Programs> GetAllPrograms() {
0
9564
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10548
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10295
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10069
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9125
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7604
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5500
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4275
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 we have to send another system
2
3798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.