Answer Questions

• ThomasD14 Newbie: Excel / Web Service calls / Background Process / Timer

  I'm a VSTO newbie attempting to put together a VSTO proof of concept but am running into, what is for me, some showstopper problems that I can't believe haven't been solved by others or are not really problems cause I'm doing it all wrong... The POC is to call a a webservice at say 5 second intervals and populate lists in the Excel sheet with the data returned. An important aspect of the requirements is the the user can work on the spreadsheet whilst data is being updated and so some form of background process is required for the potentially slow webservice calls. I've managed to get this working using a System.Windows.Forms.Timer instance and the BackgroundWorker component, happily updating the lists on the sheet (flickering away ni ...Show All

• BilalShouman Download Errors

  I downloaded the trial version and am not sure it worked right. The stated download size was 2.7 GB, but the IMG file I downloaded was only 2.0 GB. I extracted it using ISOBuster, and received some messages that it could not read certain sectors. I clicked ignore and installed the product, but then received an installation error 2324. How do I know if I have it installed correctly Thanks for the suggestion. Any thoughts on the error message I received (see previous post) in regards to download managers im not really sure. try maybe Go!zilla The error message is below. I tried downloading again and got the same file size, so I'm guessing 2.0 GB is correct, even th ...Show All

• auer Running VS 2005 under a non Admin Account

  I am trying to stop logging into my machine as a adminstrator. To do this I tried to launch VS 2005 with this command: C:\WINDOWS\system32\runas.exe /env /user:<Administrator Account> "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" Where <Administrator Account> is replaced with an appropriate account All seemed fine until I tried to design a stongly typed dataset. Then I got the message the message: Key not valid for use in specified state I got around this by removing the /env. (I think the encryption key is based on the user's sid but with the /env switch I was referencing the key for my logged in account as opposed to the runas account) I also had a problem when I deleted files. The fil ...Show All

• z248910 locking configuration

  It takes some time to get the tool windows, etc, arranged the way I want. From time to time, however, I accidentally do something that changes the layout. Since the undo doesn't restore the layout, is there someway to lock or same the configuration so I don't have to spend another 1/2 hour setting it all up again I for one find the docking far sensitive to user interaction. There should be a btn that toggles into and out of docking mode and most important, there should be a "Do you really want to change the docking" query before the docking actually changes. Thanks for the reply. That I will do. I intended to do as you suggested but I am unable to find Tools- import and export settings or any reference to it in the h ...Show All

• sorsh ParserContext incorrectly turns relative paths into absolute

  If I understand well, ParserContext permits to resolve relative paths. For example I can specify an image using "Images\1.jpg" while the ParserContext specify the Base Uri to resolve this relative path. The problem is during save. If I use XamlWriter.Save the absolute path is saved so if the xaml is moved to another folder, the xaml resources cannot be reloaded anymore. So what is the trick to solve this Thanks, Raffaele This is a limitation of XAML serialization. See http://msdn2.microsoft.com/en-us/library/ms754193.aspx Best advice would be not to use it and implement your own method of serializing objects, which is what most xaml editors do by keeping a logical copy of the tree and implementing their own ...Show All

• JNils CommandManager incomplete?

  I wanted to add a command to a ContentElement (Hyperlink) using CommandManager and discovered quickly that AddExecutedHandler() only accepts UIElement. The lack of a similar method for ContentElement or a common base interface seems to me like an unusual ommission. Is there another method I ought to be using ...Show All

• cmwith Cannot run August CTP Samples

  I installed the August CTP, after the LINQ Preview. Everything installs correctly. I opened the solution in VS2005 and built it, everything compiled. I mapped a virtual directory to the installation folder of the webapp sample (on my machine - 'C:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample') The first time I try to access the sample it takes a long time, then errors out to this : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Descr ...Show All

• Kolja Error while migrating web service to WCF service

  Hi, I'm trying to Migrate my web services to WCF service. While browsing the .svc file in IIS I'm getting the following error. I've checked the earlier posts on this error & made respective changes....but the error is persisting.... Please help. Server Error in '/WebserviceTest' Application. -------------------------------------------------------------------------------- The type 'WebserviceTest.AgentWS', provided as the Service attribute value in the ServiceHost directive could not be found. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.I ...Show All

• R0nda Extensible DLINQ mapping for application types.

  In my current data access layer code I often map a pair of FromDate and ToDate database table columns to a DateRange object in a business entity. Are there plans to implement an extensible sql column mapping mechanism in Dlinq to support automatic mapping of application types Jon, Currently we do not plan to add additional support for computed values in mapping. As alternatives, you could use a DateRange property that simply returns the difference between the mapped fields. You could also map to a view with the computed column. Since the abilities in views and C#/VB language are a lot richer and safer than what we can put in mapping, we have not included this feature. Thanks. Dinesh Dinesh, ...Show All

• Carlos Hdez svcutil syntax for /config option with two filenames

  I am trying to use the two-filename syntax for the /config option to the svcutil tool. First, I am using the June CTP builds of everything and did not install any prior releases of WinFX. The doc for svcutil says: /config:<file1 [, file2]> Instructs the tool to generate a configuration file. If only one file name is given, that is the name of the output file. If two file names are given, then the first file is an input configuration file whose contents are merged with the generated configuration and written out into the second file. If I specify "/config:input.config,output.config", then I get the generated config info placed into a file named "input.config,output.config". If I insert a spa ...Show All

• YiNan Output from devenv at command line

  I'm running the Visual 8 devenv command line utility to compile my project like this: devenv mysolution.sln /build Debug However, the output from the build process isn't written to the command line output until the build is finished. (In Visual 7 it was continuosly written to the output, errors and built files). How do you configure the devenv tool so that it behaves like in Visual 7 There was a change because of changes to enable multi-threading. You cannot modify this behavior, and you need to wait until the process is complete to use the output. Craig ...Show All

• Davids Learning Is there any preemption between jobs queued to a dispatcher?

  I suppose no, otherwise we would need a synchronization between jobs queued on the same thread. So, when a generic method queued throug Invoke or BeginInvoke is scheduled, is it executed until completion without preemption in favor of other queued jobs Preemption should happen only between different threads, there yes i need to synchronize as well. Is that right Thank you. Right what i was expecting. Thank you. DispatcherPriority is the only thing I'm aware of that you can use to cause your activity to execute at a higher priority than other scheduled activities. Once the activity is executing it will execute to completion consuming the UI thread. Multiple threads act ...Show All

• Paulustrious Executing Commands from *any* event

  I understand that commands can be triggered off certain events of certain controls. For example, specifying a Command for a Button will trigger it off the Click event. But what if I wanted to trigger a command off of a different event -- like a Load event Is there a way to do this at all If so, can I do it from XAML only I just logged a feature request on the feedback site. Go here to vote and add a comment . Hopefully this is something that can be added in time for the final version. Create a handler for the event and call RoutedCommand.Execute within your handler. I'm not sure if you should call CanExecute first or if Execute will check for you. (To err on the safe side call CanExecute firs ...Show All

• Jason56 Excel add existing worksheet to workbook

  I trying to copy/move a worksheet into a workbook in .net. Something like this.... using Microsoft.Office.Interop.Excel object missing = System.Reflection.Missing.Value; Application oXL = new Application(); oXL.Visible = true; //create workbook Workbook oWB = (Workbook)(oXL.Workbooks.Add(missing)); //create worksheet Worksheet oSheet = new Worksheet(); //add the worksheet to the workbook oWB.Sheets.Add(oSheet ); I only see how to create a new sheet in the add method. Worksheet oSheet = (Worksheet)oWB.Sheets.Add(missing, missing, missing, missing); How would you do this the other way from VSTO to a non-VSTO workbook I need to worksheet.copy a "finished with" worksheet out to another workbook that I created in a diff ...Show All

• srinivas_kv80 Selection.Move infinite loop on Word 2007 document

  I am writing a Word 2007 add-in with VSTO SE. A button in my custom task pane moves the Selection through a document in steps of one paragraph. The code is shown below. It hangs midway through the document in an infinite loop. The document I am testing is a Microsoft financial document at http://www.microsoft.com/msft/download/FY06/MSFT_3Q2006_10Q.doc . Is this a bug It does the same thing if I save the document as a .docx file. The problem is the selection keeps moving in a circle in this table (from Page 20 of the document). Three months ended March 31, Percentage Change Nine months ended March 31, Percentage ...Show All