Han Qiao's Q&A profile

• SQL Server Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• Windows Forms How to change a sql string "on the fly"

  I am using vb.net 2.0 visual studio professionel. In my dataset i have a sql command that look like this: SELECT jumboId, nr, navn, tekst, aar, dato, pic FROM tblJumbo ORDER BY nr created with the TableAdaptor configuration wizard. I wonder, is it possible to change that string, or add a new one, when the program is running It is called like this: .TblJumboTableAdapter.Fill(.JumboDataSet.tblJumbo) If i want to change the select command to: SELECT jumboId, nr, navn, tekst, aar, dato, pic FROM tblJumbo WHERE nr = 2 ORDER BY nr (This is only a simplified eksample, the real one is much more complicated). The string is depending of the users choise. Anybody know how to do this Maybe i am blind, i just can seem to ...Show All

• Visual Studio Team System Managing permissions

  Is there a way to restrict a user's ability to create, edit and delete labels or branches What I want to do is to have only certain users to have permission to manage labels and branches. Can this be done As mentioned, we don't have a separate permission for branches. They're treated like ordinary files. Depending on your intent, it may be possible to prevent branching by denying permission on the root directory and only granting it within existing branches, like Chandru suggested . ...Show All

• Visual Basic Service Pack for vb?

  Hi all, I read a lot of comment these last day about a bug in VB Compiler (HB8013141e). Actualy, my project (and my work) are affected by this bug. A fis is released, but i'm unable to get it (i'm not manager in my society), but a patch is anounced in Vusuas Studio SP1. This SP1 is announced for this summer (probably september... ) Is it already out if not, when (estimate) can we get it It's realy difficult to work without this patch / sp and at this moment, a migration process is studying ...Show All

• Software Development for Windows Vista (URGENT)Problem while EXECUTING CUSTOM ACTIVITIES in State Machine XOML WF

  Hi Gurus, Im facing a problem like after putting custom activities inside a Xoml State Machine Workflow,the method in the interface i set to call is not working! The scenario is like,i hav a statemachine Xoml having a StateInitialisation activity which contains a custom activity of base class Callexternalmethod activity which has to call the method LaunchWorkflow in another library LaunchWF having the interface and implementation of that method.This Launchworkflow method wil inturn create another sequential workflow containing other custom activities. But the control is not passing to the method and its directly going to the next eventdriven activity without executing the method set in the stateinitialization activity! I tried ...Show All

• Visual Studio Team System Custom Test Type: How to Debug?

  Hi , I am currently looking into learning about extenting VSTS Test support by doing my own custom test type. I am playing with the sample which ships with the SDK. I have compiled and installed the sample. Now my question is how do i go about debugging the sample so as to understand the flow With a lack of proper documentation in SDK, i am really banking on understanding this from the sample. So if someone can give me tips how to setup my debugging env to be able to debug the custom test type package, i would be grateful. Thanks Vivek Yep the part i was missing was the experimental hive. I was trying to debug under production hive and that was what was causing the problem. In short deploy you ...Show All

• Microsoft ISV Community Center Forums Select query returns non-existing data

  Hello everybody, I'm trying to match entries in a table up against each other based on a number of criteria (Quantity, Date). Three types of entries exist: Those from source 1, 2, and 3. I'm trying to match data from source 1 with data from source 2 and 3. Some is identical, some is not. In a VBA Script I first select every entry from source 1 (indicated by the field "Datasource"). I then run a While loop. For each entry I run a second select query on the fields I want to match (Quantity, Date). It works OK, ie. as expected, in some cases. In other cases, the quantity is completely off - it's as if Access just invents some random quantity instead of using the one from select query one (the one with source 1 data). What on Earth is w ...Show All

• Visual Studio VSS deploy causes client sessions on web server to terminate

  Each time I do a Web-->Deploy from Sourcesafe to the web server running the application, all application client sessions on the web server are stopped. Is there are way to Deploy without stopping active sessions on the server VSS just copying the files to the location you specify. Perhaps when you overwrite some binaries or a file that running web app needs, IIS restarts this web app.   Does it happen all the time (even if only one .htm file is changed) ...Show All

• Community Chat Windows Embedded in Kitchen Appliances - Possible?

  Hi. I'm a fan of Windows and I've grown fond of Microsoft for many years. I mean--I've used Visual Studio, Microsoft Office, Windows Vista, UTStarcom PPC6700 (Alltel Wireless), Microsoft Exchange Server (for learning purposes with Windows Server 2003), etc. and I wanted to go beyond computers and smartphone/Pocket PC. Is it possible to embed Windows in kitchen appliances (please no flaming/bashing; thanks) like oven, coffee maker, microwaves, toaster, etc. I mean--I'm serious about programming a C# application to check for status and give me visual feedback from those appliances! It'd be so cool that I could tell an oven to cook my pizza at 350 degrees for 20 minutes and give me the feedback to my Pocket PC SmartPhone device! Plus, w ...Show All

• Visual Studio 2008 (Pre-release) System.Data.Dlinq.DataQuery Issue

  In the following code, first I created the query in Linq format and let the Linq framework to create the Expression Tree and then I created the Expression Tree on my own try to achieve the same thing. It throws an exception at the following statement. Expression where = QueryExpression .Where(q.Expression,predicate); // Exception occured Also I observed that, when the Linq framework assigns System.Data.Dlinq.DataQuery type to Var Cust, where as when I create thru IQueryable<Customer> q assigns System.Data.Dlinq.Table<Customer> type. I try to cast q to DataQuery type. It's inaccessible. Is there any plan to expose System.Data.Dlinq.DataQuery type and let the user to build their own expression tree // Use a stand ...Show All

• Windows Forms passing variables to NotifyIcon Text

  hi all, i've got a little timer program that i'm working on. everything is working fine, just need a little help with some refinement issues... question #1: bascially i have some variables minRemain & secRemain that show via timer tick how much time is remaining until alarm will be sounded. i have a NotifyIcon set and the program minimizes to the system tray (whatever that's called- lower right of windows screen). you double click the icon to bring back the program yada yada... when the program in in the system tray and you hover over the icon is displays some text (the program name) as i've defined in the NotifyIcon Text property. so here's my question... how can i pass/display some variables in that hover ...Show All

• SQL Server Using Except function without aggregation (ssas 2005)

  Hello, I recently got help in getting the except function to work... Here is the solution provided by Deepak. (The requirement is to calcuate active head count of employees excluding two departments) SUM( Except([dimensionEmployee].[Employee Department].[All].Children, { [dimensionEmployee].[Employee Department].&[Services], [dimensionEmployee].[Employee Department].&[Leadership] }), [Measures].[Active Employee Head Count]) Now, how do I get the except function to work "without" the aggregation Any help is greatly appreciated.. Thanks, Ganesh Ganesh, I'm glad you were able to get your problem resolved, and thanks for sharing the solution. It's worth mentioning that this app ...Show All

• Visual Studio Team System Get latest version vs get specific version

  Im getting some feedback from users who have complained that they are not seeing the latest version of source files or in some cases if a person has created a new file and checked it in to source control it cannot be seen unless a Get Specific Version (force get) is issued. Im just wondering if this is how Get latest version and Get specific version are supposed to work and how should users approach bringing down files especially when they start their day in a shared environement. Thanks Aaron I have to say that it's very scary that this basic functionality is missing!! We have ALOT of weird things happen with this product constantly. To not have new files added visible to others is disturbing to sa ...Show All

• Visual Studio Adding a menu to the Visual Studio ?

  I wanted to add a new menu item to the visual studio 2005. i am new to in Visual Studio extention development, anyone could help me out See my article: HOWTO: Adding buttons, commandbars and toolbars to Visual Studio .NET from an add-in. at: http://www.mztools.com/resources_vsnet_addins.htm ...Show All

• Windows Forms Using Window Messages

  Hello, I wonder if it is possible to use Window Messages in C# If so, would it be a good thing to use Window Messages to communicate between different Threads Henk >I found some article about windows messages, hope it help you >http://blogs.msdn.com/csharpfaq/archive/2004/10/20/245412.aspx (1) >http://www.codeproject.com/csharp/cswindowsmessages.asp (2) I'm sorry to say but (1) only talks about filters and (2) only shows a list of Window messages >for thread communication, see this project. Looks good but I stuck with the IMailBox which I don't know how to make my compiler recognize it. I (newbie) am missing some essential info. R ...Show All