How to read Row value after using Select method for datatable

Posted on 2004-11-17
Last Modified: 2008-02-26

I am using a select method on a datatable to find a certain row. I am finding the  datarow using the following code. This works fine

Dim SiteCurrencyDescriptionRow() As DataRow

            SiteCurrencyDescriptionRow = dtCurrency.Select("chCurrencyCd =" & "'" & CType(dtSiteCurrencyCode.Rows(1)("chCurrencyCd"), String) & "'")

How do I access the 1st coloumn value of the sitecurrencydescriptiondatarow.

I am doing something like this but it dont work.
txtsitecurrency.text =  ctype(SiteCurrencyDescriptionRow.getvalue(0), string)

where am i going wr

Question by:anwarmir
    LVL 25

    Expert Comment

    txtsitecurrency.text =  SiteCurrencyDescriptionRow.item(0)

    Author Comment

    Hi I cant use Item as there is an error

    "Item is not a member of system array"
    LVL 25

    Accepted Solution

    A sorry ,

    txtsitecurrency.text =  SiteCurrencyDescriptionRow(0).item(0)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
    1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now