Z.Fan's Q&A profile

• SQL Server question on using xp_cmdshell

  I am trying to run an exe file like: EXEC master.dbo.xp_cmdshell '\\Share\sharepoint\folder1\folder2\test.exe "input parameter"' And executing the above with the input should give me an output.But the input parameter is not recognised. Any help. Thanks EXEC xp_cmdshell 'dir *.exe'; try removing the double quotes, above I do a DIR command passing in *.exe ...Show All

• Visual Studio Team System How to find Const in the Fxcop1.32 rule?

  I am using Fxcop 1.32. I have an urgent requirement to make all the private const variables in my class file should be camel case. So i am able to retrive that a variable is private but i am not able to retrive the const part. So my requirement is how to find that a variable is "const" or not could you please provide me pointers in this direction. Regards Ravi Kumar Just to amplify on Dave's (correct) answer a bit, you can use the field.IsInitOnly metadata in order to determine whether you're looking at a readonly value (in case that analysis is important for your custom rule). Michael Fanning VSTS Development: Code Analysis ...Show All

• Visual Basic Add-In manager empty

  I have a number of commercial add-ins installed but none of them appear in my add-in manager. I checked the settings in Tools/Options - Environment - Addi-In/Macro-Security all options are checked, Add-in paths are correct .addin files are placed correctly I had previously had a Vs2003 install and a VS2005 beta. Both of those have been un-installed before VS2005 Professional was installed. Can anyone help thanks It works great now! But I had to uninstall VS2005 and then re-install. There goes another day of productivity. At least now it is working as advertised. Glenn ' ...Show All

• Visual Studio Choosing Visual Studio 2005 DirectX Help Source

  Hi all, I have a little troubles setting up my VS 2005 help. I installed DirectX SDK April 2006 and every time I search for something by pressing F1, it brings up DirectX Managed help. Is there a way to set it to use non-managed DirectX help files instead As managed dx help is kind of a useless to me... Thanks in advance. LOL, I found this microsoft forum as useful as their help files :) ...Show All

• Visual C# XML/XSLT -I think I'm going to put a hammer throught the screen!

  Hi Everyone,    for the sake of my monitor can someone please help me with an xml/xsl problem that I'm having. I have the following xml file (really simple stuff): <root rname="Directory"> <company name="XYZ Inc.">  <addressLines addressdata="One Abc Way">   <address2 val="his avenue"></address2>   <city cname="Tech city"></city>   <country cname="Neverland"></country>  </addressLines> </company> <company name="ABC Inc.">  <addressLines addressdata="One Abc Way">   <address2 val="his avenue">Add ...Show All

• Visual Studio Team System DOT NET

  I am trying to develop a rule which should do the following check logic on the class. If a default implementation is provided for a particular interface, a similar name should be used for the implementing class. Note that this applies to classes that only implement that interface. Example: A class implementing the IComponent interface could be called Component or DefaultComponent Can anybody help me Take a look at the types Interfaces member. You can foreach over these looking for specific interfaces you're interested in. public override ProblemCollection Check(Ty ...Show All

• SQL Server Connection managers - OLE DB

  Hi There Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one. In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it more efficient Or do i still need to define multiple connections to the same database and assign each task a different connection Thanx Did you have retain same connection set to true I don't h ...Show All

• .NET Development Unable to convert input xml file content to a DataSet from DataSet Designer

  First of all, here's the error: Error 1 Unable to convert input xml file content to a DataSet. 0 is not a valid value for Int32. Input string was not in a correct format. C:\Documents and Settings\dolan\My Documents\Visual Studio 2005\WebSites\ReproProject\App_Code\DataSet1.xsd 1 Second: I didn't do anything other than drag a table from server explorer into the designer. Immediately I save it and try to build the website as a test and get the error displayed above. The server is a SQL 2000 server, because I was hoping I could use ASP.NET 2.0 to replace our production site without having to bring up a SQL 2005 server. I'm not sure if tha ...Show All

• Visual Studio Team System Team Explorer does not auto-create a link from a parent work item to related work items.

  When creating a related work item in Team Explorer a link is not created on the parent work item to the child work item.  Consider the following example: Create a scenario called 'Test Scenario' - e.g. ID=1. Create a related work item (task) for this new scenario by right mouse-clicking on this scenario from one of the query windows. A new task is created named 'Related to work item 1 - Test Scenario'. - e.g. ID=2 If I click on the 'Links' tab on the parent work item (ID=1) I do not see a link to this new related task(ID=2).  (I do, however, see a link from the child(ID=2) to the parent ...Show All

• Windows Forms how to make an image follow cursor without flicker?

  Can anyone help me out   I want to make a image that's part of my resources (it's a gif) follow my cursor while it's inside a certain picturebox.  I've tried some code that involved a timer, but it had a lot of flicker.  Does anyone have a solution   Also, the image 48x48 pixels and I want the cursor to be centered on it. Codes   See above. ...Show All

• Visual Studio Team System Timeout during unit test

  Greetings. I've recently been introduced to VSTSs integrated unit testing abilities, and quickly decided to adopt them and write an extensive suite of tests for some software component or another. Much to my regret, however, I soon stumbled upon a rather annoying problem as some of my tests take a relatively long time to perform. I'd tell you how long, but unfortunately I can't quite tell since the testing framework decides to terminate the tests on its own account with the following message: "Test on Agent, X, exceeded execution timeout period" where X is the agent on which the test had run. I would expect that nasty little timeout to ...Show All

• Software Development for Windows Vista Can I show the graphically workflow on the browser?

  Like this, I need show the graphically workflow on the browser. I use c#.net base b/s. How can I do this Thanks everyone. I have an example on my blog - make sure to adjust your CAS permissions for the url of the website you create. There is also an example there of using the designer to create an image to display in the browser (which helps to deal with the security issues). ...Show All

• Visual Studio Error connecting to VSS test database

  I have VSS 2005 July CTP installed on a Windows 2000 Server and I had success setting up a test database. When I tried to connect to this database using HTTP access on a Windows 2000 Pro system I got this error: --------------------------- Visual SourceSafe Internet --------------------------- Cannot contact the Visual SourceSafe Internet Web Service or cannot access the specified database. The server returned the following error: A connection with the server could not be established (0x80072EFD) --------------------------- OK    --------------------------- Could you try to install VSS back on the server then modify ...Show All

• Visual Studio Express Editions Registration Fails

  I am having difficulty registering Visual Basic Express 2005. I get the email which gives me a link to confirm my email address, but when I click on the link, I get an error stating that the page cannot be displayed. I get that even when I manually cut and paste the URL. Is there another way I can register the product They will need .NET 2.0 framework installed. I think by default the setup will check this and download it from internet if it is missing on the computer you want to install on. ...Show All

• Visual Studio winforms reportviewer: Simple sorting and grouping fails in VS 2005 Beta 2 (beta2.050215-4400), Guid problem

  Hi, is it a bug, that sorting and grouping fails, when trying to display a report with winforms reportviewer. I always get a Microsoft.ReportServices.ReportProcessing.ReportProcessingException as soon I add sorting/grouping to the rdlc. Without sorting/grouping it works fine. If it's a bug, is it fixed in a newer ctp Regards Joe As you have already identified, you cannot group/sort/filter on Guids in the Beta 2 version of the RS controls. The workaround is to explicitly call .ToString() on the Guid. For the VS 2005 RTM release you can group/sort/filter directly on Guids. -- Robert ...Show All