View SQL Stmt Before Execution in ADO.NET?

[Daryll Shatz]

Is there any way to output the completely populated SQL statement that is
about to be executed in ADO.NET? My SQL statements can contain and error
and I woulds like to debug them. Example:
Dim sqlSelect As String = "INSERT INTO Table(col1, col2) VALUES (@col1Value,
@col2Value)

Dim cmdTable As New SqlCommand(sqlSelect, cs)

....

cmdTerritory.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@col1Value", ...))

cmdTerritory.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@col2Value", ...))

' Debug Breakpoint Here

' IS THERE A WAY VIEW THE COMPLETE SQL STATEMENT TO BE EXECUTED???

cmdTerritory.ExecuteNonQuery()

 

[Mary Chipman]

Have you tried building another string variable in tandem with your
command object?

-- Mary
MCW Technologies
http://www.mcwtech.com