DataSets

Is there a way to use SQL like terminology but instead of accessing a
database use DataSets?

I ask because in the current project I am doing there is need to create
tables dynamically as results of queries. These tables are then used
proceed to the next step.

In a server environement I can see where if several people were doing the
same task and creating the same table there would be conflicts. So I
thought, what if I could generate DataSets and then manipulate them in
memory without creating temporary tables in the database to do the work.
However, outside of setting up simple parent-child relationships(joins) for
DataSets I don't see many options in manipulating relations between
datasets.

For instance, I would need to create joins between DataSet and tables in a
database. I also need to create Cross Joins between datasets.

Thank you in advance,

Eric

Mahesh
Sat Oct 16 00:59:57 CDT 2004

Eric,
First, DataSet is independent of the database. After you have filled DataSet
you can do anything with it without any single program through programming
(you do not need to use sql queries etc as it is with Database).
You can use relationships (joins) also and you can also cache those DataSet
objects for further use.

So, i think there will not be any problem in your case.
If anything else, then please specify exact ur need.

Regards,
Mahesh Devjibhai Dhola
"Empower yourself...."

"Beringer" <borden_eric@invalid.com> wrote in message
news:%f2cd.39434$kz3.30673@fed1read02...
> Is there a way to use SQL like terminology but instead of accessing a
> database use DataSets?
>
> I ask because in the current project I am doing there is need to create
> tables dynamically as results of queries. These tables are then used
> proceed to the next step.
>
> In a server environement I can see where if several people were doing the
> same task and creating the same table there would be conflicts. So I
> thought, what if I could generate DataSets and then manipulate them in
> memory without creating temporary tables in the database to do the work.
> However, outside of setting up simple parent-child relationships(joins)
for
> DataSets I don't see many options in manipulating relations between
> datasets.
>
> For instance, I would need to create joins between DataSet and tables in a
> database. I also need to create Cross Joins between datasets.
>
> Thank you in advance,
>
> Eric
>
>

Beringer
Sun Oct 17 23:25:35 CDT 2004

The problem that I am facing is that some data is in one database and some
is in another.
I guess the issue that I am having is how do you efficently use datasets to
do common SQL operations?

Thank you for your response.

Eric

"Mahesh Devjibhai Dhola" <mddhola@hotmail.com> wrote in message
news:eanHTV0sEHA.2300@TK2MSFTNGP09.phx.gbl...
> Eric,
> First, DataSet is independent of the database. After you have filled
> DataSet
> you can do anything with it without any single program through programming
> (you do not need to use sql queries etc as it is with Database).
> You can use relationships (joins) also and you can also cache those
> DataSet
> objects for further use.
>
> So, i think there will not be any problem in your case.
> If anything else, then please specify exact ur need.
>
> Regards,
> Mahesh Devjibhai Dhola
> "Empower yourself...."
>
> "Beringer" <borden_eric@invalid.com> wrote in message
> news:%f2cd.39434$kz3.30673@fed1read02...
>> Is there a way to use SQL like terminology but instead of accessing a
>> database use DataSets?
>>
>> I ask because in the current project I am doing there is need to create
>> tables dynamically as results of queries. These tables are then used
>> proceed to the next step.
>>
>> In a server environement I can see where if several people were doing the
>> same task and creating the same table there would be conflicts. So I
>> thought, what if I could generate DataSets and then manipulate them in
>> memory without creating temporary tables in the database to do the work.
>> However, outside of setting up simple parent-child relationships(joins)
> for
>> DataSets I don't see many options in manipulating relations between
>> datasets.
>>
>> For instance, I would need to create joins between DataSet and tables in
>> a
>> database. I also need to create Cross Joins between datasets.
>>
>> Thank you in advance,
>>
>> Eric
>>
>>
>
>

Mahesh
Mon Oct 18 07:18:56 CDT 2004

Dear Beringer,
DataSet is independent of database. You can use it in the way like, you can
feel the DataSet with one table is from Oracle and one table from SQL Server
2k. And then play with the dataset.

Regards,
Mahesh Devjibhai Dhola
"Empower yourself...."
"Beringer" <borden_eric@invalid.com> wrote in message
news:YAHcd.49606$kz3.48030@fed1read02...
> The problem that I am facing is that some data is in one database and some
> is in another.
> I guess the issue that I am having is how do you efficently use datasets
to
> do common SQL operations?
>
> Thank you for your response.
>
> Eric
>
> "Mahesh Devjibhai Dhola" <mddhola@hotmail.com> wrote in message
> news:eanHTV0sEHA.2300@TK2MSFTNGP09.phx.gbl...
> > Eric,
> > First, DataSet is independent of the database. After you have filled
> > DataSet
> > you can do anything with it without any single program through
programming
> > (you do not need to use sql queries etc as it is with Database).
> > You can use relationships (joins) also and you can also cache those
> > DataSet
> > objects for further use.
> >
> > So, i think there will not be any problem in your case.
> > If anything else, then please specify exact ur need.
> >
> > Regards,
> > Mahesh Devjibhai Dhola
> > "Empower yourself...."
> >
> > "Beringer" <borden_eric@invalid.com> wrote in message
> > news:%f2cd.39434$kz3.30673@fed1read02...
> >> Is there a way to use SQL like terminology but instead of accessing a
> >> database use DataSets?
> >>
> >> I ask because in the current project I am doing there is need to create
> >> tables dynamically as results of queries. These tables are then used
> >> proceed to the next step.
> >>
> >> In a server environement I can see where if several people were doing
the
> >> same task and creating the same table there would be conflicts. So I
> >> thought, what if I could generate DataSets and then manipulate them in
> >> memory without creating temporary tables in the database to do the
work.
> >> However, outside of setting up simple parent-child relationships(joins)
> > for
> >> DataSets I don't see many options in manipulating relations between
> >> datasets.
> >>
> >> For instance, I would need to create joins between DataSet and tables
in
> >> a
> >> database. I also need to create Cross Joins between datasets.
> >>
> >> Thank you in advance,
> >>
> >> Eric
> >>
> >>
> >
> >
>
>

Beringer
Mon Oct 18 11:56:21 CDT 2004

Ah!
Thank you for your assistance on this matter.
Eric
"Mahesh Devjibhai Dhola" <mddhola@hotmail.com> wrote in message
news:OuKPXyQtEHA.2196@TK2MSFTNGP14.phx.gbl...
> Dear Beringer,
> DataSet is independent of database. You can use it in the way like, you
> can
> feel the DataSet with one table is from Oracle and one table from SQL
> Server
> 2k. And then play with the dataset.
>
> Regards,
> Mahesh Devjibhai Dhola
> "Empower yourself...."
> "Beringer" <borden_eric@invalid.com> wrote in message
> news:YAHcd.49606$kz3.48030@fed1read02...
>> The problem that I am facing is that some data is in one database and
>> some
>> is in another.
>> I guess the issue that I am having is how do you efficently use datasets
> to
>> do common SQL operations?
>>
>> Thank you for your response.
>>
>> Eric
>>
>> "Mahesh Devjibhai Dhola" <mddhola@hotmail.com> wrote in message
>> news:eanHTV0sEHA.2300@TK2MSFTNGP09.phx.gbl...
>> > Eric,
>> > First, DataSet is independent of the database. After you have filled
>> > DataSet
>> > you can do anything with it without any single program through
> programming
>> > (you do not need to use sql queries etc as it is with Database).
>> > You can use relationships (joins) also and you can also cache those
>> > DataSet
>> > objects for further use.
>> >
>> > So, i think there will not be any problem in your case.
>> > If anything else, then please specify exact ur need.
>> >
>> > Regards,
>> > Mahesh Devjibhai Dhola
>> > "Empower yourself...."
>> >
>> > "Beringer" <borden_eric@invalid.com> wrote in message
>> > news:%f2cd.39434$kz3.30673@fed1read02...
>> >> Is there a way to use SQL like terminology but instead of accessing a
>> >> database use DataSets?
>> >>
>> >> I ask because in the current project I am doing there is need to
>> >> create
>> >> tables dynamically as results of queries. These tables are then used
>> >> proceed to the next step.
>> >>
>> >> In a server environement I can see where if several people were doing
> the
>> >> same task and creating the same table there would be conflicts. So I
>> >> thought, what if I could generate DataSets and then manipulate them in
>> >> memory without creating temporary tables in the database to do the
> work.
>> >> However, outside of setting up simple parent-child
>> >> relationships(joins)
>> > for
>> >> DataSets I don't see many options in manipulating relations between
>> >> datasets.
>> >>
>> >> For instance, I would need to create joins between DataSet and tables
> in
>> >> a
>> >> database. I also need to create Cross Joins between datasets.
>> >>
>> >> Thank you in advance,
>> >>
>> >> Eric
>> >>
>> >>
>> >
>> >
>>
>>
>
>