Re: newbie questions about dataset

I seldom use datasets the way you are describing. Basically I present
the user with a subset of records they are interested in editing and
after each edit I attempt to update the database with their changes. If
the data was changed by someone else while they were editing it I bring
back the changed record and let them know about it otherwise their
updates are committed.

Using Datasets in a batch update mode and then attempting to resolve
conflicts from multiple users is a nightmare I would rather avoid if at
all possible.

SStory wrote:
> If that is the case then what are datasets good for?
> If I and 10 other people make changes, not know what the
> other 10 did, and
> only the last persons changes are reflected, it appears to
> me that it is an
> unreliable system.
>
> Is there no way to use datasets and somehow sync the data,
> or are they just
> for readonly queries? Or am I to assume the people using
> datasets expect
> only one user to use them and update at a time--not likely.
>
> I still don't understand and believe there must be
> something that I am not
> seeing in using disconnected datasets.
>
> Thanks
>
> "SStory" <NOSPAMShane_Story@msn.com> wrote in message
> news:uL0Ywr1NDHA.3768@tk2msftngp13.phx.gbl...
>> QUESTION 1
>> I understand that a dataset is an in memory
>> representation of tables,
>> relations, etc.
>> Supposing I have multiuser app with one database. Each
>> user, using my
> app,
>> gets a dataset of the information and disconnects from
>> the DB. They make
>> changes based on the information at hand and reconnect to
>> reconcile, but
> so
>> did 10 other people.
>>
>> How is it that if I make changes based upon information
>> and someone else
>> does the same, how does the correct updated value get
>> into the database?
>>
>> Say 3 people see we have 10 of product in stock and need
>> to order more.
> All
>> three looking at a disconnected dataset as I understand
>> it--order 50 more
>> items. will there be 150 items ordered? How is this avoided in the
> dataset
>> strategy?
>>
>> QUESTION #2
>> If too much information is placed in the dataset--more
>> than memory can
>> handle, does it cache/swap to disk (i.e. part in memory
>> and the overflow
> in
>> an XML file) ?
>>
>> I am trying to get a grasp on various concepts in order to make some
>> application and understand implications of my choices.
>>
>> Thanks in advance,
>>
>> Shane

--
Direct access to this group with http://web2news.com
http://web2news.com/?microsoft.publ...ramework.adonet

I found some information in the documentation about ADO.NET and Concurrency
issues that explained how it is.
I am just wondering, why use datasets for Add/Edit and Deletes?
Maybe it isn't worth it and I should just use datacommands for important ops
and Datasets/Views for Searches and lookups.

One more question about the dataset idea.

I'm building an app that tracks incident (criminal cases) --these have
victims, witnesses,suspects, etc. Also they have there simple lookup tables
for which values are appropriate in certain fields ( a valid list if you
will).

In order for the dataset to be worth much, would I open the app build a
dataset of all tables in the database and their relationship right off the
bat so that no more connections would be necessary until adding or updating
or would each form build it's own dataset.

I am terribly confused about the whole issue and miss ADO. It seem
Microsoft has take us down a road that offers more power but at such a price
I wonder if it is worth it--it seems 100 times harder to do everything.

Thanks,

Shane

"Jay Pondy" <jpondy.news.invalid@web2news.net> wrote in message
news:46016N456@web2news.com...
> I seldom use datasets the way you are describing. Basically I present
> the user with a subset of records they are interested in editing and
> after each edit I attempt to update the database with their changes. If
> the data was changed by someone else while they were editing it I bring
> back the changed record and let them know about it otherwise their
> updates are committed.
>
> Using Datasets in a batch update mode and then attempting to resolve
> conflicts from multiple users is a nightmare I would rather avoid if at
> all possible.
>
> SStory wrote:
> > If that is the case then what are datasets good for?
> > If I and 10 other people make changes, not know what the
> > other 10 did, and
> > only the last persons changes are reflected, it appears to
> > me that it is an
> > unreliable system.
> >
> > Is there no way to use datasets and somehow sync the data,
> > or are they just
> > for readonly queries? Or am I to assume the people using
> > datasets expect
> > only one user to use them and update at a time--not likely.
> >
> > I still don't understand and believe there must be
> > something that I am not
> > seeing in using disconnected datasets.
> >
> > Thanks
> >
> > "SStory" <NOSPAMShane_Story@msn.com> wrote in message
> > news:uL0Ywr1NDHA.3768@tk2msftngp13.phx.gbl...
> >> QUESTION 1
> >> I understand that a dataset is an in memory
> >> representation of tables,
> >> relations, etc.
> >> Supposing I have multiuser app with one database. Each
> >> user, using my
> > app,
> >> gets a dataset of the information and disconnects from
> >> the DB. They make
> >> changes based on the information at hand and reconnect to
> >> reconcile, but
> > so
> >> did 10 other people.
> >>
> >> How is it that if I make changes based upon information
> >> and someone else
> >> does the same, how does the correct updated value get
> >> into the database?
> >>
> >> Say 3 people see we have 10 of product in stock and need
> >> to order more.
> > All
> >> three looking at a disconnected dataset as I understand
> >> it--order 50 more
> >> items. will there be 150 items ordered? How is this avoided in the
> > dataset
> >> strategy?
> >>
> >> QUESTION #2
> >> If too much information is placed in the dataset--more
> >> than memory can
> >> handle, does it cache/swap to disk (i.e. part in memory
> >> and the overflow
> > in
> >> an XML file) ?
> >>
> >> I am trying to get a grasp on various concepts in order to make some
> >> application and understand implications of my choices.
> >>
> >> Thanks in advance,
> >>
> >> Shane
>
> --
> Direct access to this group with http://web2news.com
> http://web2news.com/?microsoft.publ...ramework.adonet

My take on it is that the DataSet is good for those juicy controls, but yep,
it strikes me as overkill if you just want to run a query and iterate
through some records. I'm still looking into that.


"SStory" <NOSPAMShane_Story@msn.com> wrote in message
news:%23caQj5RQDHA.2320@TK2MSFTNGP12.phx.gbl...
> I found some information in the documentation about ADO.NET and
Concurrency
> issues that explained how it is.
> I am just wondering, why use datasets for Add/Edit and Deletes?
> Maybe it isn't worth it and I should just use datacommands for important
ops
> and Datasets/Views for Searches and lookups.
>
> One more question about the dataset idea.
>
> I'm building an app that tracks incident (criminal cases) --these have
> victims, witnesses,suspects, etc. Also they have there simple lookup
tables
> for which values are appropriate in certain fields ( a valid list if you
> will).
>
> In order for the dataset to be worth much, would I open the app build a
> dataset of all tables in the database and their relationship right off the
> bat so that no more connections would be necessary until adding or
updating
> or would each form build it's own dataset.
>
> I am terribly confused about the whole issue and miss ADO. It seem
> Microsoft has take us down a road that offers more power but at such a
price
> I wonder if it is worth it--it seems 100 times harder to do everything.
>
> Thanks,
>
> Shane
>
> "Jay Pondy" <jpondy.news.invalid@web2news.net> wrote in message
> news:46016N456@web2news.com...
> > I seldom use datasets the way you are describing. Basically I present
> > the user with a subset of records they are interested in editing and
> > after each edit I attempt to update the database with their changes. If
> > the data was changed by someone else while they were editing it I bring
> > back the changed record and let them know about it otherwise their
> > updates are committed.
> >
> > Using Datasets in a batch update mode and then attempting to resolve
> > conflicts from multiple users is a nightmare I would rather avoid if at
> > all possible.
> >
> > SStory wrote:
> > > If that is the case then what are datasets good for?
> > > If I and 10 other people make changes, not know what the
> > > other 10 did, and
> > > only the last persons changes are reflected, it appears to
> > > me that it is an
> > > unreliable system.
> > >
> > > Is there no way to use datasets and somehow sync the data,
> > > or are they just
> > > for readonly queries? Or am I to assume the people using
> > > datasets expect
> > > only one user to use them and update at a time--not likely.
> > >
> > > I still don't understand and believe there must be
> > > something that I am not
> > > seeing in using disconnected datasets.
> > >
> > > Thanks
> > >
> > > "SStory" <NOSPAMShane_Story@msn.com> wrote in message
> > > news:uL0Ywr1NDHA.3768@tk2msftngp13.phx.gbl...
> > >> QUESTION 1
> > >> I understand that a dataset is an in memory
> > >> representation of tables,
> > >> relations, etc.
> > >> Supposing I have multiuser app with one database. Each
> > >> user, using my
> > > app,
> > >> gets a dataset of the information and disconnects from
> > >> the DB. They make
> > >> changes based on the information at hand and reconnect to
> > >> reconcile, but
> > > so
> > >> did 10 other people.
> > >>
> > >> How is it that if I make changes based upon information
> > >> and someone else
> > >> does the same, how does the correct updated value get
> > >> into the database?
> > >>
> > >> Say 3 people see we have 10 of product in stock and need
> > >> to order more.
> > > All
> > >> three looking at a disconnected dataset as I understand
> > >> it--order 50 more
> > >> items. will there be 150 items ordered? How is this avoided in the
> > > dataset
> > >> strategy?
> > >>
> > >> QUESTION #2
> > >> If too much information is placed in the dataset--more
> > >> than memory can
> > >> handle, does it cache/swap to disk (i.e. part in memory
> > >> and the overflow
> > > in
> > >> an XML file) ?
> > >>
> > >> I am trying to get a grasp on various concepts in order to make some
> > >> application and understand implications of my choices.
> > >>
> > >> Thanks in advance,
> > >>
> > >> Shane
> >
> > --
> > Direct access to this group with http://web2news.com
> > http://web2news.com/?microsoft.publ...ramework.adonet
>
>