Seth Demsey's Q&A profile

• Visual Studio Team System Problem in rule validation for local member variables

  HI,             I have created a Custom rule to check the naming conventions. It works well for the module level variables/controls etc.           when we want to validate the variables of a private function/method . It does the validation for all its varibales. But the rule violation is reported for only one variable. While debugging every thing seems to be proper(it validates all the variables and adds the violations to the Problems collection). It is not reported in the Fxcop rule violations window. for example : private functionTestM ...Show All

• Architecture passing lookup values out and into services

  Hi all, This time I want you opinion on the following scenario: I have a service which returns info about an entity. Some of the information is based on lookup values (lookup=code/decode, such as "male/female", "small/medium/large" etc.) My options to output these values from the service are: 1. output them as the coded integers (male=1, female=2) - this is a problem because I shouldn't expose my inner data to the outside world, not mentioning that the outside world has no idea what "1" and "2" means ! 2. output them as strings ("male","female") - this also pose a pro ...Show All

• SQL Server Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B

  Hi, I have developed several SSIS packages with the last Beta of VS2005 / SQL Server CTP. After the public release I tried to uninstall the CTP-Versions to install the msdn finals but this time I got lost and was not able to satisfy the requirements of the final setup of VS2005. So I decided to install the whole pc again and after some hours I had a clean machine (XP with latest SQL Server 2005 Standard and VS2005 Professional).   Now I have tried to open my SSIS-Project but getting the following error:   Error loading ImpNetqNewsRss.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Schlu ...Show All

• .NET Development Connect ClickOnce WinApp To SQL Server

  Hi : I'm passing this problem from ClickOnce deployment and settings forum: I'v published a WinApp which using the xsd file abilities to connect sqlserver database . Installation on the client computer was successful. While first open my app. on the client machine it throw an exception s that it cannot connect to the sql server. Is there any ClickOnce solution to this problem (I don’t want to allow the clients direct access my sql server…) It should be web like. The clients get to the site and the site get to the sql server… The only solution I can think of it's web servi ...Show All

• Visual Studio Express Editions Cannot create a new project that opens startup form

  Have been using vb 2005 express final now for a week or too.  Have had no problems using and modifying example code and connecting to a MySQL database.  However i am now trying to create a new project and no matter what form is selected under startup form nothing displays when code f5 is pressed.  Message that build is ok in status bar screen refreshes and back to IDE.  However existing projects work ok.  Even creating a simple one form app leaving default form name as form1 the form will not display.  Any ideas please!    step by step 1 new project windows app 2 add button to form 3 add ...Show All

• SQL Server WITH NAMESPACES in SQL function is causing error

  Hi All, I'm getting the following compliation error when i try to execute the following function. I need your expert opinion on how i can solve this. ALTER FUNCTION [dbo] . [GetOrgChildHierarchyXML] ( @HierID int , @fiscalyear int ) RETURNS XML WITH RETURNS NULL ON NULL INPUT BEGIN RETURN ( WITH XMLNAMESPACES ( 'uri' as i ) SELECT OrganizationHierarchyId as "ID" , OrganizationHierarchyName as "name" , OrganizationHierarchyDescription as "Description" , CASE WHEN OrganizationHierarchyParentId = @HierID THEN dbo . CSTAR_GetOrgChildHierarchyXM ...Show All

• Windows Live Developer Forums How to "permanently" turn off Message History

  For the past 18 months, I've been trying to accomplish one goal but failed -- I just want to turn off the Message History in my MSN messenger. I can go to Tools -> Options -> Messages and uncheck "automatically keep a history of my conversations". That sort of works... until the next morning when I log in to my PC, it's always checked again. I leave my PC on 24 hours a day. Because I have "Prompt for password when computer resumes from standby" checked, I need to log in again every morning. I'm using Windows XP professional. And the same thing happens to me with MSN Messenger versions 6, 7 and 8 beta. A ...Show All

• Software Development for Windows Vista Dependency Property

  I have a custom activity derived from HandleExternalEventActivity that I have generated from a interface using the wca.exe tool. On this activity there is a dependencyproperty Approved (type bool) generated. The value of the property is set in the eventhandler for the activity. I have placed my activity inside a while activity that I have set up to have a Declarative Rule Condition that is set up like !this.pageApproved.Approved When I debug my custom activity and more precisely the get/set of the dependencyproperty. I see that when I send an event to the workflow that sets the property to true everything seems nice [ ValidationOpti ...Show All

• Windows Forms Problems with RichTextBox.Rtf

  Hey guys, I'm trying to set the Rtf property of a Richtextbox and I'm having some issues. First I do this, which works fine: string test = @"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}} {\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\ul\f0\fs20 Test\ulnone\par}"; this._agreementTextBox.Rtf = test; The textbox displays the underlined word "Test". However, when I try to do the same thing but instead read the rtf from a CDATA section in an xml file, I get an exception thrown: Here is the XML: <Options> <Item key="CLICK_THROUGH_TEXT">< ...Show All

• .NET Development Getting a version of a file using managed code in .Net 1.1

  Hi Is there a way in .Net 1.1 to get a version of a given file using managed code Thanks Rakesh. Hi Rakesh, Look at the System.Diagnostics.FileVersionInfo class: FileVersionInfo info = FileVersionInfo.GetVersionInfo("C:\myFile.exe") hope that helps, Imran. ...Show All

• Windows Forms play wav file!!!

  J was created a simple program who plays *.wav file. In module file J declare two functions: Module mod1     Public Declare Function Play1 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Integer) As Integer     Public Declare Function Play Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String,&n ...Show All

• SQL Server Remote Connection

  Could someone tell me how to remote connect to other server . Everytime when I try to connect to other server, I get an error message . Eventhough I have opened the 1433 port, allow the remote connection using both TCP/IP and named pipes, and open the firewall for connection. The following is the error message "An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft S ...Show All

• Visual Studio Team System Bug deleting & recreating project

  I deleted a project using DeleteTeamProject /force "Name", and now I try to recreate it again. I get the following error: ---begin Exception entry--- Time: 08/15/2005 05:10:36.153 Module: Engine Event Description: Task "Scc.SccTask" failed Exception Type: System.Web.Services.Protocols.SoapException Exception Message: A database error occurred (SQL error 2627) ---> Violation of PRIMARY KEY constraint 'PK_tbl_tmpReleaseNoteDefinition'. Cannot insert duplicate key in object 'dbo.tbl_tmpReleaseNoteDefinition'. The statement has been terminated. SoapException Full Info: System.Web.Services.Protocols.SoapException: A database error occurred (S ...Show All

• SQL Server Dynamic Excel Sources

  Please help.... I have different files that are sent from our vendors. Some are TXT and some are XLS. Some will have the same structure. I plan on grouping these together as best as I can. My main problem is that I would like to go from one source that matches a group of files to a single SQL table. I'm still learning about SSIS and its capabilities. If I can get pointed in the right direction or have an example to work from, that would be great. I've tried googl'ing to find some step by step, examples, and hints to do this right, but so far I'm at a bit of an impasse. Thanks, Dave Dave, You ...Show All

• SQL Server Problems with report fitting to a page when exporting and then printing from Excel

  I have various reports in both portrait and landscape and when I export to Excel although the page orientation works correctly the report does not print correctly in that the right hand side of the report gets chopped. In the report definition I have all the margins set to 0.5cm and the page height set to 29.7cm and the width to 21cm for portrait and the other way around for landscape. In designing my report I have a report width 1cm less to take account of the margins i.e. 28.7 for a landscape report and 20cm for a portrait report. The report is defined in all this space as I have lines in my header and footer than span the whole report ...Show All