DataSet and SQL results dont match, help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JP - 01 Feb 2007 16:17 GMT

As anyone ever run into this before. VS 2005 C#. This is a combination of SQL
and framework so I wasn’t quite sure where to post it.

I have a SP that executes multiple SELECT statements. If the ROWCOUNT = 0 it
executes the next SELECT and so fourth. In the past its always been that the
last SELECT executed would be the results that were returned to whatever
objAdapter executed the SP.

However, I’ve noticed that the results in the data adapter always contain
the results of the first SELECT. So if SELECT #1 returned 0 records and the
last SELECT returned 3 records, the dataset would have 0 records.

Is this a bug? How can it be fixed?

--
JP
.NET Software Developer

Reply to this Message

pvdg42 - 01 Feb 2007 16:31 GMT

> As anyone ever run into this before. VS 2005 C#. This is a combination of
> SQL
[quoted text clipped - 13 lines]
>
> Is this a bug? How can it be fixed?

In order to address your question, we'd need to see your code. Can you show
the selection logic block, or better still, reproduce the symptoms in a
short, but complete program?

Reply to this Message

Robson Siqueira - 01 Feb 2007 22:07 GMT

JP,

If you are using DataReader, make sure you go for the next result set.
Normally I don't use data adapters, I fill the data set by myself or I use
the Microsoft Application Blocks for that.

I hope it helps.

Signature

Regards,
Robson Siqueira
Enterprise Architect

>
>> As anyone ever run into this before. VS 2005 C#. This is a combination of
[quoted text clipped - 18 lines]
> show the selection logic block, or better still, reproduce the symptoms in
> a short, but complete program?

Reply to this Message

DataSet and SQL results dont match, help

Free Magazines