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]]

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.aspx?scid=kb;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

 

[Hal Rosser]

use the oledbconnection object and dataadapter

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