Database access without using a dataset

Kelly--

It seems by the wording of the question that you're
misunderstanding
what a dataset is, since it will do pretty much exactly what
you're
trying to do.

If I'm misunderstanding and you don't want any data back,
you can use
SqlCommand.ExecuteNonQuery.

--Jekke

-----Original Message-----
On 6/20/06, Kelly Baker <kbakerhoward-ind.com> wrote:
> I need to access an ODBC database (Connx), running a
single query at a
time.
> I DO NOT want to set up or fill a dataset because of
the immense size
of
> this database.  How do I set up a database connection
in .Net 2.0 so I
can
> open a connection, run a query on the database, and
close the
connection,
> retrieving only the data I am querying for?  Every time
I try to use
the
> Data Source Wizard, it tries to set up a dataset.
>
> Thanks,
> Kelly
>
> ===================================
> This list is hosted by DevelopMentor(r)  http://www.develop.com
>
> View archives and manage your subscription(s) at
http://discuss.develop.com

>


--
Thank You,

Kent Tegels
Database Curriculum Lead
Blog: http://staff.develop
.com/ktegels
DevelopMentor -- Advanced Training for Professional Software
Developers

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com

View archives and manage your subscription(s) at
http://discuss.develop.com


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com