running sql against a table

  • Thread starter Thread starter Rod
  • Start date Start date
R

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acNewRecord Custom MsgBox 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update fields using SQL 5
VBA - retrieve data on last create named range from previous inserted named range 0
Deleting records in a linked table 3
DELETE FROM a table WHERE... 1
Running a saved query - hidden 1
Help With Syntax 2

Back
Top