How can i see the Sql statement in the sqlcommand ?

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 ?
 
W

WIN

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Commands SQL Server 2
Split data in field on character return 0
SqlException after Adapter.Update: how to determine the source columnand parameter involved? 3
SQL CONTAINS clause parameter substitution problem 3
How to create address lable from excel data 1
A severe error occurred on the current command when running stored 3
Importing Active Directory Data into Access 2007 3
Access Table Update from Active Directory 1

Top