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