0
Answer

Compare db parameters to application parmeters

jim mcfadden

jim mcfadden

12y
1k
1

With the code below I want to compare database parameters to the debug window

Protected Sub sqlDataSource1(ByVal sender As Object, ByVal e As System.SqlDataSourceCommandEventArgs) Handles button2.Load
        Using reader As System.Data.SqlClient.SqlDataReader = cmd.ExecuteReader
                For x As Integer = 0 To e.Command.Parameters.Count – 1
                Trace.Write(e.Command.Parameters(x).ParameterName)
                Trace.Write(e.Command.Parameters(x).Value)
            Next
    End Sub


with large amount of fields and a stored procedures  my project is hard to debug