jim mcfadden

jim mcfadden

  • 1.7k
  • 5
  • 1.3k

Compare db parameters to application parmeters

Oct 24 2012 4:49 AM

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