Retrieving a Max value from a table and storing in VB.net
My SQL statement looks like this
select max(SEQ_NO) AS expr1 where fld1 = 'strFld1'. According to the data this should return a number from 01 to 99, or null. I can execute the query separate from the program and it works. I need to know how to return the single value to process it. I am used to returning the values to a dataset and placing in a grid. I have 2 problems: It is reurning a 0 or null that produces an error when I try to return it t to a dataset. 2nd. How may I best refer to just one value returned from the query?