VSTO - Excel Stored Procedures With Parameters
 

Hi there,

I thought using VSTO would be a bit of an easy woohoo there its done for
you, but no.

I've been watching some of the online tutorials to get my head around how to
set up datasets, and for the most its straight forward until you get to
stored procedures.

What I was trying to do is
1) create an action pane Where a user can select a value from a list of
values (populated by the database) and press a button to refresh the main
dataset
I've created the action pane woohoo!
problem: It doesn't display any items , or labels when it loads

2)using the value obtained from the drop down
execute the stored procedure to return the required data

Im really confused here as I expected a dataset , where I could drag it onto
the worksheet

according to the video's I've seen when you create a datasource you get all
the columns that you can drag...but I get nothing :(

3)refresh all the pviot tables

any links to videos or tutorials or any assistance would be greatly
appreciated