Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

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 ?


0
anwarmir
Asked:
anwarmir
2 Solutions
 
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
 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now