Pure Krome's Q&A profile

• SQL Server Merge Join question

  Hi, All, In the data flow of Intergration Service, my understanding is that the "Merge Join" only does the "join", there is no way to input the "where" clause. If I need to input the the "Where" clause or selection criteria, how should I do it in Integration Service TIA, With other popular ETL tool, in one transformation, you can do both "join" and "where". But in SQL Server 2005 Integration service, you have to use two transformation to finish the task. ...Show All

• Visual Studio 2008 (Pre-release) Accessing invidual objects for a xaml file parsed with XamlLoader.Load()

  I am trying to access objects created by parsing a .xaml file, using XamlLoader.Load(). For example if my .xaml file contains rectangles I'd like to be able to access them and modify a parameter, like their color. Is there a way to obtain a tree-structure of the objects created during the parsing Stream s = File.OpenRead("test.xaml"); Canvas newCanvas = (Canvas)XamlReader.Load(s); s.Close(); foreach(Rectangle r in newCanvas.Children) { r.Color= Blue; } ...Show All

• SQL Server multiselect result changes while add additional dimension to filter?

  Every Query I introduce with multiselect to restrict the my rows works only as long as I do not add a second dimension to the filter fields My Query (derived from Management Studio) - if you run it once like this and once with the comment line enabled the count of columns returned change - what I really did not understand, because only the values should change (different slice) Could anyone explain this to me or point me to a location with detailed explanation (I have checked http://www.mosha.com/msolap/articles/mdxmultiselectcalcs.htm this but it does not hit specially my question) WITH MEMBER [Sales Territory].[Sales Territory Group].[{2120AF0D-0FD5-4B1F-8562-51CCF95CE627}Pivot8Hier164MultiFilter__] AS 'AGGREGATE({ [Sales Ter ...Show All

• Visual Studio 2008 (Pre-release) Does the .NET 3.0 July CTP include ADO.NET 3.0?

  The .NET 3.0 July CTP can be downloaded from here: http://www.microsoft.com/downloads/details.aspx FamilyId=62057A6F-185F-41DB-ABE5-678F6FC388F0&displaylang=en Does this include ADO.NET 3.0 If not, when ADO.NET 3.0 is released, will it be part of a .NET 3.0 CTP ...or a standalone CTP Michael. I think the only reason anyone would have ever thought that ADO.NET vNext was going to be a part of .NET 3.0, was because people assumed C# 3.0 (which is going to be C# vNext now ), and .NET vNext (Which was thought to be .NET 3.0) were all pushed out of their home by WinFX which took the .NET 3.0 name. Pablo - I can't imagine you guys at Microsoft are too happy with this confusion caused either. I know we guys out here in the fi ...Show All

• SQL Server Executing Package From Web Service

  Hi, I'm having another go at attempting to call an SSIS package from a web service. The Web Service is set up on the same server as the sql server and SSIS package deployment. When i attempt to run the pacage from the web service it starts and then inmediately fails. I can see this in both the Integration Service Logs and the event viewer. If i click on the package itself and run it using the DTExecUI, it runs without a problem. No logs are output by the package when called by the web service. Can anyone suggest anything that i could to see if i can diagnose where the problem stems from. Many thanks in advance, Grant Are any exceptions being thrown within the WS code Are you passing IDTSEvents or an im ...Show All

• Visual C++ Order of SetCapture and ReleaseCapture

  Hi All, I've written a custom button which does some special functionality. But from this button, I'm not getting BN_CLICKED event to the parent window. What I could find out is that the order of the SetCapture and ReleaseCapture API has some importance in sending messages to the toplevel or parent window. Following code describes correct code. void ButtonEx::OnLButtonDown( UINT uFlags_i, CPoint Point_i ) { SetCapture(); // Capture the mouse CButton::OnLButtonDown( uFlags_i, Point_i ); ... } void ButtonEx::OnLButtonUp( UINT uFlags_i, CPoint Point_i ) { CButton::OnLButtonUp( uFlags_i, Point_i ); ReleaseCapture(); // Release the mouse capture .... } but if I swap any of the statements for e.g CButton::OnLBu ...Show All

• Smart Device Development Delete myself :)

  Is it possible to flag a file to be deleted next time the system is booting I'm trying to make a .exe file that deletes it self after it has been executed.... If I try to delete my self I get a IOException.... Oystein look at this post: http://www.codeproject.com/file/cpselfdestruct2.asp hope that it will be useful :) Oren ...Show All

• .NET Development Is there a way to Redirect STDOUT/STDERR during AppDomain.ExecuteAssembly like Process.Start's redirection streams

  I'm trying to locate the ability to redirect the stdout/stderr within an AppDomain when making calls to the ExecuteAssembly method similar to the ability to do so with Process.Start's RedirectStandardError/ RedirectStandardOutput Thanks, Ty I too am looking for this ability. Or, similarly, any ability to redirect the stdout/stderr of an assembly without having to start a new process, but by running it in the same process either in a separate domain or not. ...Show All

• Visual Studio Express Editions I cant get the Windows PSDK to work with my Visual C++ Express 2005

  Hello, I have a problem. I have installed Visual C++ 2005 Express, Windows PSDK and the DirectX SDK. I have put all of the folders in Tools>Options>Project Directories. I have changed that .htm file. I still have a problem somewhere though. I am trying to create a basic window with this code: #include <stdafx.h> // include the basic windows header file #include <windows.h> #include <windowsx.h> // the WindowProc function prototype LRESULT CALLBACK WindowProc(HWND hWnd, UINT message, WPARAM wParam, LPARAM lParam); // the entry point for any Windows program int WINAPI WinMain(HINSTANCE hInstance, HINSTANCE hPrevInstance, LPSTR lpCmdLine, ...Show All

• Visual Studio 2008 (Pre-release) Scaling problem in UniformGrid

  I have another problem with scaling in a UniformGrid. When I use the code below the images look fine in their cells but the text in cell 0,0 and even the header of the groupbox is scaled down too much. How can I prevent the scaling of the image to have an effect on the rest of the grid Thanks for your help ;-) < GroupBox Header = " {Binding Path=ItemHeader} " HeaderTemplate = " {StaticResource rightAlignedHeaderTemplate} " > < UniformGrid Rows = " 4 " Columns = " 2 " > < Grid > < Grid.ColumnDefinitions > < ColumnDefinition /> </ Grid.ColumnDefinitions > < Grid.RowDefinitions > < RowDefinition /> </ Grid.RowDe ...Show All

• Visual Studio Express Editions vs express, orcas and vista

  hi I have downloaded VS express (c#) and I am running Vista, can I install Orcas or is this only used with VS full edition thanks Well, I installedC# express on vista, but when I try to install Orcas inside Vista, it says that I need Windows XP service pack 2. Should I install this sp on Vista Thanks. ...Show All

• Visual C# Stored procedures Help in C#

  Hello. I am developing an winform app. in C# express. This App. is working with an Database, reading data from it. My user needs to be able to search for a specific order, name or e-mail address. I thought I could use stored procedures and it works fine when the titem I search for is a primary key. "orderID" in my table is primary key, but not name or e-mail address. when I wtire SQL in SQL writer and test It gets my values just fine but when I run stored procedure whith this sql it returns nothing. Example. this works since orderID is primary key in the table ALTER PROCEDURE dbo.finnOrdre @OrdreID int AS SELECT Ordre.OrdreID, Ordre.Status, Ordre.Referanse, Ordre.Trykkinfo, Ordre.Dato, Ordr ...Show All

• Visual Studio 2008 (Pre-release) could someone help me get started building a service in WCF

  I would like to try out the new services stuff in 3.0 but I am not sure what to download 1. What SDK ( and link) 2. What runtime for 3.0 3. what packages for vs 2005 order would be good too Thats great. Here you will find the installation locations: http://www.netfx3.com/blogs/news_and_announcements/archive/2006/11/06/.NET-Framework-3.0-has-been-released_2100_.aspx Basically, WCF is part of .Net Framework 3.0. You first need to download the runtime (first link on the above page) Then if you are going to do your development in VS, you need to download the extensions for Visual studio (fourth link on the above page) For samples and SDK, the second link. Once you download the SDK you should have access to a ...Show All

• Community Chat Registry cleaners

  Can someone tell me where I can get a free registry cleaner that is compatible with XP Home edition that is as good if not better than Registry Mechanic ...Show All

• Visual Studio Express Editions variable size matrix

  I'd like to have a two-dimension matrix of double whose dimensions (number of rows and columns) are not pre-defined, but can vary following user's requirements... Is that possible How about Private ary(,) As Double Dim x As Integer = 3, y As Integer = 5 ReDim ary(x, y) Is this what you need ...Show All