full blown SQL command

[Adam Clark]

I ask this question before but maybe I didn't work it correctly. What I want
to do is run a full blown sql statement against a dataset (ADO.NET). How do
I do this

(for example, running the INSERT .... INTO statement).

Thanks

Adam

[Jeff Johnson [MVP: VB]]

"Adam Clark" <ad********@lhpsoftware.com> wrote in message
news:eS**************@TK2MSFTNGP11.phx.gbl...

I ask this question before but maybe I didn't work it correctly. What I want to do is run a full blown sql statement against a dataset (ADO.NET). How do I do this

(for example, running the INSERT .... INTO statement).

You can't run SQL against a DataSet. You must manipulate the rows
one-by-one.

[Greg Burns]

the short answer is you cannot

ADO.NET does not have query processor

However, MS has written some helper classes they may do some of what you
need

http://support.microsoft.com/default...en-us;325683#3

The link to all available helper class seems to be broken.

try searching MSDN for "DataSetHelper", that should bring up the gamut.

HTH,
Greg

"Adam Clark" <ad********@lhpsoftware.com> wrote in message
news:eS**************@TK2MSFTNGP11.phx.gbl...

I ask this question before but maybe I didn't work it correctly. What I want to do is run a full blown sql statement against a dataset (ADO.NET). How do I do this

(for example, running the INSERT .... INTO statement).

Thanks

Adam

[Hal Rosser]

use the oledbconnection object and dataadapter

"Adam Clark" <ad********@lhpsoftware.com> wrote in message
news:eS**************@TK2MSFTNGP11.phx.gbl...

I ask this question before but maybe I didn't work it correctly. What I want to do is run a full blown sql statement against a dataset (ADO.NET). How do I do this

(for example, running the INSERT .... INTO statement).

Thanks

Adam

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 7/30/2004