Hi there,

I have an SQL that returns number of datasets.
Something like that

SELECT * FROM A
SELECT * FROM B WHERE B_ID > 100

In my C# code I would like to access those two sets by a name instead
of index of a table

- Tables["A"], Tables["B"] instead of Tables[0], Tables[1].

How can I 'attach' a name to my DataTables?

MH

One way:

Create strong (typed) datasets, and populate them.



"M.H." <(E-Mail Removed)> wrote in message
news:O8M%(E-Mail Removed)...
> Hi there,
>
> I have an SQL that returns number of datasets.
> Something like that
>
> SELECT * FROM A
> SELECT * FROM B WHERE B_ID > 100
>
> In my C# code I would like to access those two sets by a name instead
> of index of a table
>
> - Tables["A"], Tables["B"] instead of Tables[0], Tables[1].
>
> How can I 'attach' a name to my DataTables?
>
> MH

sloan wrote:

>
> One way:
>
> Create strong (typed) datasets, and populate them.

I'm too lazy for this.
It's why we have computers to make our job easier.

MH

Hi,

One way would be to populate table names in code right after the select is
done.
AFAIK You can't do it automatically thought.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: blog.rthand.com

"M.H." <(E-Mail Removed)> wrote in message
news:O8M#(E-Mail Removed)...
> Hi there,
>
> I have an SQL that returns number of datasets.
> Something like that
>
> SELECT * FROM A
> SELECT * FROM B WHERE B_ID > 100
>
> In my C# code I would like to access those two sets by a name instead
> of index of a table
>
> - Tables["A"], Tables["B"] instead of Tables[0], Tables[1].
>
> How can I 'attach' a name to my DataTables?
>
> MH