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