Help constructing an Update query using the DataAdapter

[nagar@community.nospam]

I'm using SQLite with the ADO.NET 2.0 SQLite Data Provider as the
storage of my application.
I chose to use an untyped dataset and I'm using a dataadapter to
report changes to the DB.

The query generated by the commands builder doesn't work propertly (I
often get a DBConcurrency exception). Therefore I'm created my own
update query but I'm still getting errors everytime the query is
generated.

Is there a way to actually see the resulting query (after parameters
have been inserted) before it is sent to the DB? This way I'd be able
to detect any errors in setting up the parameters.

Thanks.
Andrea