Answer Questions

• Steve Hempen .net application with an excel interface

  Hi, I am converting an Excel spreadsheet used by stock traders to a .net application. I want them to give ability to set up new worksheets in the application and perform other Excel operations such as writing expressions to display new values based on values in other cells. Users basically like to calculate and display new ratios based on market values, I want to give them the ability to calculate and display whatever ratios or information they want from the core set of market information I provide them. Basically, what I am trying to achieve is to display an Excel sheet in my .net application, be able to populate and update the excel sheet from the values I get from variety of sources, such as database, events, and other files..The ...Show All

• Jernej Kase Using a SqlConnection with the ReportViewer in local mode

  I've finished with my first implementation of putting a ReportViewer control on an ASP.NET 2.0 page and running it in local mode, passing parameters to it. I used Microsoft's online article titled Convert RDL and RDLC Files , since I had first written the Reporting Services as a report and put it into Report Manager. As a part of that tutorial it had me place a SqlDataSource control on the ASP.NET page. That has worked but I am wondering if I couldn't open an connection to the SQL Server 2005 database via a SqlConnection, then execute my stored procedure, and fill a data table, and then give that to the ReportViewer control on the ASP.NET page I am also very interested in this topic. You can see a related query I started in a d ...Show All

• Javier_Uy Feedback please: WPF for LOB applications (Data entry/Data Viz/etc...)

  Feedback please: WPF for LOB applications (Data entry/Data Viz/etc...) Are you using or considering WPF for Line-of-Business applications What has you excited about WPF for LOB We are missing some things that would help LOB scenarios...are you waiting or doing without What is your advice for the Microsoft here What would you prioritize Please comment in the forum and/or on my original blog post ... Thanks, Rob I wanted to retract what I said about wrapper stuff regarding Vista. I just came across a blog that pointed out what I wanted was already in the Windows SDK. There is a sample library called VistaBridge that wraps the TaskDialog among other things in .NET. Here I have h ...Show All

• mbutcher problem converting 2003 solution to 2005 web application

  I think I have a setup problem, but am not sure. I have a 2003 solution with over 20 projects which I want to convert to a 2005 web application, but the conversion keeps converting each project to a web site. I had VS 2005 Express on my machine. It does not support web apps, so I removed it and downloaded the 90 day trial version of VS 2005 Professional and installed it, plus SP1, plus the patch and add-in for web apps. When I tried the conversion, (by navigating to the 2003 .sln file in 2005)each project became a web site instead of a web app. Another thread indicated there may be some conflict between VS 2003 and VS 2005 on the same machine, so I removed all VS related sofware for both versions, ran the Microsoft VS cleanup u ...Show All

• Rask Message Security with X509 certificate - Unexpected Locating of certificate

  I have implemented an example with message security and certificate authentication. For this reason I created certificates testsvc.crt and testclient.crt , which should identify the service and the client respectively. In my test example the client and service should run on one machine. To make this example working I imported certificates in the store as shown bellow: CurrentUser Personal Store: testclient.crt CurrentUser Trusted People Store: testsvc.crt LocalMachine PersonalStore: testsvc.crt LocalMachine Trusted People Store: testclient.crt Unfortunately with this configuration the service is not able to authenticate client, although the client’s certificate is in the LocalMachine Truste ...Show All

• Bill F. Server side Mail-Merge using VSTO2005

  I have been trying to get a prototype running for doing server-side mail-merge for the past week now using VSTO 2005 and am going nowhere.. Has anyone been able to successfully do this My constraints are: 1. Avoid having to install VSTO Runtime on client machines 2. Avoid using Word 2003 automation on server since its not recommended. 3. The source documents are a bunch of Word documents stored in a templates folder on the server. 4. We have to mail-merge using a runtime datasource, then send the document over the web using asp.net 2.0. If there is a good sample or article out there, I would really appreciate it. Thanks, JGP If you can't use the VSTO runtime on the client, ...Show All

• Butterflyangel02 Unable to start debugging on the web server

  if i careate new website with filesystem,anything is ok,but when i create new website with iis,When I attempt to run and debug I get the error: Unable to start debugging on the web server. The type initializer for 'System.Net.DigestClinet' threw an exception. what can i do There may be a project with the name of "Security", change the name and try it again. Hi, First thing to check is whether IIS is configure to use the correct version of ASP.NET. Assuming you are using VS2005 and ASP.NET 2.0, go to the Default Web Site's Properties under IIS Manager and on the ASP.NET page please make sure that the 2.0 version is selected (resetting IIS is needed ...Show All

• chiwa737 PasswordBox Databind or TextBox mask

  Hi all I know we can’t bind Password property of PasswordBox because security reasons But how can i Mask a databind TextBox , (llike we do with Windows forms textBox) if don’t needed this kind of security a possible way would be to listen to the input event and type in the masked character... There is no PasswordChar property (like in Winforms TextBox) to mask the textbox and hence no simple way to achieve the above. You probably have to inherit from TextBox and customize it. ...Show All

• ThE ViKinG ReportVeiwer and cookieless sessions

  Does anyone have viable workaround for using web reportviewer in cookieless mode Thanks, Ben. > 2.  When trying to export to excel or pdf, I get the following error (which is what I got before SP1 if I tried to view the reports at all): Yes, there is an issue with report exports. Here is my solution (actually, it's a filthy hack). The report window is activated by this JS function (I took it from Reserved.ReportViewerWebControl.axd): function HandleClientSideExport() {     // Some stuff ...     // Perform the export     var fullExportUrl = this.m_exportUrlBase + escape(selectedFormat);     window.open(ful ...Show All

• nick5454 Questions about Multimedia and WPF

  1. Does WPF support all video formats and container types supported by DirectShow if the necessary codec decoders and format parsers are installed 2. Do you plan to have any extensible audio-video codec framework for the next version of WPF, similar to the WIC (Windows imaging component) in the current version of WPF 3. Can bitmap effects applied to videos as well 4. Can DirectX audio effects be used in WPF apps A3. Yes...If you have a monster-PC, i tried a blureffect with radius 4 and the framerate i got was not funny. You know I've been intending to clean up/extend this FAQ, but have been busy with other things. I think I can answer some of your questions, but let' ...Show All

• Monish Nagisetty Word MAil Merge Automation

  I am trying to implement mail merge into our application using .NET as mentioned by c_shah. But the problem is, I am not sure what format the word document needs to be in. (ie., how to create mydoc.dot that is used in that example) I tried word's inbuilt mail merge functionality to create a template document that can be used from our application. But every time I try to do that, word requires me to enter the datafile. If I enter the datafile with dummy data, it immediately substitutes the data in its appropriate location. How do I save it as a template with no data in it so that I can later use it from my code to do mail merge Your help is greatly appreciated. Hi etrast I'm splitting your post ...Show All

• Alazekabi Task pane / Action pane needs to be available accross different workbooks but I cant make it!

  Hi I was wondering if someone could help with a problem on action panes / task panes in Excel. I have a task pane which is added via code (See below). I need the task pane to "stay put" as I navigate between different workbooks. If I load or add a new workbook, then the task bar is not available to these and remains only available to the worklbook in which it was added via code. My objective is to have an add-in which contains and controlls the functinonality of the action pane and have this available has I navigate between different workbooks. I hope some one can help. Many thanks for your help. David Edelman Public Class ThisWorkbook Public oActionPane As New ...Show All

• steveylevi Persisting formulas in databound ListObject

  I'm populating a ListObject from a database. The columns I have are CostPerHour and TotalHours. I have created the databound listobject through the VS designer and have added an extra column by the name of TotalCost (again through design view) and have applied a formula to multiply the First column by the second column. Now when I run the solution the formula seems to disappear and the multiply does'nt work. It feels as if it is being overwritten. I know I am not doing something right but I just cannot figure out what it is. I've gone through most of the MSDN samples and all of ListObjects in them seem to retain the formulas but I cannot seem to pin point what it is in Code (or design) that I am overlooking. And references to wher ...Show All

• Juliano.net Deploying LanguageService ColorableItems on customers machine

  Hello, We have created our own entries for text colorizers for our language service. All of this works fine and shows up in the "fonts and colors" area of Tools->Options from development machines. This is because we have the ability to reset our experimental hive, so it will see our changes. From our experimenting, we have found that doing a "devenv.com /setup" will register our items on the target machine after doing the install. However, this command has been known in the past to "turf" a users settings for the entire environment. Is there a better possible less destructive way to make sure our colorizers show up in tools/options kind of along the same line as "devenv.com /installvstemplate ...Show All

• Adam2342342341 How to Add a project reference using DTE?

  Hi All, How can we add a project (C# class library) reference to a Web Services project using Application Object Model (DTE) Best regards, Imesh Hi Trevor, Thanks a lot for your post. I will look into your code to find a solution. Thanks again, Imesh I have a similar problem. How do you dynamically add a project reference to an existing project using DTE I expected a project.AddReferences.Add(SubProject) See my article: HOWTO: Getting information specific to VB.NET and C# projects from an add-in or macro. at: http://www.mztools.com/resources_vsnet_addins.htm Public Sub ProjectFinishedGenerating( ByVal pr ...Show All