How can i see the Sql statement in the sqlcommand ?

  • Thread starter Thread starter WIN
  • Start date Start date
W

WIN

My code

Dim sqlcommand As SqlClient.SqlCommand = New SqlClient.SqlCommand
sqlcommand.CommandText = "insert into Supplier( ADDR1 ) values ( @ADDR1 )"
sqlcommand.Parameters.Add("@ADDR1", supplierobj.getADDR1)

how can i see the sql statement execute in runtime for testing ?
 
thx u man

William (Bill) Vaughn said:
You can turn on the Profiler. It will show you precisely what ADO.NET is
passing to the server.

hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
 
Back
Top