Re: Trace Access Database Activity

Write a class that registers for DataAdapter.RowUpdating:

using System.Diagnostics;

myDataAdapter.RowUpdate +=
              new OleDbRowUpdatingEventHandler(OnRowUpdating);

public void OnRowUpdating(object sender,
                          OleDbRowUpdatingEventArgs args)
{
  Trace.WriteLine("Command: " + args.Command.CommandText);
}

Thanks,

Shawn Wildermuth
[email protected]

> -----Original Message-----
> From: The DOTNET list will be retired 7/1/02
> [mailto:[email protected]] On Behalf Of Avi Nahir
> Sent: Wednesday, June 26, 2002 12:33 PM
> To: [email protected]
> Subject: [DOTNET] Trace Access Database Activity
>
>
> Hi all,
>
> I'm using ADO.Net to access an MS-Access database.
> How can I trace what's going on? What queries are sent to the
> database?
>
> You can read messages from the DOTNET archive, unsubscribe
> from DOTNET, or subscribe to other DevelopMentor lists at
> http://discuss.develop.com.
>

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.