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 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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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...
|
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...
|
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. ...
| |
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'...
|
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...
|
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...
|
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#.
|
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,...
|
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...
| |
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
|
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...
| |