Henzrake's Q&A profile

• SQL Server Parameters Changing Parameters

  I have two parameters, Vendor and Status and I need to change the value of Status when the user changes the vendor from all to a single vendor and grey out the status parameter or just have it show all. Any Guildence . May be you need to read about "Cascading Parameters" to solve your problem. Here is one link: http://msdn2.microsoft.com/en-us/library/aa337426.aspx --Amde ...Show All

• Visual Studio Express Editions How Do I Concatenate an Array of strings?

  Dim strArray(intNumber) As Strings 'I want my output to concatenate the Array of strings into one string...with (WhiteSpaces between strArray) For intCount = 0 To intNumber strTemp = strArray(intNumber) Next intCount 'The output is something Like lblOutPut.Text = strTemp simply go through each item in the array and concatinate it or add it into a string builder...Example: Dim theString as new System.Text.StringBuilder() for each currentWord as String in strArray theString.Append(currentWord) theString.Append(" ") next Me.lblOutPut.Text = theString.ToString() this will append everything, all the items in the string array into a stringbuilde ...Show All

• .NET Development Parse through all XML files in listBox and add values

  I am trying to loop through all my XML files that are selected in a listBox but i am getting a few errors that i dont know what to do about and wondering if i can get some assistance...take a look at me syntax string thefiles = listBox1.SelectedItem.ToString(); if (thefiles.EndsWith("MAN")) { { XmlDocument xd = new XmlDocument(thefiles); what am I doing wrong here xd.Load(thefiles); XmlNodeList xn; foreach (XmlNode node in xd.SelectNodes("Appointments//CLIENT_ID")) { listBox2.Items.Add(node.InnerText.Trim()); } } I added "using system.XML" and the compiler tells me these two errors....any help on where i am going wrong here : ...Show All

• .NET Development Config File

  Hi, I was wondering whats the best/easiest way to deal with a config file for your windows app (using C#). Basicly I'd like the user to save some values for when the run the app again. Any ideas/tutorials would be greatly appreciated. Thanks Use the built-in Settings functionality as described here Using Settings in C#. ...Show All

• Visual Basic Button1_KeyUp

  Why it doesn't work when I quite hold of button1 Private Sub Button1_KeyUp( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles Button1.KeyUp MsgBox( "Button1 is up" ) End Sub Thanks Thank you, DMan1 . It works. Private Sub Button1_MouseUp( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.MouseUp MsgBox( "Button1 is up" ) End Sub ...Show All

• Visual Studio Team System How developers can chooce to download assemblies nightly build ?

  Hello, After working on Source control and Work items i am now digging Team Build. I just started this morning to read some parts of the Internet  provided SDK and I am currently on envisionning how I will organize my work to provide to my team a dev build that let each one select which newly available assemblies he needs to download to pursue his current job. I read here how to achieve a nightly build in usinga scheduled task. I suppose sharing the build repository on the network but I am currently not identifying what can I do to provide each developper with the choice to get or not some fresh builded assembliies. Does anyone already think about this features and how to solve it. If not how would you solve t ...Show All

• .NET Development How can I use the .NET Framework to find out if an app is installed?

  I have a program that shows a list of files and the user can click on a file and that app opens up. Well if the user trys to open a file that does not have an associated app installed on the system, I'd like to give them more information. Is there any way to determine what applications are installed on a computer by using the .NET Framework. Well in that case you can read the following article on the MSDN that will help you out: File Types ...Show All

• SQL Server How to get rid of unused servers in SSMS?

  In Connect to Server dialog box in SQL Server Management Studio, it has a drop-down box with a list previously connected servers. However, some of these servers are not used anymore. I want to get rid of them in order to make a room for new server names. So far I could not find a way how to do this, apparently SQL Server does not store these values in the Registry. Is there a way to get rid of them Thanks. You can blow away all your Most Recently Used lists (including MRU connections) by deleting c:\Documents and Settings\<you>\Application Data\Microsoft SQL Server\90\Tools\Shell\mru.dat while Management Studio is not running. Management Studio will recreate the file the next time it starts. ...Show All

• Windows Forms Splitter control on event

  I am trying to figure out a way to design a winform that allows me that on the left side to select a button, and on the right side of splitter, to load another winform or user control. Is there a way to facilitate this Basically, the form would be invoked by the user, and have a default screen showing a splash image on the right side of the splitter control, and on the left side would be a collection of buttons. When the click event is raised on one of the buttons, the other side of the splitter would switch to either a seperatly designed user control. The purpose of this is I am trying to consolidate the amount of windows that are opened in our in-house application. basically everything that is clicked right now brings up a new window an ...Show All

• SQL Server Unable to install SQl Server 2005 SP2 - Unexpected error

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• Visual Studio Tools for Office How to add controls to an workseet at run-time?

  I'm writting a Excel Add-In and a Excel object is the Microsoft.Office.Interop.Excel. I want to add controls to an active worksheet at run-time. but, the Interop.Excel.Worksheet didn't provide any method for controls. I don't know to get a Tools.Excel object or a Tools.Excel.Worksheet object. (This Objects had some methods for controls.) I'm using the VS2005, VSTO SE, Office 2007. Can somebody help me Hi parang, The 'Controls' collection only exists in the Microsoft.Office.Tools.Excel.Worksheet object and you can only get a reference of this type when you have a customized workbook. In general, you cannot get a reference of this type from a managed add-in which would mean you cannot add managed control ...Show All

• .NET Development Microsoft.net framework,version 1.1 service pack 1 (KB886903)

  I have Microsoft.Net framework,version 2 with security updates (K8917283) and (KB922770) installed on my computer. I get a update notice to install Microsoft.net framework,version 1.1 service pack 1 (KB886903) and it will not install How do I get the install notice off my computer Thanks, Richard Santillie rsantillie@charter.net 541-245-0949 Hi Richard, If you want to resolve the installation issue for KB886903, I typically suggest the steps at http://blogs.msdn.com/astebner/archive/2005/10/11/479928.aspx . If you use those steps, you will also need to repair the .NET Framework 2.0 after you get the .NET Framework 1.1 issues solved. Hopefully this helps. Thanks! Aaron ...Show All

• Commerce Server Product bundling

  I am trying to implement a system whereby the customer is able to add additional products to the baskets when they are buying items like dishwashers and washer / dryers. The customer should be able check of that they would to add "Installation" and / or "disposal of old units" to the basket and have it show up as 1 lineitem. This lineitem should be editable so when the user clicks it from the basket it should show up with the correct checkboxes selected. The way I was thinking about implementing this was by following Max akbars example about product bundling - Using Relationships Solution Runtime. Unfortunately I don't quite understand Max's examples. Is it possible to ask for a more specific example of how ...Show All

• Visual Studio Team System TF50309 When Subscribing To Notification Event

  We've been having a problem with the Event Notification subscription, and so far we haven't been able to solve it. We're building a small application that encapsulates the Event Notification aspect of Team System, to allow subscription and monitoring of events easily. After testing it with a couple of users, we've encountered a problem: There are users that cannot subscribe to the event notification. My user has no problems, but when another user tries to subscribe, either through the API or through BisSubscribe.exe, it gets the following error: TF50309: You do not have sufficient permissions to perform this operation. That user has no problems using Team System normally, as in through Visual Studio - checking in and out, modif ...Show All

• SQL Server Is it possible to create a bar code in SQL reporting?

  I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.   Thanks SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free. When you've got the font then replace the font of the field wich has the code and that's all. Good luck in your search. ...Show All