Rene Rijpstra's Q&A profile

• SQL Server How to use sum and count aggregate functions with xml data type in SQL Server 2005

  Hi: I have xml in sql server 2005 beta2 that is stored as an xml data type and I'm trying to run some aggregate functions like count and sum, but I don't know how to do it.  The elements are numeric values, but 'sum' and also 'count' return errors.  I have included the error message and the sp below.  Any ideas how to use sum and count correctly Thanks, Paul -------------------------------------------------------------------- ...Show All

• Visual C# How to check if an application or program is running

  Hi all, I want to write a code that checks an application server is running. I have an application server runs all the time. sometimes the application server is off from many reasons. I want to write an application' maybe a web service that checks if the application is live or not. any ideas, please help. Best regards... I've used the following technique in C#: . Create a mutex using the name of the application, ...Show All

• Visual Studio Express Editions Visual Studio installed templates missing

  I'm trying to get started with C# express beta 2 and the install seems to work fine but when I select 'new project' it only shows 'Class library', 'Empty project', and 'Screen saver starter kit'.  In the how-to's it shows quite a few more including 'Windows application', which is the one I want.  Am I missing something I've searcned and searched, but can't find anything I have done wrong. Hi, it's poss ...Show All

• Visual C# byte question

  ok i understnad that in a byte type cant be stored a value between 1 and 255 or more i dont really know exactly.. but a byte should bet stored as 1001011100100111100 or thats the machine code You're showing a binary number which is far too big to hold a byte. The representation of a number is totally different to what it contains, in that you can represent the same number many ways, and the value is the same. Why are you asking this ...Show All

• Visual C# Is it possible to use .NET controls to VB6.

  Hi, Please any one tell me is it possible to use .NET controls and libraries [ created by C# ] to VB6. If so can you tell me the way and some useful existing articles regarding this query. Thanks, Yes it is possible to call .NET assemblies from VB 6.0. You need to create a COM interface to .NET assemblies by using RegAsm and generate a type library file. Refer this MSDN article for a detailed explanation http://support.microsoft.c ...Show All

• Visual Studio Team System COOKBOOK for TFS server installation - please

  Hi I've been trying to install TFS server beta 3 refresh for more than a week - it feels more like a month... Has anyone written down the complete cookbook for a successful installation If so pls. forward that, because this seems very difficult to do correctly. The very best would be a cookbook that starts off with a 'clean' virtual server, and leads me by the hand through this labyrint of strange options and issues. Thanx jcjj pls. MS do sup ...Show All

• Software Development for Windows Vista Start a workflow dynamically from a xoml file

  I have the following situation. I have one workflow (state based) running. I need this workflow to dynamically invoke another workflow at runtime from a xoml file. I wrote my own custom invoke workflow activity based on the one here . I want to create the xoml workflow with workflowRuntime.CreateWorkflow(xmlReader) however here is where problem arises as I can't have multiple workflowRuntimes, and I don't have access to the orignial one as the s ...Show All

• SQL Server Migrating Maintenance Plans problem

  Hi There I recently just migrated 2 maintenance plans in SS2005. I had a few problems, firstly as soon as they migrated and i saw that they were now under normal maintenance plans i deleted the legacy plans and jobs. First problem when i save the new maintenance plans i get errors, like null parameter (these were normal SS2000 maintenance plans nothing fancy). Secondly the legacy plans still appear even though i deleted them successf ...Show All

• Software Development for Windows Vista How to make a design view of a workflow execution easily ?

  Hi all, i have to make a design view of a sequential workflow execution. The user have to see the executed activities, those who are currently run, and those who are not reached. Is there a sample of this I dont see an answer in this forum and in the HOL. Thank you. (sorry for my poor english.) Hi, There is a sample installed with Beta1 entitled "Workflow Monitor."  This should be exactly what you are looki ...Show All

• Visual Studio Get Latest Version (Recursive) problem

  Hope you guys can help with this. We are running VSS 6.0d (build 9848) and VS2003 We have 11 projects in 1 solution. When I click Get Latest Version (Recursive) on the solution it appears as if VS2003 is refreshing all the projects.  When it finishes, I build the solution and usually run into a few build errors.  These errors come from the fact that the 1 or more of the files that are being built are not actually the latest versions, s ...Show All

• Visual C++ Reference to class library lost

  I have a simple VC++ (CLR Windows Forms Application) which simply displays a form with an Exit button. This compiles and works fine. I added a C++ (CLR Class Library) project with a simple class: // DummyLib.h #pragma once using namespace System; namespace DummyLib { public ref class DoNothing { public : int Value() { return 123 ; } }; } } In my Windows forms project I add a ref ...Show All

• Visual Studio "Configuration" property not working when building a solution?

  Hi everybody! I'm having some problems building a simple C++ console application using MSBuild (VS2005 Beta 2) From what I've seen I should be able to do this: MSBuild HelloWorld.sln /t:Rebuild /p:Configuration=Debug To build my project for Debug only. However: The above command results in both the Release and Debug configurations being built, it seems like the Configuration property is ignored Turning on diagnostic logging gives me the results ...Show All

• Visual Studio Tools for Office strange vsto security issue

  I have a strange security issue using asp.net 2.0 and vsto. I have a web form that launches an excel file with .net code in it. This requires certain .net security settings to be set. The site is at http://localhost/app . So we set FullTrust for http://localhost/app/ *. This does not work however and throws the following exception: Request for permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0,C ...Show All

• .NET Development Remove a table from xml file using C#

  Hi, How can i remove a table from an xml file if the date is old using C# This is how the xml file looks like: <root> <table> <id> 0 </id> <date> 20060404 </date> </table> <table> <id> 1 </id> <date> 20060822 </date> </table> <table> <id> 2 </id> <date> 20060904 </date> </table> </root> What im trying ...Show All

• Windows Forms Partially ReadOnly datagrid?

  Hi everyone, I'm not sure if what I'm asking is possible. Here's the scenario. I have two datagrids and would like to move rows between them. Each datagrid is bound to a datatable which has a boolean column for the selected state of the row.&nb ...Show All