Recognize Stored Procedure in Dataset

[Finn Stampe Mikkelsen]

Hi

Is there anyway to recognize wether a given datatable in a dataset is the
result of a stored procedure in the database??

Here is som pseudo-code of what i mean... Can i detect if a given Dt is the
result of a call to a SP?

foreach (DataTable Dt in DS.Tables)
{
if (!dt is SP)
{
}
}

TIA

/FStampe
--
Der er 10 slags mennesker - Dem som forstår binær og dem som ikke gør.
There are 10 kinds of people. Those who understand binary and those who
don't.
Es gibt 10 Arten von Menschen. Die, die Binär verstehen, bzw. die, die es
nicht tuhen.

 

[Patrice]

Hi,

AFAIK no (it could even have been constructed in memory without using a db).
You could however add a property (using ExtendedProperties) to store this
info or btter hide this from your main code in your db update layer. IMO
your best bet would be to explain what you are trying to do...

 

[Finn Stampe Mikkelsen]

Hi,

AFAIK no (it could even have been constructed in memory without using a
db). You could however add a property (using ExtendedProperties) to store
this info or btter hide this from your main code in your db update layer.
IMO your best bet would be to explain what you are trying to do...

Hi Patrice..

It's actually something along the way of my other question you have
participated in. I have tried to give additional info there.

I that regard, i did not want to backup tables, that are results of an SP,
since they are generated based on the rest of the data... So for further
explanation, pls. refer to the other thread in which we have been writing..

/FStampe
++++