1
Answer

Display SQL statement on aspx page for debugging with ado.net

Dan Mc

Dan Mc

17y
2.3k
1
Hello.
I have a sql statement which are using variables from form Data. I would like to output the sql query on the webpage for debugging.

objCmd = new SqlCommand("SELECT DISTINCT PROV_SPECIALTIES.LAST_NAME,  PROV_SPECIALTIES.PHYS_STATE, PROV_SPECIALTIES.ZIP, PROV_SPECIALTIES_FINAL.SPECIALTIES,  LEFT OUTER JOIN PROV_SPECIALTIES_FINAL ON PROV_SPECIALTIES.PROV_ID = PROV_SPECIALTIES_FINAL.PROV_ID WHERE (PROV_SPECIALTIES.ZIP LIKE '%' + @ZIP + '%') AND (PROV_SPECIALTIES.PHYS_STATE = @State) AND (PROV_SPECIALTIES.SPECIALTY IN (@SPECIALTYSELECTED))", objConn);
           
 objCmd.Parameters.Add("@ZIP" , txtSearch.Text);
 objCmd.Parameters.Add("@STATE", ddlState.SelectedItem.Value);
 objCmd.Parameters.Add("@SPECIALTYSELECTED", lbSpecialty.SelectedItem.Value);

I would like to do something like Response.Write(objCmd)
My hangup is I want to see if @SPECIALTYSELECTED are pulling the values from the listbox control and using them in the SQL statement.

Thanks.
Answers (1)