ADO code project notes

You can format your SQL directly and execute it. Here is a simple code snippet.

       objDB.Open()
       sSQL = "Update member set firstname='def' where membernumber=209"
       objDB.objCmd.Connection = objDB.objConn
       objDB.objCmd.CommandText = sSQL
       objDB.objCmd.ExecuteNonQuery()
       objDB.Close()