output my sql query to the web page for debug / testing

hello,

i have a sql query that takes i want to pass values from form field inputs (Session, MachineName, JobType). If i hard code the values in the query it works fine, its just not displaying anything when i try ti read in from the form fields.

in php ive been able to print the sql query with all the variables, etc. to the screen to verify im getting the correct data. how would i go about doing this in asp.net?

Thanks


example query below


select * from TableName
 
WHERE     
(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE '%' + ? + '%') 
AND (dbo.tbl_Datasheet_Users_DataSet.Session = ?) 
AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE '%' + ? + '%') 
AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = 'Advanced')
 
ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC">
 
 
        
        </script>
    
        <SelectParameters>
        <asp:ControlParameter ControlID="MachineName" Name="Machine_Name" 
            PropertyName="Text" Type="String" />
        <asp:ControlParameter ControlID="Position" Name="Position" PropertyName="Text" 
            Type="String" />
        <asp:ControlParameter ControlID="SessionTime" Name="Session" 
            PropertyName="Text" Type="String" />
    </SelectParameters>

Open in new window

nriddockAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ahllConnect With a Mentor Commented:
What happened with that code?...Did it work? You might to play with the quotes too.
Could you paste the whole DataSourde code?...It would help a lot.

If you are using a SQLDataSource I dont know how to see the whole query with the parameters already included.
0
 
ahllCommented:
Hi...I'm a little confused. Your code is not complete.

Anyway..if thats is the exacu query you are using, you have to especify the paramneters in there. it should look like this:

select * from TableName
 
WHERE     
(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE '%' + @MachineName+ '%') 
AND (dbo.tbl_Datasheet_Users_DataSet.Session = @Session) 
AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE '%' + @Position + '%') 
AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = 'Advanced')
 
ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC

Open in new window

0
 
nriddockAuthor Commented:
i appreciate the updated code...do you know of a way to output the sql query as its executed so i can debug/test.

ie:

<pseduocode>

echo "$sqlQuery;"
</pseudocode>

Would output on the screen

select * from TableName WHERE    
(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE NY107A100)
AND (dbo.tbl_Datasheet_Users_DataSet.Session = AM)
AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE Manager)
AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = Advanced)
 
ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC
0
All Courses

From novice to tech pro — start learning today.