Retrieving a single value from a dataset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkAurit - 05 Apr 2006 01:22 GMT

Im using a data access layer that pulls everything back as a dataset. They
arent exposing the scalar return.
The dataset is populated with a single value from a database, the max() of
a date.
How is the fastest way to get a single value from a dataset consisting only
of that value?
Thanks, Mark

Reply to this Message

Jim Hughes - 05 Apr 2006 01:33 GMT

dim dt as DateTime = ctype(ds.Tables(0).Rows(0).Item(0), DateTime)
or
DateTime dt = (DateTime) ds.Tables(0).Rows(0).Item(0);

> Im using a data access layer that pulls everything back as a dataset.
> They
[quoted text clipped - 6 lines]
> of that value?
> Thanks, Mark

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...