Thank you all for your help. I am saving your responses for
future use.
After trying a few of the simplest solutions, I have settled
on the
simplest, because it seems to also be the fastest in my
situation. I am
using the ODBCConnection and ODBCDataReader objects and
getting what I need
with only 10 lines of code. That includes 2 queries to
different tables,
the first being a cross-reference table. AWESOME!
I tried again to run a query to get the small subset of data
I am interested
in into a local object (like the dataset), but was
unsuccessful. I am
convinced that this was not a problem with .Net or my code,
but rather with
the way the mainframe flatfiles are set up, with their
timeout.
Thanks again for your help, and I hope I can return the
favor sometime.
Kelly
===================================
This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
|