How to retrieve a column value in a Typed dataset

Posted on 2006-04-12
Last Modified: 2010-04-23
A typed dataset datatable has been declared as follows

  Dim x As OrderDataSet.OrderDetailPaymentTermsDataTable = Me.CurrentOrderDS.OrderDetailPaymentTerms

But how do i retrieve column values for the typed dataset

i am using the following syntax:

  ordernumber  = X.Iordernumber

But that just gives me the column name.

Can Anybody help ?

Question by:anwarmir
    LVL 1

    Assisted Solution


    you declare

    dim x as new OrderDataSet.OrderDetailPaymentTermsDataTable ' declare x how table of dataset OrderDataSet

    now can uses
    ordernumber  = X.Iordernumber

    Author Comment

    How can you access a specific row for example row 6 without doing a loop ?
    LVL 2

    Accepted Solution

    normally, you access the row by it's index:


    [tablename].Rows(i).Item([columnname]) 'gives you the value of that column at that row index


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    733 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

    22 Experts available now in Live!

    Get 1:1 Help Now