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 8 988
Ken,
You can use either a DataView or DataTable.Selec t 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.Selec t 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.t his> wrote in message
news:ea******** *****@TK2MSFTNG P12.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
Hi, http://msdn.microsoft.com/library/de...electtopic.asp
Ken
---------------------
"KC" <yo*@dontneed.t his> wrote in message
news:ea******** *****@TK2MSFTNG P12.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
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******** *****@tk2msftng p13.phx.gbl... Ken, You can use either a DataView or DataTable.Selec t 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.Selec t
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.t his> wrote in message news:ea******** *****@TK2MSFTNG P12.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
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******** *******@tk2msft ngp13.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>>
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******** ******@TK2MSFTN GP12.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******** *******@tk2msft ngp13.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>>
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
Much Thanks!
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:O3******** *****@tk2msftng p13.phx.gbl... Ken, You can use either a DataView or DataTable.Selec t 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.Selec t
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.t his> wrote in message news:ea******** *****@TK2MSFTNG P12.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: rhat |
last post by:
I heard that beta 2 now makes ASP.NET xhtml compliant.
Can anyone shed some light on what this will change and it will break stuff
as converting HTML to XHTML pages DO break things. see,
http://www.alistapart.com/articles/betterliving/
I read on
http://msdn.microsoft.com/netframework/default.aspx?pull=/library/en-us/dnnetdep/html/netfxcompat.asp
It said they changed stuff like this
|
by: JS |
last post by:
I'm trying to create a data layer and having problems returning a DataSet
from my code that's in a class module.
Please forgive me. I'm new to C# (VB'er). I decided to create my data layer
in small steps. Right now, I'm just trying to attach a ComboBox to a dataset
that's in my class module. In the class, I call a Stored Procedure. I know
how to set up the connection, command, adapter, and dataset, what I'm having
a problem with is,...
|
by: JIM.H. |
last post by:
Hello,
Can I send a dataset as a parameter into stored procedure and import data to
a table in the stored procedure?
Thanks,
Jim.
|
by: MadCrazyNewbie |
last post by:
Hey Group,
Probably a Stupid question i know but, what is the difference between a
datagrid and Dataview?
Ta
MCN
|
by: Arne |
last post by:
How do I pass a dataset to a webservices? I need to submit a shoppingcart
from a pocket PC to a webservice.
What is the right datatype?
II have tried dataset as a datatype, but I can't get it to compile.
<WebMethod()> _
Public Function VerifySku(ByVal skus As XmlDataDocument) As DataSet
Test program :
Dim cartSet As DataSet
cartSet = ws.VerifySku(cartSet)
| |
by: Adam Smith |
last post by:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness
I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock,...
|
by: Brian |
last post by:
I am having a heck of a time trying to refresh data in a combobox. I have a
combo box that periodically needs to have its bound data refreshed. I can
refresh the data, but every time I refresh it the updated contents of my
data source is added to the combo and the existing list is not cleared.
I have tried calling Items.Clear() before the bind and this didn't work. It
told me I couldn't call it when .DataSource was set, so I set it to...
|
by: YYZ |
last post by:
I am using Data for the first time with VB.Net, and it's in an odd way,
so that makes it more strange.
I have created a dataset based on a simple SELECT * FROM Table WHERE
1=0 -- I do that because I don't want any rows returned, only the
structure of what a row would look like. Make sense?
The first thing I want to do is to add a row to the dataset so that I
can run a query against it. I know that sounds strange, but I really
do...
|
by: Tony K |
last post by:
I had a random thought today. Is it possible to make a complete application
with several forms that contain databound info such as textboxes or
dataGridViews and use 1 and only 1 dataset for the entire application?
I ask because, when I created my program, for each and every form that has
databound information, there is a dataset that is created.
Now, correct me if I'm wrong, but when a tableAdapter, or DataTable is
associated with...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |