problem using wizards with the stored procedure in VSTO

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - ISV
  - Windows Forms
  - Smart Device
  - SQL Server
  - VS 2008
  - Game
  - Windows Live
  - VB
  - IE
  - VFP
  - Visual Studio
  - Dotnet
  - VC++
  - Architecture
  - SharePoint
  - VS Express
  - Visual C#
  - Office
  - Windows Vista

- Previous
- Next
  - 1
    - Outlook Add-In - No permission to execute assembly Make sure that the controls you added to the toolbar are not created local. Cause when you create the controls in a procedure the gc removes the references to the controls and their eventlisteners when you exit the function. Create the controls as class variables or add them to an arraylist for example. .edit. Oops. sorry, I must read more carefully. :$ Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 2
    - New Deployment Article for VSTO2005 SE great work. Thanks. But is there any way by which we can create single setup file (which have all prerequisites included in it), because whenever we select bootstraps for prerequisites an extra Setup.exe is also created. And if we select "Download prerequisites from the same location as my location" then for prerequisites one more folder is created. Such kind of scenarios are not suitable for download from website, as we cant tell clients to download all files one by one (or in a zip file). Regards Sid Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 3
    - When will the VSTO support create managed code solutions for word2007? Hi Alvin You can currently create a VSTO document-level solution for Word 2003, then use it in Word 2007. "Native" Word 2007 document-level solutions won't be available until Orcas (the next version of Visual Studio) is released. There is currently no projected release date... One would hope, it would be during the current year. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 4
    - Closing Outlook - Setup Project Idea: create a small exe file that checks for a running outlook process - and if so return a value other then 0. Call this exe as custom action or as a prerequisite package from your MSI file. Hope this helps, greets, Helmut Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 5
    - VSTO over VBA Hello Muralidhar, From my point of view the most benefit is: - you have full access to the .Net Framework - you can use a more powerfull programming language - you can hide the code in a dll - you can have a Server Document - you can have Custom Task Panes - you can have Custom Action Panes The Excel Object Modell is still the same. Hope this helps, greets - Helmut Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 6
    - How to get the first line in a word document If you're prompting the user, do you display Word's built-in File SaveAs dialog box Since Word 2000 (I think it was) Word will display the first line as the proposed file name of a new file without your needing to do any extra work... If you do need to get that first line, I need a bit more information. Do you really mean the first line, or the first paragraph (A paragraph is generated by pressing Enter; it's ANSI character 13 (a carriage return).) Picking up the first paragraph is simple: TheDocument.Paragraphs(1).Range.Text Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 7
    - XML Tags in VSTO documents disappear Hi Anders could you have the subsidiaries check whether their Office 2003 is the PROFESSIONAL or the STANDARD edition Only the Pro edition supports XML tags. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 8
    - Retrieve images from word document VSTO doesn't provide any special tools for this, no. It needs to use the same functionality as available to anything using the standard Word interop. This would include being able to extract the image to a stream as base64 from the Word 2003 or 2007 XML file format. But any WinForms or Console app could do the same. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 9
    - VSTO for Excel Hi Dave, It's good to hear you are considering using VSTO / Excel. You can manipulate the data from you DB in the managed addin using ADO.NET classes. Excel's chart related objects provide a lot of flexibility for displaying the data. They have a whole lot of events (much better than other parts of the Office in this respect). Occasionally you may run into things that you just can not do with the object model (OM). Lets address your specific questions: 1. is it possible for the Excel Chart object to be created and destoryed and recreated dynamically in the same chart space Yes. I think you can do this through the OM. At the worst, you can always delete a ChartObject re-create a new one in its exact location. 2. Is it possible to create multiple Actions Pane No. Not in the current version of VSTO. I do not understand your scenario completely. Please explain it a little further so I can think of any workarounds. 3. Is it possible to detect that a user has clicked on a particular "dataset" (i.e. series or a point in a series) Yes. And a lot more :-) For example: I have a worksheet with a blank Chart Object, with chart type set to pie chart. The following C# VSTO customization sets the data source of the blank chart to cells A1:B3 which have data A B 1 Milk 50 2 Egg 20 3 Bread 30 private void Sheet1_Startup( object sender, System. EventArgs e) { // Set data source for chart. Attach double-click handler. cObj = (Excel. ChartObject ) this .ChartObjects(1); cObj.Chart.SetSourceData( this .Range[ "A1" , "B3" ], Excel. XlRowCol .xlColumns); cObj.Chart.BeforeDoubleClick += new Microsoft.Office.Interop.Excel. ChartEvents_BeforeDoubleClickEventHandler (Chart_BeforeDoubleClick); } void Chart_BeforeDoubleClick( int ElementID, int Arg1, int Arg2, ref bool Cancel) { // Depending on which part of the pie chart you click diff values MessageBox .Show( String .Format( "ElementID: {0} Arg1: {1} Arg2: {2}" , ElementID.ToString(), Arg1.ToString(), Arg2.ToString())); } I found out that clicking on the chart area in Excle is a very tricky thing. Unless you are careful, you end up clicking the whole chart rather than elements of the chart. There is a whole newsgroup dedicated to Excel Chart questions. You will probably get better answers about the chsrting API there: http://msdn.microsoft.com/newsgroups/default.aspxdg=microsoft.public.excel.charting&lang=en&cr=US Also, searching on the web I found this good starting point: http://www.computorcompanion.com/LPMArticle.asp ID=221 Hope this helps Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 10
    - Best practices for server-side generation of spreadsheets Hi Dag The situation for automating Office applications server-side hasn't changed. MS has chosen a different route: Open Office XML file format for Office 2007 applications, which allows you to construct the files as XML. The big difference for you is that the Office team has provided a converter that will allow earlier versions of Office to also open/read these files (in Word it can also write to the new file format). The converter is available to Office 2002/2003 as part of the automatic updates. It can also be downloaded and installed for all these versions, plus 2000. Note that performance/results may be poorer in this latter scenario. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 11
    - Problem linking assembly to existing Excel file Have you run the application manifest editor on your Excel document to verify that it indeed is pointed to the correct path for your assembly If not, you can find that here: Application Manifest Editor Sample If not, since you're installing your assembly in the GAC, have you tried leaving the assembly location empty Since, in theory, anything in the GAC can be 'found' from any location ... Just some random thoughts of madness. ;) Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 12
    - Working With the Outlook.NK2 file The format of that file is binary and undocumented. You'd have to reverse engineer it. In your scenario, deleting it completely might be the best solution. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 13
    - Outlook 2007 and Word 2007 AddIns You'd also need a separate Outlook 2007 add-in to support scenarios where Outlook 2007 is installed but not Word 2007. Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 14
    - Not Able to debug VSTO word Application This is happening with a new project you create, as well as with existing ones Which version(s) of Office do you have installed on your development machine Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 15
    - Programmatic access to Visual Basic Project is not trusted I'm afraid this falls outside the scope of the VSTO forum. VSTO is a particular Visual Studio .NET technology. Your best bet would be one of the office.developer newsgroups, as listed in the "Please Read First" message at the top of this forum. You might also try testing on a system without SP3 installed. There have been numerous reports of "odd things" with that SP... Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office
  - 16
    - Managed code extensions not working for word template Hi, If the new dll and document are in the same directory, you should just trust the new dll using caspol If the new dll and document are not in the same directory, two things to do to make it work: бд Update the manifest embedded in the document. бд Trust the dll in new location using caspol Please refer the following two walkthroughs to get the detailed information. http://msdn2.microsoft.com/en-us/library/ms404812(vs.80).aspx http://msdn2.microsoft.com/en-us/library/ms404838(VS.80).aspx Thanks Ji Tag: Visual Studio Tools for Office problem using wizards with the stored procedure in VSTO Office

Alexei Matiko

Hi!
I have a stored procedure for Cross-table query (like PIVOT in SQL2005).
Proceure execute sql statement which returnes dataset but in this case quantity of columns is not constant.

Am I right to use the following code for data binding or there are any other methods using wizards

string strSql = "exec sp_CrossTab @table='ViewPrixBySeas',@onrows='EgleS.dbo.GetSeas(data)',@onrowsalias=' ',@oncols='seas',@sumcol='summ'";

Microsoft.Office.Tools.Excel.ListObject myListObject = this.Controls.AddListObject(this.Range["A1", missing], "myListObject");

DataSet dsTable = new DataSet();

dsTrims = SomeThing.ExecuteDataSet(System.Data.CommandType.Text, strWhere); (My DataAccess Layer)

this.bindingdataSource1.DataSource = dsTrims;

myListObject.SetDataBinding(bindingdataSource1);

Thanx.

Top