On Tue, 28 Oct 2003 16:01:53 -0500, "A.M" <IH*******@sapm123.com> wrote:
¤ Hi,
¤
¤ Using ADO.NET,
¤ How can i execute action queries already saved inside an MDB file ?
¤ I already know that i can run sql commands like UPDATE and INSERT, but how
¤ can i run those ones already has been saved in the MDB file as a action
¤ queries ?
¤
Here is an example:
Dim AccessConn As System.Data.OleDb.OleDbConnection
Dim AccessCommand As System.Data.OleDb.OleDbCommand
Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db1.mdb;"
AccessConn = New System.Data.OleDb.OleDbConnection(ConnectionString )
AccessConn.Open()
AccessCommand = New System.Data.OleDb.OleDbCommand("AccessQueryDefName ", AccessConn)
AccessCommand.CommandType = CommandType.StoredProcedure
AccessCommand.ExecuteNonQuery
AccessConn.Close()
Paul ~~~
pc******@ameritech.net
Microsoft MVP (Visual Basic)