Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Using a dataset in a conditional statement

Is this possible?  For example, I have a dataset that grabs data from a OBDC connection using a SQL query.  Is there a way to use the dataset to in a IF statement?  If so what is the syntax?  If not, then how would I go about using data from a data source in a conditional statement?  

Sorry if this is a novice question, I am a novice VB user afterall.  I browsed around and couldn't quite find a solution.  Thanks!  

0
vangmoua
Asked:
vangmoua
  • 2
  • 2
1 Solution
 
vangmouaAuthor Commented:
Oh yeah, as you might guess, the dataset contains multiple fields and I need to compare one of those fields in the conditional statement.  
0
 
Jeff CertainCommented:
Please explain the question a little better...

Once you get the populate the datset, you can easily compare the value of one of the fields...

dataset.Tables(0).Rows(i).Item("fieldName") will give you the entry in <fieldname> for the ith row. You can also iterate through these, use the dataview object's rowfilter method to filter a table, etc.
0
 
Jeff CertainCommented:
oh yeah...

if integer.parse(dataset.Tables(0).Rows(i).Item("fieldName")) > value then

end if

will cast the entry in the field to an integer (similar syntax for dates, single, etc) and do the comparison
0
 
vangmouaAuthor Commented:
Thanks!  That's exactly what I was looking for.  I couldn't find that syntax.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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