M Thomas's Q&A profile

• .NET Development Connection Pooling questions

  Does a connection pool exist on a per-application basis, or is is "global" to a machine If it is per-application, then what is the disadvantage of creating one SqlConnection object, and using that connection throughout an application I've read that keeping one connection open is a waste of resources, but if the connection pool is keeping the connection anyway, how am I saving resources by creating a new one in code each time I need one Obviously either everyone else has it wrong, or else I don't understand something. What am I missing Thanks, Kirk If you have a thousand users and you give each user their own connection then that is a waste and worse can actually create a situation where a data ...Show All

• Software Development for Windows Vista starting application from setup - not as administrator

  Hello all: When my application is run for the very first time at the end of the installation process, it is running as administrator, because the setup itself was automatically detected and elevated by Vista. Is there any option to run it from setup at usual (medium) privilege level I have tried manifest with requestedExecutionLevel of asInvoker - to no avail. TIA OTNS David and Efratian, thanks for your answers. Efratian: I am already subscribed to your thread :-) Unfortunately, I am using Wise for my setup, so I will need to write a separate DLL to make all this stuff possible. And, the question is, if I can change process tokens from a separate DLL. Seems too long and complex. ...Show All

• .NET Development codedom CompilerError Column always = 0

  I'm looking to get some debugging information from code that was built with codeDom and while CompilerError.Line and .ErrorText seem right, CompilerError.Column seems to always be 0. Am I missing something Has anyone else seen this of ever received a CompilerError.Column > 0 On a somewhat related note, does CompilerError.ErrorNumber mean anything Entering some incorrect syntax I receive ErrorNumber "BC30205" - can I lookup that error someplace [edited: - ok I found error list in the msdn library, but if anyone knows where I can find the  compiler errors in a list as plain text or in xml it would really tickle me.] /gabe update, this seems to be isolated to VBCodeProvider as CSharpCodeProvider doe ...Show All

• SQL Server Re-Installation of SQLExpress on XP SP2 Chinese Tra Version

  When I installed SQL Express first time a few days ago, it work ok. But, after removing all sql server componets through 'control panel'->'add or remove programs,' something seems wrong in the registry because the re-installation of SQLExpress will never success with an error ------------------- - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. ------------------------ in setup configuration checker. I follow the instructions in help page and try to ...Show All

• Windows Forms Using information displayed in a comboBox.

  I have two combo boxes that are both using one XML file to populate them. In this XML are names and the db connection strings associated with those names. I can view the info in the combos but what I am trying to get to from this is to use the conn string displayed in the second combo to be called when the selected index and data adapter (need the connection here also) for the third combo is activated. this is in VS 2005 C# did that make sense notacoder75455 wrote: to use the conn string displayed in the second combo to be called when the selected index and data adapter (need the connection here also) for the third combo is activated. you get your connection string from your combo2 right and want to use thi ...Show All

• Silverlight (formerly WPF/E) WPF/e vs. HTML

  After reading Mike Harsh's blog post What WPF/e Really is . I'm kind of disappointed with the approach that the Architects are taking with WPF/e, as in that it augments HTML instead of replacing it. Why not Personaly I find that HTML slows me down in producing rich content for my users (something that WPF promises). Sure its easy, its fast, and we should keep it (not every website needs rotating letters). However, as I see .NET being used -alot- for mission critical application, I would only EXPECT WPF/e to take the fore front and upgrading the way we provide commericial services on the Internet in a fast, uniform way. Flash is doing this, Flex is not 'augmenting' the Web, its rewriting it. Share your thoughts. I tota ...Show All

• Visual Studio Express Editions Random

  i need to make a random function that is only from 1 to 7 and that will not repeat eg 1,2,3,4,5,6,7 random number 3 so 1,2,4,5,6,7 random number 5 so 1,2,4,6,7, random number 6 so 1,2,4,7 and so on. i have tried to make it work but i couldn't I was actually looking for code I wrote, which was smaller than this. But this gets my vote because it creates an object that can be passed to the array, for my money, this is good OO coding and that's why I like it, it reminds me of how the STL works. ...Show All

• Visual Studio Windows SDK July CTP breaks documentation - again

  Windows SDK July CTP has once again borked my documentation. This time neither my MSDN Library nor my Visual Studio Combined Help documentation works. My MSDN Library link generates the following error message: --------------------------- Microsoft Document Explorer --------------------------- Microsoft Document Explorer cannot be shown because the specified help collection 'ms- help://MS.MSDNQTR.v80.en ' is invalid. --------------------------- OK --------------------------- My Visual Studio 2005 Combined Help loads but has completely lost all the help collections from MSDN, Windows SDK, .NET, and SQL Server. The only things left are minor third-party tools help. Repairing Document Explorer get's me a little further. My SQL Server 2005 d ...Show All

• Visual Studio Team System building web projects

  Is there a way to build a web project to simulate the same structure as the "Publish Web Site" building in Visual Studio Or would I have to create custom tasks to handle the files after compilation Ok now that configuration is throwing an error: Build FAILED. ASPNETCOMPILER : error 1003: The directory 'D:\Builds\eDiets\eDiets\eDiets - Internal Service Interfaces\Sources\eDiets\eDiets.Internal.ServiceInterfaces\SomeService\' doesn't exist. ASPNETCOMPILER : error 1003: The directory 'D:\Builds\eDiets\eDiets\eDiets - Internal Service Interfaces\Sources\eDiets\eDiets.Internal.ServiceInterfaces\WebSite1\' doesn't exist. 0 Warning(s) 2 Error(s) But the sources are in: D:\Builds\eDiets\eDiets\eDiets - Internal Ser ...Show All

• Visual Studio Team System Tweak work completed query to account for changing bug ownership

  ========================================== Update: Please see the post dated 9/28/2006 for a new request for help.   =========================================   I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item Microsoft_VSTS_Scheduling_CompletedWork" and add a "Date Week" perspective to it, but obviously that will only return the value of the "Completed Work" field at the end of the week (and is actually a sum of all Completed Work thus far.).  I need to report the change in completed work by developer by work tiem. I attempted to enter a formula in the report using Report Designer to subtract the current  value of "Completed ...Show All

• Visual Studio Express Editions ComboBox

  How can I add items to the combobox and once i click on certain item of the combobox,certain action would be taken. For example, once i add on second item of combobox, certain command would be sent to the serial port.. Looking forward to receiving feedback here in the forum..thanks a lot ! :) Code Snippet Dim WithEvents cboAddress As New System.Windows.Forms.ComboBox Private Sub AddItem( ByVal value As String ) With Me If Not .cboAddress.Items.Contains(value) Then 'checks to see if value is in the combobox .cboAddress.Items.Add(value) 'adds a value to a combobox End If End With End Sub 'Add the selected index chang ...Show All

• SQL Server update sys.sql_modules URGENT

  Hey. I've a question. In Sql 2000, I used to do update syscomments set text = replace(text,'string1','string2') How do I do that in SQL 2005 I know I have to use sys.sql_modules but I can't use the update statement on the view. Thank you. The correct and recommended way to alter definitions is to use the appropriate ALTER DDLs. Any other method that directly updates the system tables is not supported and it can lead to unpredictable results. So in your case, if you are trying to modify definition of SPs then script it out, change the definition and run ALTER PROCEDURE. Making changes directly to the database is never a good thing. You should make this using the source code control system (checking ...Show All

• SQL Server money format

  Hi. I have a money field and its value is greater than a thousand.For example its value = 32.885,60 I want to show the field's format like this (this number's format). I mean the thousand separator should be .(dot) and the decimal separator should be ,(comma) And I want two digit after the decimal separator.All these conditions matches with this number(32.885,60) Could you help me You can accomplish this by adjusting the Language property for the textbox, or the entire report to a language that uses this format. The language settings can be specific to just number formats when just setting the NumeralLanguage property on the textbox. After setting these properties, just use "N" as the format code. See t ...Show All

• Visual Studio Tools for Office VSTO SE - Create Spreadsheet on Server Without Excel

  I understand that with VSTO SE and VS 2005 you can create and manipulate spreadsheets on computers/servers that do not have Excel installed. I have done a lot of programming Excel with COM but am new to VSTO. I have searched various examples online but have not found just one simple example of creating a spreadsheet pro grammatically on a server that does not have Excel. The resultant application would be a console app that would run without a GUI to process and create/update spreadsheets. Could someone please list as briefly as possible (VB preferred, C# okay) how to create a new spreadsheet, update a couple cells, and then close the spreadsheet from the command line with no GUI. Thanks. Did you try us ...Show All

• Visual C++ Class error for CustomizeProject

  Hello all, With the following class idenified as follows: class CMsappwizAppWiz : public CCustomAppWiz { public : virtual CAppWizStepDlg* Next(CAppWizStepDlg* pDlg); virtual void InitCustomAppWiz(); virtual void ExitCustomAppWiz(); virtual void CustomizeProject(IBuildProject* pProject); }; The compiler gives me the following errors: msappwiz\msappwizaw.h(20) : error C2061: syntax error : identifier 'IBuildProject' .\msappwizAw.cpp(65) : error C2065: 'IBuildProject' : undeclared identifier .\msappwizAw.cpp(65) : error C2065: 'pProject' : undeclared identifier .\msappwizAw.cpp(66) : error C2448: 'CMsappwizAppWiz::CustomizeProject' : function-style initializer appears to be ...Show All