I have this function to return a value of a field in a table, and works fine. If field is null returns a default value. However when I need access to this function several times then I get a timeout error. Because in practice it runs 2 times the query. I've tried some approximations to test if the value returned was null, but in some cases this validating not run as expected. How can I validate if value is null running the query only once.
Function GetField(ByVal xSqlstring As String, ByVal pDefault As Integer) As Integer
Dim conn As SqlConnection = New SqlConnection(CBD.ConnectionStringBD)
Dim Cmd As New SqlCommand(xSqlstring, conn)
If IsDBNull(Cmd.ExecuteScalar()) Then