DataSet and SQL results dont match, help

[Guest]

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?

 

[pvdg42]

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?

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?

 

[Robson Siqueira]

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.