How to take cell data on click and place into sql parameter?

How to take cell data on click and place into sql parameter?

pcal90pcal90 Posts: 1Questions: 1Answers: 0

In the image above, you'll see screenshots of my current project. I am trying to dynamically fill the parameter of the stored SQL procedure when you click on the table cell under Product column. This brings user to new table with historical orders of that specific item.
The image shows, for the most part, what I have done so far. I have got it working where you manually enter the parameter in the back end but I'd love for user to be able to click on a product and then see the historical orders for that product.

Any help would be appreciated!

Answers

  • kthorngrenkthorngren Posts: 8,931Questions: 25Answers: 2,040

    This example shows how to get the row data of the clicked row. Once you get the data you can use jQuery Ajax to send the information to the sever script. In the success function of the Ajax request you can build a new table ro whatever you need to display the response data. Let us inkow if you have specific questions about this process.

    Kevin

Sign In or Register to comment.