running sql against a table

[Rod]

I would like to be able to do the equivalent of the Access command

DoCmd.RunSQL mySQLstring

on tables I have in my dotnet application.

The particular case I have in mind is updating one table using data from the
other.
Is this possible and if so how??

many thanks in advance

Rod

[Mary Chipman [MSFT]]

No, there is no exact equivalent in ADO.NET. You can execute a
command, or use a DataAdapter to modify data from your client
application to a data source. For more information, see "Performing
Database Operations and Modifying Data" in the VS.NET help.

--Mary

On Thu, 16 Jun 2005 16:24:38 +0100, "Rod" <Ro**********@Hotmail.com>
wrote:

I would like to be able to do the equivalent of the Access command

DoCmd.RunSQL mySQLstring

on tables I have in my dotnet application.

The particular case I have in mind is updating one table using data from the
other.
Is this possible and if so how??

many thanks in advance

Rod