Solved

How do I avoid the Object reference not set error when ExecuteXmlReader has no records?

Posted on 2004-04-20
2
217 Views
Last Modified: 2008-03-10
If have a SQL Server 2000 stored procedure that returns xml using "for xml auto" and also returns a return value.  If I use ExecuteXmlReader, I get an "Object reference not set to an instance of an object" error when there are no records that meet the criteria in my stored procedure because no xml is returned.  Is there anyway to avoid this error?
0
Comment
Question by:RODEhard
2 Comments
 
LVL 5

Accepted Solution

by:
chaniewskim earned 250 total points
ID: 10870981
I use a SqlDataReader and build an XML string using StringBuilder. With that method you can check if your query returned any data using reader.HasRows
0
 

Expert Comment

by:FouadDaniels
ID: 10897930
Would not it be better to have your SP send 1 node with "Empty" node in it and test at the client if the XML contains anyth8ing other then an "Empty" node.
That way you know it has data and it will never fail. I would gues that would be much faster in your scenario.

Regards,
Fouad
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Studio Front End "Web Forms" For SQL Server Tables 5 69
Change data in datatable 8 29
Saveas need to save a copy 16 26
Help with sorting data in Listbox using VB.NET 3 53
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now