I have a SqlCommand object, and I execute its ExecuteNonQuery method. The query fails, but I can't see how to obtain the query to debug it. Could you help me?
Update I am currently using Wireshark (tcpdump) to read the command, but I think that its not the best solution
Update The CommandText property only provides the Stored Procedure...
When using a generic DbCommand to perform an update, it will hang indefinately if the row being updated is locked.
The underlying connection used is is Devart's Oracle provider, Devart.Data.Oracle.OracleConnection
Setting the DbCommand.CommandTimeOut has no effect at all, the update never times out.
DbCommand does not implement BeginE...
Dear GURUs
I am running Server Application on Windows Server 2008 with SQL Server 2008, Now My scenario is as Given.
I have implemented a custom Connection Pooling (why I did that its another long story). therefore I am not opening or closing connection on each request.
Server Application executes more than thousands DBCommand in a m...
So I have some code in a VB module. When I run this with the SQL statement having hard coded values in the where statement it works. I am now trying to add Parameters to the module so that the Form can except an Input from a user, but I am getting the message: Input string was not in a correct format.
Here is the section of code:
o...