473,480 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Dataset: How to Access specific column data?

When using a dataset, how can one get to a column data element using this
format:

dataset.Tables[0].Rows[0]....

I can get to a specific row, but I am not sure how to get to the column or
data. I tried using the keyword Column, but no luck.

Also, is direct access the best way to access this data, or should I be
using different DataRows, etc. Keywords

Thanks

Nov 15 '05 #1
3 21685
David,
Use .Columns[xx] where xx is either a number or a string with the field
name. You can also use a name for the Table index.
Ron Allen
"David M" <ma*****@aegiscomgroup.com> wrote in message
news:Xn**********************************@207.46.2 48.16...
When using a dataset, how can one get to a column data element using this
format:

dataset.Tables[0].Rows[0]....

I can get to a specific row, but I am not sure how to get to the column or
data. I tried using the keyword Column, but no luck.

Also, is direct access the best way to access this data, or should I be
using different DataRows, etc. Keywords

Thanks

Nov 15 '05 #2
Try this:
ds.Tables[0].Rows[0][0]

--
Greetz,
Jan
__________________________________
Read my weblog: http://weblogs.asp.net/jan
"David M" <ma*****@aegiscomgroup.com> schreef in bericht
news:Xn**********************************@207.46.2 48.16...
When using a dataset, how can one get to a column data element using this
format:

dataset.Tables[0].Rows[0]....

I can get to a specific row, but I am not sure how to get to the column or
data. I tried using the keyword Column, but no luck.

Also, is direct access the best way to access this data, or should I be
using different DataRows, etc. Keywords

Thanks

Nov 15 '05 #3
Oops,
Ignore the Columns in the previous and use just [xx] where xx is either
a string or integer key. I've been working with a custom control with a
Columns collection for about the last 2 days and my mind was 'stuck' on
columns.
Ron Allen
"Ron Allen" <rallen@_nospam_src-us.com> wrote in message
news:ef**************@TK2MSFTNGP09.phx.gbl...
David,
Use .Columns[xx] where xx is either a number or a string with the field
name. You can also use a name for the Table index.
Ron Allen
"David M" <ma*****@aegiscomgroup.com> wrote in message
news:Xn**********************************@207.46.2 48.16...
When using a dataset, how can one get to a column data element using this format:

dataset.Tables[0].Rows[0]....

I can get to a specific row, but I am not sure how to get to the column or data. I tried using the keyword Column, but no luck.

Also, is direct access the best way to access this data, or should I be
using different DataRows, etc. Keywords

Thanks


Nov 15 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
309
by: Alex | last post by:
I have a dataset bound datagrid. I added my own columns (autogenerate=false). However I can't figure out how to display a hyperlink string coming from the DB as a functioning hyperlink. What can...
1
1663
by: scottin | last post by:
I setup the dataset, which is the datasource for a datagrid. When I originally fill the dataset, the data is loaded into dataset.tables(0). (dataset.tables(0).rows.count = 8) Then, if a row...
0
1381
by: Randall Arnold | last post by:
I have a Microsoft Access report (built on a SQL Server 2000 query) I have exported as xml/html. I include a stylesheet in the original export for formatting of the report. The schema is...
0
1511
by: Leeor Chernov | last post by:
Hi , I am using the method: DSSap.ReadXml( XmlPath,XmlReadMode.InferSchema ); And as I expected I get an error when the xml does not matching my DataSet that contains already a schema , The...
3
6032
by: Steve Teeples | last post by:
Can someone tell me how to access the "nested child" data of a specific parent from within a dataset? I read an XML file into a dataset with its schema and want to access the child nested data. ...
0
1296
by: Problematic coder | last post by:
Hi, I have just been asked to create an app that will import a specific column from an excel spreadsheet, something like sheet1 columnD or a column with the first row with a value of 'ID'...
6
14137
convexcube
by: convexcube | last post by:
After searching the web for a solution to total a specific column in a list box and not finding it, I came up with this: Dim varTotal As Currency Dim varRow As Integer For varRow = 1 To...
7
26362
by: cesco | last post by:
Hi, I have a file containing four columns of data separated by tabs (\t) and I'd like to read a specific column from it (say the third). Is there any simple way to do this in Python? I've...
0
968
by: Eric Val | last post by:
How i insert to an arrayList a specific column (pg. the ("PhoneNumber")field who has 30 records) from a dataSet C#.
0
7032
Oralloy
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,...
0
7076
jinu1996
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...
0
5321
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4767
isladogs
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...
0
4471
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2976
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1294
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 ...
1
558
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
174
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.