Develop a UI that connects to a MS SQL database and grabs the data from a Store Procedure. The UI will display the DATA in a JQGrid or similar.
Functionalities of the UI.
Data on the UI need to be able to exported to Excel, CSV, and PDF when users clicks a button.
Sorting option on the grid needs to work.
Few of the columns on the grid will have a drop down options and based on the selection from the drop down; the data will refresh and show the updated data based on the selected option form the drop down.
You can use a dummy data from the backend and the store procedure can just return dummy data, you do not have to worry about the store procedure. You can just create a dummy store procedure that will return the record-set for now that would be displayed on the UI.
This project does not require you to work on the Store procedure, for now as long as you pass the parameters to the store procedure and the store procedure can just return the record set in a simple select statement without doing any work, so that the UI interacts with the store procedure.
I’ll hook up the UI to my own store procedure later on.