Timeout Expire on INSERT Query
- by Sachin Gaur
I am trying to insert a row in a table using simple INSERT Query in a transaction. It works fine in SQL Server but I am not able to insert the data using my business object.
I am calling a SELECT query using the Command as:
Using cm As New SqlCommand
With cm
.Connection = tr.Connection
.Transaction = tr
.CommandType = CommandType.Text
.CommandText = Some Select Query
.ExecuteScalar()
'' Do something
.CommandText = Insert Query
.ExecuteNonQuery()
End With
End Using
I am getting the Timeout period expired error at ".ExecuteNonQuery()" line.
Any other DML query is running perfectly fine at this point.
Can anyone tell me the reason?
