|
 |
aspx thread: iterate through DATASET with asp.net??
Message #1 by "Yu, Kevin" <kyu@N...> on Tue, 9 Oct 2001 14:11:15 -0400
|
|
does anybody know how to iterate throgh a dataset object with asp.net?
I have a oledbconnection to ODBC and retrieve data from the Oracle server
hosted on
a remote server. after filling the dataset, I want to output the one by one
to
the client.
any link to useful info is appreciated.
Kevin Yu
system.data.oledb
coop student
Western Research Center - Natural Resource Canada
email: kyu@n...
phone:(780) 987-8611
Message #2 by Richard Huang <rhuang@l...> on Tue, 9 Oct 2001 11:24:57 -0700
|
|
just loop the recordset.
Richard
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 09, 2001 11:11 AM
To: ASP+
Subject: [aspx] iterate through DATASET with asp.net??
does anybody know how to iterate throgh a dataset object with asp.net?
I have a oledbconnection to ODBC and retrieve data from the Oracle server
hosted on
a remote server. after filling the dataset, I want to output the one by one
to
the client.
any link to useful info is appreciated.
Kevin Yu
Message #3 by "Michael A. Michalski" <mmcihalski@n...> on Tue, 9 Oct 2001 14:35:53 -0400
|
|
For Each Whatever in objDataSet.Tables("Whatever").Rows
do something....
Next
Michael
----- Original Message -----
From: "Yu, Kevin" <kyu@N...>
To: "ASP+" <aspx@p...>
Sent: Tuesday, October 09, 2001 2:11 PM
Subject: [aspx] iterate through DATASET with asp.net??
> does anybody know how to iterate throgh a dataset object with asp.net?
>
>
> I have a oledbconnection to ODBC and retrieve data from the Oracle server
> hosted on
> a remote server. after filling the dataset, I want to output the one by
one
> to
> the client.
>
> any link to useful info is appreciated.
>
>
> Kevin Yu
Message #4 by Todd Carrico <ToddC@m...> on Tue, 9 Oct 2001 13:50:26 -0500
|
|
The DataSet is made up of DataRows. These DataRows can be iterated through
similar to a recordset, or more importantly like objects in a collection,
which is exactly what it is.
Dim Ds As DataSet
Dim Dr As DataRow
'// Get the DataSet from somewhere
For Each Dr In Ds.Tables(0).Rows
Dr.Item("ColumnName")
Next
hth
tc
-----Original Message-----
From: Yu, Kevin [mailto:kyu@N...]
Sent: Tuesday, October 09, 2001 1:11 PM
To: ASP+
Subject: [aspx] iterate through DATASET with asp.net??
does anybody know how to iterate throgh a dataset object with asp.net?
I have a oledbconnection to ODBC and retrieve data from the Oracle server
hosted on
a remote server. after filling the dataset, I want to output the one by one
to
the client.
any link to useful info is appreciated.
Kevin Yu
|
|
|
View Cart
