Tim Xue's Q&A profile

• SQL Server Combinations

  Hi, I have the table: exexposureRoute: with columns caseId, exRouteID 200 70 300 71 200 72 200 73 .. .. Route table: exRoteID name 70 a 71 b 72 c 73 d .. .. In my result set i want like this: Route CaseCount a 78 b 89 c 90 d 345 a/b 9 a/c 8 a/d 9 a/b/c 2 Otherroute comb 98 in the above a/b means i want the casecount for which cases both a and b exists. For one case there mey be possibilty of more than one route. How to write the query to get those routes combinations case counts. Thnaks in advance Mahima: I put together a mock-up of your tables and started piecing together a query that might work; however, I am still not sure of the status of whether or not the two 'B/C' records should be included.&nb ...Show All

• Windows Forms Setup Error - Failed to load resources from resource file.

  I am getting following error at random places in my application. "Setup error - Failed to load resources from resource file. Please check your Setup" Application closes if I click on OK button on the message box. Also, it does not happen on development machine, it only happens on client PCs. The client PCs has .NET Framework 1.1 Please help me. If you have a solution or recommendation then please reply. Regards, bmgohil It's taken me a long time ... but I was finally able to identify the problem .... it was a bad memory module. Through trial and error in swapping out memory modules ... I determined that 1 of 4 memory modules was bad. It caused random applications to close without warning, at random tim ...Show All

• Software Development for Windows Vista Is there a tool to modify the file version resource in kernel mode drivers?

  For bug tracking purposes, I want to fix the product version on the level of the last change, while file version should reflect the version number of the release. To avoid recompilation I would like to have a tool to modify the file version w/o breaking the driver. Does anybody know such a tool Strix We don't know of such a tool. Using this type of tool would invalidate the digital signature anyways. If you want to associate bugs with specific versions, update the version of the file in the .rc file before compiling it, not after. A proper build system would update this revision number on a regular basis (at a minimum immediately prior to and after shipping a version). . ...Show All

• Visual C# Types and Variables

  Is it possible to make a Type into a Variable When i select the item i want to navigate with nothing happens Any Ideas p.s I'm Using a tabs system pps this is part of a favourites system. ...Show All

• Visual Studio Express Editions ListBox

  I am creating a movie database program and am trying to create it so that the movie titles are displayed in a listbox on the right and the rest of the info in boxes on the left. I connected up the listbox to a databinding source and selected the displayMember and valueMember accordingly, everything worked. But when I went to add movie titles in the database in a field on the left, save, then go to another movie title, the data was changed to a number. Can anyone help the listbox and the rest of the fields retain the info. I am a complete newbie, so could you explain what to do step-by-step. Thankyou for all your help! Elliott the table is a datatable from my database. The datatable is called "Movie" And belongs to ...Show All

• SQL Server Script Question: Getting data from SQL Server

  I am trying to fill a DataTable with values from SQL server in SSIS. I just can't get the hang of the connections inside SSIS. I tried taking the example in BOL for "Script component [Integration Services], source components" and adapting to my needs but sqlReader doesn't seem to have the ability to use fill to populate a DataTable - so I tried changing to sqlAdapter and can't get it to work. (I get error about connection not being closed or object reference not set to instance of object) Thanks in advance for all the help... Imports System Imports System.Data Imports System.Math Imports System.Data.SqlClient Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.W ...Show All

• Visual Studio Express Editions Can I hide a VB Shell command like this...

  Hi, I'm using the code below which is showing me a wscript window in which the command is performed... Can I make this command completely invisible Would be awesome! Thanks! Dim retval As Double retval = Shell("schtasks /run /tn.....blabla", 1) ...Show All

• .NET Development Can't Update, Repair, or Uninstall Microsoft .NET Framework 2.0.

  Hello. I have recently found a security patch for my Microsoft .NET Framework, V 2.0. I needed the framework installed for my ATI Driver update to work. However, Every time I tried to install the patch, it failed. I tried repairing the framework, but that didn't work. Neither did uninstalling it. Uninstalling and Repairing yeilded the following message: "The following error occured during setup: Patch Package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package." I downloaded and installed the framework from ATI's site. My system is a Windows XP, and I would like some help... Please... Thanks for any ...Show All

• Software Development for Windows Vista HBMMENU_CALLBACK in vista

  The following code always failed in Windows Vista (Beta 2 Build 5384). It is deemed a completely legimite code and works fine in Windows 2000, XP. Is this a known bug or HBMMENU_CALLBACK is not supported anymore Debugger shows that USER32!ValidateMENUITEMINFO sets the last error code as: LastErrorValue: (Win32) 0x57 (87) - The parameter is incorrect. MENUITEMINFO menuItemInfo = {0}; menuItemInfo.cbSize = sizeof(MENUITEMINFO); menuItemInfo.fMask = MIIM_BITMAP; menuItemInfo.hbmpItem = HBMMENU_CALLBACK; ATLVERIFY( SetMenuItemInfo(hMenu, ID_FILE_NEW, FALSE, &menuItemInfo) ); Any leads or information would be appreciated. Thanks In Vista July CTP Build 5472, it still fails. Seems like it ha ...Show All

• SQL Server Connection

  iam using an execute sql task ineed the connection to be daynamic ,changed at run time .. how can i do that Depending on your scenario you may have more than one option. Serach in package configurations or "http://msdn2.microsoft.com/en-us/library/ms141682.aspx">http://msdn2.microsoft.com/en-us/library/ms141682.aspx "http://msdn2.microsoft.com/en-us/library/ms141232.aspx">http://msdn2.microsoft.com/en-us/library/ms141232.aspx ...Show All

• SQL Server Aggregate non-filtered members of hierarchy

  Is there a way to create a calculated field that aggregates all members (including hidden ones or maybe non filtered) of a specific level in a dimensions hierarchy ...Show All

• .NET Development Query an online database?

  Ok I am trying to write a program that will grab a list of all the AddOns that I have installed for World of Warcraft and then it will query at least one of the UI websites to see if a newer version is out and if so download it and wait for me to install it. My question is how can I get the information about the addon from the net I have read about Web Services a little bit and after search 2 out of the 3 I have found no documentation about a web service at all. Is there another route I can take Ok I will research that, but I have one more question. the three websites I am trying to use are wowinterface.com, ui.worldofwar.net, and cursegaming. So how can I find out if their website supports the XML feed w ...Show All

• Windows Forms ClickOnce Fails with "Value does not fall within the expected range."

  I have a ClickOnce-deployed application installed in offline mode across a range of Windows 2000/XP machines on my network. I now receive an 'Application cannot be started. Contact the application vendor.' error message when I attempt to run the application on my development machine. (It works still on the production machines.) I've run mage -cc, and renamed the '2.0' directory to '2.0x' to ignore its presence. Add/Remove Programs still shows it, and clicking Change/Remove pops up a window for a moment, but otherwise does nothing apparent. I've changed the installation path to be a network path instead of a website, and it still fails. The following is the error log: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Comm ...Show All

• Visual Studio 2008 (Pre-release) Animating a TextBlock's background

  Is there any restriction in the TextBlock's Background property I get this error when I try an elementary ColorAnimation :- 'Background' property does not point to a DependencyObject in path '(0).(1)'. Any help is appreciated. The same code works fine for a TextBox by the way. Thanks Adam. Yes, it was something like that. I had a gradient brush background, and I was attempting to do a solid color animation. I had assumed the animation would automatically change the control's background brush. Thanks again. ...Show All

• SQL Server SCALL vs XCALL and performance

  What should be considered when changing SCALL to XCALL for all articles in a replicated database Will there be performance implications Anything else Linda You can find out more info on this article. Quick answer is yes, there is a performance implication, SCALL is faster then XCALL because less data is passed. http://msdn2.microsoft.com/en-gb/library/ms152489.aspx Regards, Gary ...Show All