what's the point of using a dataset in ASP.net?

[Naveen K Kohli]

Ofcourse.. if you are using the data as read only. But if you have to go
back and froth between records then you can't do that with DataReader.

--
Naveen K Kohli
[url]http://www.netomatix.com[/url]
"neil m" <nospam.macguigan@hotmail.com> wrote in message
news:6x2La.308229$ro6.7513889@news2.calgary.shaw.c a...

> what's the point of using a dataset in ASP.net?
>
> why not just use datareader?
>
> thx
>
> nm
>
>

[neil m]

how is data not read-only if you are showing it as an HTML webpage?

what do you mean going back and forth between records?


"Naveen K Kohli" <naveenkohli@hotmail.com> wrote in message
news:%23o3itKPPDHA.1608@TK2MSFTNGP11.phx.gbl...

> Ofcourse.. if you are using the data as read only. But if you have to go
> back and froth between records then you can't do that with DataReader.
>
> --
> Naveen K Kohli
> [url]http://www.netomatix.com[/url]
> "neil m" <nospam.macguigan@hotmail.com> wrote in message
> news:6x2La.308229$ro6.7513889@news2.calgary.shaw.c a...

> > what's the point of using a dataset in ASP.net?
> >
> > why not just use datareader?
> >
> > thx
> >
> > nm
> >
> >

>
>

[Terance Emory]

The real reason a dataset is of use in ASP.NET is the XML
storage. I never iterate through records using Code
anymore, I use XSLT for transforming data so the
convenience of the getXML() method on the Dataset is very
nice. Some day I may write a class thats a little easier
on memory but I have been very happy with the Dataset so
far.

I also have yet to buy into Databinding for a production
website, so I haven't used this feature nearly as much as
some but that would require the Dataset also.

Hope this helps.

>-----Original Message-----
>what's the point of using a dataset in ASP.net?
>
>why not just use datareader?
>
>thx
>
>nm
>
>
>.
>

[Ante Perkovic]

neil m wrote:

> how is data not read-only if you are showing it as an HTML webpage?

You can store data from database to dataset, investigate it, perform
complicated operation on dataset (add, delete, update, just like it is
database itself) and simply call some methods to update the database
accordingly to changes you made to dataset.

> what do you mean going back and forth between records?

Every time you call datareader.read() method, one row from database is
transferred to your asp.net code. You can only read it (can't change it), you
can't (without repeating the query) go back to previous row, once you read
the next row.

HTH, Ante

[Kevin Spencer]

A DataReader is a connected forward-only read-once type of result set. A
DataSet is a disconnected container which provides richer navigational
capabilities, as well as the ability to persist data as XML. The DataReader
is faster, so it should be used when the extra functionality of a DataTable
or DataSet is not needed.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
[url]http://www.takempis.com[/url]
Big things are made up of
lots of Little things.

"neil m" <nospam.macguigan@hotmail.com> wrote in message
news:6x2La.308229$ro6.7513889@news2.calgary.shaw.c a...

> what's the point of using a dataset in ASP.net?
>
> why not just use datareader?
>
> thx
>
> nm
>
>