jchau's Q&A profile

• SQL Server Why use CLR procedures for simple queries?

  Allow me to preface this by saying I'm really excited about writing stored procedures, etc. in C#!! Now...on to my question. When an application needs a simple result set (i.e., SELECT....), why use C# to write this In the samples I've seen, the developer ends up writing the select statement anyway in the CLR hosted stored procedure. What would be the benefit You end up writing more code just to write the same query. Now, executing complex logic is another story. I see HUGE benefits to hosting classes on the data server. Anyway, what is Microsoft's answer to this question Is it recommended that one still write simple statements in T-SQL and ...Show All

• Windows Forms Relaunch of Windows Form

  Hello all I have a small problem. In most cases I can track these things down pretty easy but the complexity of the application after 2 years of development and use has made it hard to track down this last one. The Scenario: Main application runs in the background 1 pixel X 1 Pixel which launches the initial form. When a form is ready to open another form I do the following: BPS.frmMain frmMain = new frmMain(); frmMain.Show(); this .Dispose(); this .Close(); The problem: Due to third party APIs (Written in anything from C++, to VB to me porting from VB to VB.Net and then to C#) being called a form I will dispose ...Show All

• Visual Studio Tools for Office comaddin.Object does not work

  I am trying to make two Excel addins talk. the 1st addin can be seen by the 2nd via app.COMAddins collection, and I verified that the addin instance has the right ProgId. however, the Object property yields <undefined value>, therefore, I can not call methods on that addin. what can I do to figure out what is wrong The way it needs to be done is : your first add-in should initialize set the Object property to something. It can be done in IDTExtensibility2.OnConnection method. You will need to cast OnConnection's AddInInstance parameter to Office::COMAddin, then set the Object property. Then, ...Show All

• Windows Forms How do I set control properties between winforms

  Hi, I'm using properties and overloaded contructors for pass data between winforms, and it works very well, however, I can’t set some properties for windows controls, for example, I'm trying to set the label.Text property that it's located in a Winform called "frmPlanificador", from another Winform called "frmActividades", but it doesn’t work yet. This is that I'm trying to do : ********************************************************************************************************** formPlanificador.PKActividad = pkActividad; formPlanificador.lblActividad.Text  =              ...Show All

• Visual Studio Team System Expanding History Entries in History Tab

  Is there a way to expand by default the "changed fields" in the History tab of a work item Our QA team reviews the history and the changed fields frenquently. When they have to go through a long list of entries (or changed fields) they have to manualy expand all the nodes one by one to find the info they are looking for. This was one of the features in PStudio... Thanks. Unfortunately not. You can use the Tab and Enter keys to move along the entries and expand them one by one, but we don't have what you need in V1. Thanks for letting us know about this scenario. We will add this to our list of feature needs. Th ...Show All

• Software Development for Windows Vista Using workflows with asp.net Wizard

  Hi!   I'm trying to use workflows to display different steps from an asp.net wizard. I add this code to buttonlinks which do the state switch:   protected void NextStepButton_Click( object sender, EventArgs e) { MyService  myService = WorkflowManager .Runtime.GetService< MyService >(); myService.RaiseEvent( this .workflowInstanceId); this.scheduler .RunWorkflow( this .workflowInstanceId); } The problem is that the change between states is too slow, so that the page is already reloaded and i visualize the previous state. How could I delay the page load so that the st ...Show All

• Visual Studio Tools for Office VSTO 2005 questions...

  I hope that someone can help me with any of the following questions: · Is it possible to run a VSTO 2005 application inside a Word 2003 document opened directly from a web (on a URL like http://server/app/mydocument.doc ) (If so, how to configure the .NET 2.0 security on the client ) · Is it possible to run a VSTO 2005 application inside Word Viewer 2003 · How to highlight parts (words or periods) of a Word 2003 document by using VSTO 2005 and without modifying the document For example, my VSTO 2005 application needs to highlight somehow the phrase starting from the char at the position X and e ...Show All

• Visual Studio Team System Code Analysis Settings

  Hello, Does anyone know if there is an easy/simple way of applying Code Analysis settings across multiple projects within a single solution   For example, I have a solution with seven projects.  I would like all seven projects to have the same code analysis settings.  However, going through each project is a little time consuming and I'm likely to miss a few settings here and there. I guess what I'm really asking is... is there a way to apply the Code Analysis settings globally for ALL solutions or for a SINGLE solution so that all projects "inherit" their initial settings from the solution   --- Thanks, Jeff ...Show All

• .NET Development Regular Expression syntax for C#

  Hello Everyone, Currently, I am working on a project that required heavy pogramming with regular expression. I am looking for documentation about regular expression from Microsoft. Please upload the document if you don't mind. Regards JDang Hello Jdang, The build-in support for regular expression in .NET framework 2.0 are the classes in namespace System.Text.RegularExpressions. For example, for example, the Regex class which represents an immutable regular expression: Regex rx = new Regex(@"^- \d+(\.\d{2}) $"); // Define some test strings. string[ ...Show All

• Visual Studio Team System Accessing work item history from API

  How do I access the work item history from the API I want to traverse the history of the work item by entry if possible. If it is not possible, a string with all the history will help too. Thanks Hello You can fetch the work item of a particular revision from Work Item Store and then access the History Field to get the History. A sample code is here: WorkItem wi1 = WIStore.GetWorkItem(wi.Id); wi1.Open(); wi1.Title = testTitle + "Random Text"; wi1.Description = testDesc + "Random Text"; wi1.History = "Random Text"; int revisionNumber = wi1.Revision; wi1 ...Show All

• Visual C++ differences in symbols between 2003 and 2005 msvcrt.libs

  Why doesn't the new msvcrt.lib contain all the methods that the past msvcrt.lib has, in specific the __iob function I have always used the multithreaded dll in past projects and versions because Microsoft has always recommended it. Now I have older libraries that were built according to their advice using the msvcrt.lib and that rely on the presense of the __iob function and the function is not in the new msvcrt.lib. I don't know how to proceed. Can someone provide me with steps I need to take to get around this As the two underscores show __iob is an internal variable of the CRT. You have to recompile ...Show All

• Visual Studio DateTime picker and the ReportViewer

  Hi, I am running SQL Server 05 (SP 1 CTP) and Visual Studio 05. Is the reportViewer used for the Asp.net webforms supposed to have a working date time picker control I know that this was an issue on the beta 2 but I am still expericiencing the same problem.  The date report parameters work fine on the preview but when displayed on the ReportViewer in a webform  they don't work. I am running version 8.0.0.0 of the  Microsoft.ReportViewer.WebForms Thanks, Mauricio Can you be more specific about how it doesn't work Do you get an error message Does the calendar not show up at all ...Show All

• Windows Forms DatagridView With multicolumn Combobox

  How can handle in datagridview with multicolumncombobox please help me to provide this solution. ...Show All

• .NET Development How to perform bitwise operation in DataTable.Select(string) ?

  I tried "(status & 16) >0 " and it reported Exception!!! This,however, works fine in SQL server query. I cannot find any good resource about bitwise operation in DataTable. I'm very new to this. Experienced people please tell me!!! On top of my head, you could try status % 16 > 0 and status > 0 It should give you the same "effect", because if will in essence give you the 4 least significant bits. I don't think we support binary operators on DataTable. The full supported syntax is available at DataColumn.Expression --VV [MS] vascov@microsoft.com ...Show All

• Visual C# ms word does not answer to any Add-ins at all

  Hi, I am newbie and i realy need help with my three questions i have worked on them 2 weeks but steel no success. 1. I built a shared Add-In project that worked good on ms word but i dont know what i have changed, now after many times debugging ms word does not answer to any add-in project at all , I tryed to debugg my code i set "start external program" to Word.exe and used br eak points but i got message like "the breakpoint will not currently be hit no symbols have been loaded for this document". 2. how can i insert a text as a custom property to word document 3. i have built another add-in for Excel it wor ...Show All