How to trace the Insert Query of Sql Data Source ?

[Luqman]

I have created a Insert Query in Sql Data Source using Oracle Database, with
the parameters, and its connected with DetailView Control.

When I try to Insert through DetailView Control, Illegal Variable
Name/Number Error occurs.

Is there any way I can trace or display on screen, what exactly the query is
being passed to the Oracle with the Values.

For example: If my Sql datasource has following query.

Insert into mytable(invoice_no,inv_date,item_no,qty)
valuesinvoice_no,:inv_date,:item_no,:qty)

I need the query with the parameter values as under:-

Insert into mytable(invoice_no,inv_date,item_no,qty)
values(1241,'23-jun-2006',12,1200)

How can I trace and display the above query with the parameter values ?

I am using VS 2005.

Best Regards,

Luqman

 

[Eliyahu Goldin]

Parameters are processed by the database driver. I don't think you can see
the actual sql at any point prior the driver gets the statement.

Don't know much about Oracle tracing tools but there should be some, use
them.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net