How to retrieve a column value in a Typed dataset

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 ?


anwarmirAsked:
Who is Participating?
 
af4643Commented:
normally, you access the row by it's index:

[tablename].Rows(i)

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


0
 
jesusafloresCommented:

you declare

dim x as new OrderDataSet.OrderDetailPaymentTermsDataTable ' declare x how table of dataset OrderDataSet
now:
x=Me.CurrentOrderDS.OrderDetailPaymentTerms

now can uses
ordernumber  = X.Iordernumber
0
 
anwarmirAuthor Commented:
How can you access a specific row for example row 6 without doing a loop ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.