2 SQL Queries in 1 OLEDBCommand Object

[Guest]

Hi.
Is it possible to embed two sql queries ( or statements, whatever ) in just
one OLEDBCommand object, and execute them at the same time?

Dim t_cmd as new OLEDBCommand
t_cmd.CommandText="SELECT * FROM Sales;DROP TABLE Sales;"
..
..
..
t_adapter.Execute (t_cmd)

Will this code work?

 

[Miha Markic [MVP C#]]

Hi,

I believe this feature depends on provider...

 

[Guest]

The provider is OLEDB Jet 4.0 that will connect to a MDB file.

Hi,

I believe this feature depends on provider...

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi.
Is it possible to embed two sql queries ( or statements, whatever ) in
just
one OLEDBCommand object, and execute them at the same time?

Dim t_cmd as new OLEDBCommand
t_cmd.CommandText="SELECT * FROM Sales;DROP TABLE Sales;"
.
.
.
t_adapter.Execute (t_cmd)

Will this code work?

 

[Guest]

Mohammad-Reza,

It is not possible with that provider.

Kerry Moorman

The provider is OLEDB Jet 4.0 that will connect to a MDB file.

Hi,

I believe this feature depends on provider...

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi.
Is it possible to embed two sql queries ( or statements, whatever ) in
just
one OLEDBCommand object, and execute them at the same time?

Dim t_cmd as new OLEDBCommand
t_cmd.CommandText="SELECT * FROM Sales;DROP TABLE Sales;"
.
.
.
t_adapter.Execute (t_cmd)

Will this code work?