Stupid dataset question...

[KC]

From what little I understand about them, datasets are like mini-databases.
If this is so, can I query tables in that dataset? What kind of object would
I hold the result set in?
Ken

[Jay B. Harlow [MVP - Outlook]]

Ken,
You can use either a DataView or DataTable.Select to query tables in a
DataSet.

The DataView is an object in its own right, If you use a For Each on a
DataView it will return DataRowView objects, while DataTable.Select returns
an array of DataRow objects.

For details on this and other exciting questions on ADO.NET (Datasets) I
would recommend Sceppa's book, which is a good tutorial on ADO.NET as well
as a good desk reference once you know ADO.NET. David Sceppa's book is
"Microsoft ADO.NET - Core Reference" from MS press.

Hope this helps
Jay

Hope this helps
Jay

"KC" <yo*@dontneed.this> wrote in message
news:ea*************@TK2MSFTNGP12.phx.gbl...

From what little I understand about them, datasets are like mini-databases. If this is so, can I query tables in that dataset? What kind of object would I hold the result set in?
Ken

[Ken Tucker [MVP]]

Hi,

http://msdn.microsoft.com/library/de...electtopic.asp

Ken
---------------------

"KC" <yo*@dontneed.this> wrote in message
news:ea*************@TK2MSFTNGP12.phx.gbl:

From what little I understand about them, datasets are like
mini-databases.
If this is so, can I query tables in that dataset? What kind of object
would
I hold the result set in?
Ken

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.0 - Release Date: 6/12/2004

[One Handed Man \( OHM - Terry Burns \)]

Come on Jay, tell me, Just how much is David paying you to plug his book ?

;-)

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:O3*************@tk2msftngp13.phx.gbl...

Ken,
You can use either a DataView or DataTable.Select to query tables in a
DataSet.

The DataView is an object in its own right, If you use a For Each on a
DataView it will return DataRowView objects, while DataTable.Select returns an array of DataRow objects.

For details on this and other exciting questions on ADO.NET (Datasets) I
would recommend Sceppa's book, which is a good tutorial on ADO.NET as well
as a good desk reference once you know ADO.NET. David Sceppa's book is
"Microsoft ADO.NET - Core Reference" from MS press.

Hope this helps
Jay

Hope this helps
Jay

"KC" <yo*@dontneed.this> wrote in message
news:ea*************@TK2MSFTNGP12.phx.gbl...

From what little I understand about them, datasets are like

mini-databases.

If this is so, can I query tables in that dataset? What kind of object

would

I hold the result set in?
Ken

[Jay B. Harlow [MVP - Outlook]]

Terry,
Not nearly enough :-)

But Hey I plug Fowler's book an awful lot also!

I just find it the easiest read to learn ADO.NET!

Jay

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message
news:uY***************@tk2msftngp13.phx.gbl...

Come on Jay, tell me, Just how much is David paying you to plug his book ?

;-)

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

<<snip>>

[One Handed Man \( OHM - Terry Burns \)]

The Framework and its nuances in total are both immense and complex (
though well thought out ) , when I first started with .NET I really had no
Idea how huge it really is, I had this opinion that I would be able to learn
it's main parts in a couple of weeks, and be really good within six months.

Considering the sheer scope of knowledge one needs JUST to get a reasonable
understanding of what's possible, let alone be proficient in most area's
it's really amazing that good .NET people are not mostly millionaires
--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:uW**************@TK2MSFTNGP12.phx.gbl...

Terry,
Not nearly enough :-)

But Hey I plug Fowler's book an awful lot also!

I just find it the easiest read to learn ADO.NET!

Jay

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message news:uY***************@tk2msftngp13.phx.gbl...

Come on Jay, tell me, Just how much is David paying you to plug his book ?
;-)

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

<<snip>>

[Cor Ligthert]

Hi KC,

In addition to the others, a dataset is definitely not a mini database.

It can hold data from a database in memory where it reflects as well a lot
of the structure from the selected data from databases (it can be more than
one).

That dataset can as well be transported over the internet and as well saved
on disk in a XML format. However not be accessed in a database way, it is
only read or write of the whole dataset.

To process the data in a dataset are many methods, you can databind it, and
select the rows, filter rows, loop trough rows, add columns, and delete
columns, however only in memory.

Just a little addition.

Cor

[KC]

Much Thanks!

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:O3*************@tk2msftngp13.phx.gbl...

Ken,
You can use either a DataView or DataTable.Select to query tables in a
DataSet.

The DataView is an object in its own right, If you use a For Each on a
DataView it will return DataRowView objects, while DataTable.Select returns an array of DataRow objects.

For details on this and other exciting questions on ADO.NET (Datasets) I
would recommend Sceppa's book, which is a good tutorial on ADO.NET as well
as a good desk reference once you know ADO.NET. David Sceppa's book is
"Microsoft ADO.NET - Core Reference" from MS press.

Hope this helps
Jay

Hope this helps
Jay

"KC" <yo*@dontneed.this> wrote in message
news:ea*************@TK2MSFTNGP12.phx.gbl...

From what little I understand about them, datasets are like

mini-databases.

If this is so, can I query tables in that dataset? What kind of object

would

I hold the result set in?
Ken

[Armin Zingler]

"KC" <yo*@dontneed.this> schrieb

From what little I understand about them, datasets are like
mini-databases. If this is so, can I query tables in that dataset?
What kind of object would I hold the result set in?

Hint: microsoft.public.dotnet.framework.adonet
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html