invantix's Q&A profile

• SQL Server Trying to Populate a Name Column

  I am trying to update a name column in the following way: (I wrote a description, but I think this visual is easier to understand). This is what I have: name1 name2 address etc Bob null 123 street Sue null 123 street Jack null ABC circle This is what I want: name1 name2 address etc Bob Sue 123 street Jack null ABC circle I'm just trying to get 2 names on the same row if they have the same address and get rid of the spare row. Name2 is currently null. Seems simple enough but I don't know how to do it in SQL. I can do it in FoxPro, but that doesn't help me here. Thanks for any ideas. ...Show All

• Windows Forms How do you manage develop and release version?

  Before I publish my new version, it must be tested by some users. If users not found any errors, then I can publish release version. How can I manage this Exists an easy way to do this with ClickOnce Regards, simon ...Show All

• Smart Device Development <RESOLVED>HT trap _ and - keystrokes

  Does anyone know how I can trap the underscore and dash keypresses I have to allow these keystrokes while excluding others. When a dash is depressed, e.Keycode returns a value of 189 and when I try "e.KeyCode.ToString = " I get "Back, ShiftKey, RMenu" which makes no sense at all. Thanks in advance! Try hooking the KeyPress event instead and take a look at e.KeyChar: private void textBox1_KeyPress( object sender, KeyPressEventArgs e) { e.Handled = !(e.KeyChar == '_' || e.KeyChar == '-' ); } ...Show All

• .NET Development pulling info out of a string(xml) in c++?

  I am new to XML and I don't really know how to access the information in c++. I have some code that is returning a directory and file tree to me in a string that has xml code in it. I need to know how to get all of the information pined between the href tags and stick them in a vector. I just don't know how to parse the string easily. I could write my own string parser specific to this case but I would rather not. Any thing out there already If you need a sample file I can post a simplified version. And if you need code I can post that also just let me know. Thanks a lot Matt In .NET you can use System.Xml.Reader class to parse string. Outside of .NET you can use MSXML: http://www.perfectxml.com/CP ...Show All

• Visual Basic Need help converting 2005 project back to 2003

  I recently converted a project to 2005. There were no problems.. however I now need to convert that project back to 2003 in order to give it to another developer. Is there a way to do this I made no changes after conversion. Take the backup that you have and give it to them. You did tell the upgrade wizard to backup the project Even so, you have the origional source code backed up elsewhere of course, don't you Perhaps CD or DVD. Maybe it's in a source control. You must have a copy, somewhere...If not, you will have to admit you screwed up big time. This should be the one and only time it ever happens (every developer is allowed to mess up like this once in their whole life). However, a ...Show All

• SQL Server sp4 on dev edition 2k

  I'm running SQL Server 2000 (Developer Edition) on an XP machine. I'm trying to apply Service Pack 4, which, though I haven't service packed SQL Server 2000 in a couple years (most recently working more in 2005), I have installed SPs against SQL Server without difficulty in the past. I've downloaded the x86 SP4 exe. I extact the package ... but when I got to run setupsql.exe from a command prompt, I get nothing -- no dialog, no apparent install. silent switch is NOT specified. I used add/remove programs to attempt to remove vs2003 EE. we're reloading my machine today, so I hope to avoid recreating the issue. ...Show All

• Visual C# Converting string to number

  Hello, I've been coding for a total of 4 days to please forgive my ignorance. I am trying to fill a field called 'Depth', with the Data Type 'number' in a simple access database. The number to be updated is entered into a textbox called 'txtDepth'. Following a button click event I then want to use the update method to take the contents of the textbox and place it in the field, however I first need to convert the contents of the textbox from string format to a number format that allows a value to 2 decimal places. My questions are: 1) How do I convert the string to another format 2)What format do I convert the string to My code is as follows: DataRow NewDepthSampleRow = pitLoggerDataSet1.DepthSample.NewRow(); ...Show All

• Windows Forms Short Cut To Different Outputs

  I created a utility project that creates an exe as an output that im including into the setup project. I can see the exe listed in the output section of the primary output.. It gets correctly included when i test the installer, however i dont seem to have the option to create a short cut to it. Similarly, I dont seem to be able to create a shortcut to other output types. is it possible to create short cuts in these case I know i can add the file in manually and created a shortcut, but Id like to keep the file included as a primary output since then i can move things around and the setup project will automatically adjust Anthony I don't believe there is another way to do that, but then I always just add t ...Show All

• Visual Studio 2008 (Pre-release) TabItem IsSelected background property

  Hello, I am using the June CTP and here is my problem: I have a TabControl with some tabItems that I am trying to style. I have my style working and it looks great. The only problem is when a tab is selected it changes its background and forground. I am using the trigger property to catch when the tabItem is selected and am able to change the foreground color (im my case it changes to red). However, the background does not change (even with a simple color of black instead of my gradient). Am I setting the wrong property (background) or is this not implemented in the tab control yet <Style x:Key="tabItemStyle" TargetType="{x:Type TabItem}"> <Style.Triggers> <Trigger Property="TabItem.IsSele ...Show All

• SQL Server ODBC on Report Server

  Hi There, Is there a way to configure the shared ODBC on the report server so that users do not need to enter a username and a password when generating reports Thanks Sonz ...Show All

• Visual Studio 2008 (Pre-release) Multiple ServiceContracts implementation problem

  Dear All, I’m very new to WCF, so after couple of days of reading and coding I tried to write my second service. I want to deveplope services with a couple of contracts. In all samples, that I've seen, all contracts implemented in the single class. Then this class used in the one ServiceHost instance. But if I going to handle a thousand differrent contracts Should I do it in a singe service-behavior class It looks bad. Show me right way, please. Also, can I instance more than one ServiceHost object in a service Thousands of contracts This sounds quite excessive. It must be that you also have many logical services ...Show All

• Software Development for Windows Vista master agreement that must be signed before making software logo submissions

  Dear all I'm having trouble competing this agreement. In the PDF it states we should enter our name and press submit, but on the page given, there is just an embedded PDF, that is not editable, and has no SUBMIT button https://winqual.microsoft.com/member/LAC/DocumentDetails.aspx id=513&type=0 This logo submition business seems to be overly complicated :( Hello MGreen, Thank you for pointing this issue out, there is a fax number at the botom of the document if you want to get this sent in ASAP. I will submit this issue through our escalation channels to see if we can indeed get a form on there or another work arround. As stated by the document the fax number is: 425-706-7329. I ...Show All

• SQL Server Displaying the dates in a column.

  Can someone help me with this. I've been trying to produce it this way but still unsuccessful. I'd like my table to look like this: Month: January Day wkDay ------------- 1     Mon 2     Tues 3     Wed 4     Thurs 5     Fri 6     Sat .     . .     . 31    Wed I want to display the whole month.. Please help.. Thanks.. select datepart ( d , getdate ()) ' Day ' , case datepart ( dw , getdate ()) when 1 then 'Sun' when 2 then 'Mon' when 3 then 'Tue' when 4 then 'Wed' when 5 then 'Thu' when 6 th ...Show All

• .NET Development Disable selected treenode highlighting during a dragover

  Is it possible to temporarily switch off node highlighting in a treeview In particular I want to do this during dragenter and dragover events. TreeView.HideSelection does not seem to work as the TreeView control has focus. I tried TreView.SelectedNode = null but that failed to work. - Paul ...Show All

• Visual Studio Team System Error when running tests: Column 'TestType' does not belong to table test.

  I and everyone on my TFS team is getting the following error message box when trying to run unit tests: --------------------------- Microsoft Visual Studio --------------------------- Column 'TestType' does not belong to table test. --------------------------- OK --------------------------- I checked the TFS databases, and I couldn't locate any table named test, so I'm not really sure where else to look. Has anyone seen this before We've been able to run tests before and this just started happening today. We are using the RTM version of Visual Studio Team System with TFS Beta 3 Refresh. I think I solved the problem: It seems that my VS2005TS - Developer didn’t like my old testrunconfig file witch ...Show All