Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing stored procedures into Excel with parameters | Excel Programming | |||
Can I import SQL Stored Procedures into Excel? | Excel Discussion (Misc queries) | |||
How to connect Excel to stored procedures in SQL database? | Excel Discussion (Misc queries) | |||
Call SQL Server Stored Procedures with parameters, | Excel Programming | |||
Running sql stored procedures from Excel | Excel Discussion (Misc queries) |