Solved

How do I access my DataSet's datarow elements by name?

Posted on 2014-04-02
1
269 Views
Last Modified: 2014-05-23
If I have a table within my DataSet and I need to access an item within one of the rows of my table, by the column name, how do i do this? the following does not work.

dsIH.Tables[0].Rows[j].ItemArray("INVOICE_ID").ToString(),
0
Comment
Question by:mikesExpertExchange
1 Comment
 
LVL 5

Accepted Solution

by:
Steve Dubyo earned 500 total points
ID: 39973686
Hi,

This should do it..

dsIH.Tables[0].Rows[j]["INVOICE_ID"],

EDIT: Of course you can add ToString at the end of that if you need to return a string..

dsIH.Tables[0].Rows[j]["INVOICE_ID"].ToString(),
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now