PC Review


Reply
Thread Tools Rate Thread

dataset basic navigation

 
 
jherl
Guest
Posts: n/a
 
      25th Oct 2004
Hi, Please forgive me for the simplicity of the question, and the
redundancy. I have searched the forum and believe my answer is out
there amongst the multiple dataset question/responses, but I am such
a newbie that I am having trouble putting together the information I
need...Ok, enough, here's what I am trying to do:

I am making a call to a third party API that returns a dataset. I need
find out if there are any rows returned, and if so pull out the data
from a couple of the columns...

More specifically, I get the dataset. Each row contains many columns,
the three I need to get are BuySell, ControlValue, and Price.

Can someone toss out to me the simple code for traversing through the
dataset and pulling out the values from these columns.

Many Thanks -
Jennifer

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
Reply With Quote
 
 
 
 
jjardine
Guest
Posts: n/a
 
      26th Oct 2004

"jherl" <(E-Mail Removed)> wrote in message
news:417d8447$(E-Mail Removed)...
> Hi, Please forgive me for the simplicity of the question, and the
> redundancy. I have searched the forum and believe my answer is out
> there amongst the multiple dataset question/responses, but I am such
> a newbie that I am having trouble putting together the information I
> need...Ok, enough, here's what I am trying to do:
>
> I am making a call to a third party API that returns a dataset. I need
> find out if there are any rows returned, and if so pull out the data
> from a couple of the columns...
>
> More specifically, I get the dataset. Each row contains many columns,
> the three I need to get are BuySell, ControlValue, and Price.
>
> Can someone toss out to me the simple code for traversing through the
> dataset and pulling out the values from these columns.
>
> Many Thanks -
> Jennifer
>
> *-----------------------*
> Posted at:
> www.GroupSrv.com
> *-----------------------*


If you have a dataset here is some sample code to get data from it..

Assuming your dataset is named "ds"

'Get the number of Rows in the table
ds.Tables("TABLE_NAME").Rows.Count

'Enumerate through the rows in a data Table
Dim dr as DataRow

For Each dr in ds.Tables("TABLE_NAME").Rows
dr("COLUMN_NAME1 or INDEX").ToString()
dr("COLUMN_NAME2 or INDEX").ToString()
Next


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic navigation question Samuel Shulman Microsoft ASP .NET 1 22nd Oct 2006 08:25 PM
Typed DataSet Navigation (Multiple Tables) rryerson@devore.com Microsoft ADO .NET 7 13th Jun 2006 06:07 PM
Strongly Typed Dataset (1.1) and DataRelation for Navigation Only emarvets@gmail.com Microsoft ADO .NET 2 3rd Mar 2006 07:40 PM
Question on Dataset navigation vb.net Newbie Microsoft VB .NET 4 18th Jan 2006 03:12 PM
WebApplication - DataSet Navigation HickUp Martin Microsoft ASP .NET 2 10th Jan 2004 02:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:56 AM.