James2007's Q&A profile

• SQL Server Performance difference

  Hello, i'm running 7 same HW&SW configured servers with the same load with SQL Ex 2005 SP1 installed. I'm executing SP over 200.000 times a day. And here comes the problem, every server got different average response time, the quickest executes the SP in 1 ms, the slowlest in 50 ms, that's 50x slower! Have you any performance hint, please Thank you. Thank you Andreas for your kind help. This is great idea! However i don't know how to reach SP execution plan in application runtime or some log option (not in Management Studio). Have you any suggestion, please ...Show All

• Visual Basic Program doesn't terminate

  Hi, i'm doing a program but i found something that isn't supposed to happen... When i click in the X to terminate the program instead of going to the menu the program closes but the task stays active... it only stops when i kill the task... someone knows why this happens I guessing you're calling Application.DoEvents. I'll explain more if I'm on the right track... ...Show All

• Visual Studio Team System Work Item Dependency

  Is there a way to lock a work item if it is dependent on another work item. i.e A developer must resolve a Task before QA will be allowed to work on the related Bug. Hi Devin, You can do the same by using BLOCKED field in all work items. If you set BLOCKED as Yes then the work progress has been blocked and you can't proceed with the same. This ensure that the once the other work has been finished in the sense, you can set the BLOCKED as No... Blocked [Task]: Indicates if progress on completing the task has been blocked. If an Issue work item has been opened to track the blocking problem, a link should be made to that work item as well. Blocked [Bug]: Indicates if progress on resolving the ...Show All

• Windows Forms Keep Modal Form in Focus and Prevent

  I have a Parent form (FORM 1) that opens a child form (FORM 2) via .ShowDialog. My problem is that the Child form is losing focus too soon and reverting to the Parent form before I can complete my operations. How can I prevent the Parent form from getting focus until I am ready FORM 1: private void toolStripButtonCopyNew_Click(object sender, EventArgs e) { frmAddNewEst f = new frmAddNewEst("Copy"); f.ShowDialog(); //<---calls FORM 2 //if new estimateID was created then load form if (variable.estimateID != null) { ... } } FORM 2: private void saveData() ( if (chkCopyArea.Checked == false && chkCopyHeading.Checked == false) { ...Show All

• Software Development for Windows Vista How do you host WWF 3.0 as a webservice (instead of using ASP.NET as a host)?

  Tom/Vihang/All WWF Gurus, Can someone please provide an example of how to host WWF 3.0 workflows as a webservice, instead of using IIS (ASP.NET) to call and host XOML only workflows Tom has provided examples of ASP.NET hosting and calling XOML only workflows (using tracking and persistence). I need to do the same with a centralized web service. The labs provided with WWF 3.0 are very similar to WWF 2.0 labs. I cannot find any examples that offer samples on how to host workflow runtime services via a webservice that can be consumed by one or more websites (on one or more webservers). MS suggests using a centralized webservice to host workflow runtime services, instead of using IIS. Unfortunately I did not find any code examples (I ...Show All

• .NET Development wait function

  I want to make a function that execute 2 commands with a interval : doSomething; WaitSomeTime(5 sec); doSomethingOther; I dont know how to pause the function for after the first command for some time. Hi You can use two methods: Thread.Sleep(5000); // in milliseconds, changes the thread to wait state, allows context switch (this means that maybe is not precise) or Thread.SpinWait(5000); //produces a spin on the current thread reducing the chances of context switching Cheers ...Show All

• Software Development for Windows Vista How do I implement a custom activity like the Policy activity.

  Hi, this is my example. public partial class CreditScore : System.Workflow.ComponentModel.Activity { public static DependencyProperty RuleSetReferenceProperty = System.Workflow.ComponentModel.DependencyProperty.Register("RuleSetReference", typeof(RuleSetReference), typeof(CreditScore), new PropertyMetadata(DependencyPropertyOptions.Metadata)); [Description("Set up rules for scoring prospect.")] [Category("Prospect")] [Browsable(true)] [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)] public RuleSetReference RuleSetReference { get { return ((RuleSetReference )(base.GetValue(RuleSetReferenceProperty))); } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Setting project up to be cross platform

  Hello Any advice on what's the best practice for setting up your game to run on both PC and Xbox Even better if there could be an included example of this. I'd like to develop my game on the PC and only running the 360 version periodically. In the past I've set up seperate builds so I'd have a release\debug versions for PC, PS2 and Xbox1. I've seen posts mentioning creating one solution with two projects in and then adding the source to the other project as a link. I have my project like this but I find I'm having to add any new source files twice, once to the PC version and once to the 360 version. The same goes for any data I decide to add. This doesn't seem the best way of dealing with it so has anybody come acros ...Show All

• Visual Studio Tools for Office Cache or serialize a typed datarow

  Hi Maarten, How are you I have tried the code above and it works. My last problem: Is there a way to cache/serialize a typed datarow It keeps giving me an error saying that it cannot be serialized as it (the typed row) does not have a parameterless constructor. This would complete my solution. I just don't know how I can fool it into passing a typed row (PatientRow) when I execute the SerializeCachedItem command. Any ideas Thanks again for all your help. I really appreciate it. P.S.: What I have done is build a Class Library and add a typed Dataset to it. This library is then referenced by both the VSTO/Word Document project as well as my other project which actually allows you to choose a patient from a Grid and serialize/cac ...Show All

• Visual C++ Errors, Help!!!

  When I try to include string like: #include <string> I always got following errors: E:\MicrosoftVisualStudio8\VC\include\cstdio(37) : error C2039: 'Unsafe_sprintf' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\include\cstdio(37) : error C2873: 'Unsafe_sprintf' : symbol cannot be used in a using-declaration E:\MicrosoftVisualStudio8\VC\include\cstring(20) : error C2039: 'Unsafe_strcat' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\include\cstring(20) : error C2873: 'Unsafe_strcat' : symbol cannot be used in a using-declaration E:\MicrosoftVisualStudio8\VC\include\cstring(21) : error C2039: 'Unsafe_strcpy' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\i ...Show All

• .NET Development Querying DHCP information from Windows DHCP Database

  Hi all, Is it possible using WMI, to query the DHCP info wherein I can get my DHCP Server's Address Leases,Reservations,Hostnames,Mac Address . The DHCP GUI is able to display it, so, is there any way I can get this information in C# using System.Management namespace . Thanks. I had a question regarding querying DHCP Database using Microsoft API's in c++. I am not able to use MAC Address to query information about a client using DHCP Server. Has anyone tried this yet. ...Show All

• SQL Server Filtering data

  I need to filter data. In dataset/ Filter tab, I have entered: Expression: =Fields!PRACTICE_ID.Value Operator: = Value: 20 and get this error: The comparison failed. Check the data type returned by filter expression. Practice_id has int data type. How else can I check the data type returned by filter expression I tried to filter on table level the same way, and get the same error. Could anybody help, please, to make it work Thank you gndsp I had the same error and strange as it may seem, I found that explitly casting the LHS to a string fixed the issue. Try changing your expression to: =CStr(Fields!PRACTICE_ID.Value) ...Show All

• Visual Studio Express Editions Control Download and Upload

  I want to develop an application which enable the user to control download and upload feature. The question is 'How to control FTP ports, and how to disable downloading and uploading in Windows using VB.NET ' this is a fantastic and easy way to download files... however is there any way of attaching a progress bar or holding the program until the download is succesful then show a msgbox ...Show All

• Software Development for Windows Vista Unable to create folder in C:\Windows\WinSXS in Vista OS

  Hi, I was checking compatibility of one of my MFC application in Vista OS. Usually if the MFC shared dlls are not present, i used to copy them in WinSXS under folder with the required folder name like x86_Microsoft.VC80.xxxx. (Installing VC++ Redist also didnt work in my case.) And this would make the application work perfectly. When i tried to do the same thing in Vista OS, it failed to create the folder. I removed the read only attributes and tried again but in vain. The error i am getting is "User didnt have enough permission to perform this task" but I logged in as Administrator. I tried to change the security attibutes of Administrator but could not find the Users under Computer Management. Is there any solution ...Show All

• Visual C# help with treeview

  hi all. in my c#2005 winforms application i must load a treeview. my table is very simple,only 2 columns, 1 for the description and 1 for the hirarchy e.g - MyFatherA 1 MySon1 1.1 MySon2 1.2 MyFatherB 2 MySon3 2.1 whats the best and fastest way to load my treeview i gave you the exact structure in my first post, but - here it is again: the tablw has 2 columns: column1 - description , column2 - hirarchy e.g Desc Hirarchy FatherA 1 SonA 1.1 SonB 1.2 FatherB 2 etc etc.... ...Show All