I'm developing my basic ASP.NET web app into a rich silverlight UI interface to make use of the silverlight controls and media element.
Currently I use ASP.NET aspx pages to handle everything, with only the charting using silverlight. (Visifire)
I've now started to recreate the pages using the Business Application Template in VS2010. I'm looking to have all pages in the Silverlight app, with the ASP.NET web project handling the data access layer and returning the data back to the silverlight app, to produce the charts and reports.
So, the thing I don't understand is how to pass parameters from the silverlight UI, to the stored procedures I use to return the charting/report data, and return the dataset/datatable to the silverlight app.
The Silverlight UI currently consists of:
> a ComboBox where the user can select the Meter. The selectedvalue of this has to be passed to the Stored procedure.
> a Calendar where the user can select the day. This also needs to be passed to the stored procedure
The class in the Web app does the work of executing stored procedure and returning the data to a datatable, but how can I get that datatable into my silverlight app??
I'm basically stuck on how to pass parameters to the web app, process the SP and return the datatable to the silverlight app. I'm sure I'm missing something simple.