PatrickCairns's Q&A profile

• SQL Server How to Hide childless members

  Hello, I have a dimension with members that dont have childs, how can i hide those members. Thank you If you are running Analysis Services 2005 you have a "Hide member if" property on the hierarchy in BI-Developer Studio. Mark the level in the hierarchy and check the properties. In Analysis Services 2000 you will find the same property in the dimension. Open the dimension editor and check the advanced tab. HTH Thomas Ivarsson ...Show All

• Visual Studio Express Editions database proble ...!!!

  i am trying to insert data in database through windows form this is my simple code for which i am trying to just enter in database..... when i insert the data in text boxes and click save, it saves itself and when i view on other form the data is present, but the problem is when i try to view the data in the database it doesnt exist..... can some one help me in this... this is my code:- hi, i assume you have created the dataset using the wizard,i guess the problem in nameing, i assumed you have those names (table1, column1 ... etc) try to rewrite this code using your own names and see what intellisence will suggest also instead of this part dr["column1"] , you can type it like that (dr.Column1 = textb ...Show All

• Visual Studio Team System New TFS VersionTree addin

  All, I just wanted to let people know that a new TFS version tree addin for Visual Studio is available from the wesite below http://www.cupithome.com/foundationtree/home.html Please feel free to download and try it out. Jem Jem, The screencaps from your site look great. I downloaded v1.1 and installed it, but I am also getting the "Invalid License Information" found message in the license dialog. This is my first installed version, so there is not collision between this version and v1.0. I'm really looking forward to using this. - Steve ...Show All

• Visual Studio Team System pROBLEM TEST?NG WEB PROJECTS

  I have a simple problem etsting web projects for example I wanna be sure that the color of the button must be red.How do I test that PS:I could not find an a way to add the web project assembly to a test project even thogh did publish the dlls to a folder and generated the dlls.The objects are mostly private. Hi, All you need to do, is go the recorded web test and right click it and select Add Validation rule. Once you did that you can select how to apply the rule: search text, search field, Regx and ext. There is nothing more to it. guy kolbis ...Show All

• SQL Server sql beginner - saving views to a file

  is there anyway to automatically save a view to a file at a scheduled time Thank you for any help or pointing me in the right direction. Additionally, in 2005, you can even use a query like: select object_definition(object_id) + char(13) + char(10) + 'GO' from sys.views to get all of the view definitions. ...Show All

• .NET Development A potentially dangerous Request.Form value was detected from the client

  We have a DOT.NET app that we paste info into. Sometimes the text contains characters which seem to offend dot.net. So the application breaks. How we intecept these breaks and then decide for ourselves if the content is really "potentially dangerous" or not The same string even breaks this "post a new message". It is not very useful to create an new thread for each tiny question because this leads to the following: As suggested I searched at this forum for "ValidateRequest CustomValidator" and found 2429 items. If I search with AND then only 5 items are found but not including the answer of my simple question ;-) Maybe it's just a regular expression Why is your answer mared as "helpful". It ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need HELP reading a sprite file!

  I've got an old game from 1996, it's really simple. Has great sprites I want to pop into an XNA project, but I'm unsure how to read the file because it's in a strange format. The file extension is .AR I know the .AR files contain multiple frames of sprite animation, and you can see the internal sprite names with a hex editor. I was thinking maybe it's a unix archive but I doubt it. Anyway, how do you recommend I read these Thanks, Glenn. I did actually send an email to the project manager for the game, we'll see if I get a response. In the meantime, I think I can video capture the animations I want and make my own sprites. Are there any design patterns for sprite animation The XNA kit prob ...Show All

• Software Development for Windows Vista WPF in IFrame hosted in vista sidebar gadget black screen problem

  I am having problems when I am trying to host a XAML page in vista sidebar. The page loads fine in IE, but when I try to load it in vista sidebar, a black background is shown. When I move the mouse over a button placed on the XAML page, the black surface flickers and I can see the button through the flicker. The XAML source (test.xaml): <Page xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation "     xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml "     Title="Page1" Width="100">     <Button Height="50" HorizontalAlignment="Left" Name="button1" VerticalAlignment="Top" Width="50">foo</Button> </Page> The HTML source I am using for the gadget (H ...Show All

• Visual Studio Team System Error Message : when tried to run a Project

  Hi I have created a Test Project which contains a set of 5 test script...i am trying to run this from my d:\ ... i get a Error Message, as follows "Warning: Test Run deployment issue: Failed to get the file for deployment item 'D:\Visual Studio Projects\FAPay_Sanity\TestProject1\bin\FAPay_Sanity.exe': System.IO.FileNotFoundException: Could not find file 'D:\Visual Studio Projects\FAPay_Sanity\TestProject1\bin\FAPay_Sanity.exe'. " yesterday when i loaded it into my ' d:\ ' i was able to execute this ..but now next day i am unable to do so ..can someone ..respond to my problem thanks Abijith Hi, 1.The project was moved from one folder to other and it was made sure that all the files we ...Show All

• Visual C# Keyboard Input

  I am working on a 2D game. I am wondering how to use the keyboard arrow keys to move a sprite around. By the way they are sprites from files. Error 1 The type or namespace name 'KeyEventArgs' could not be found (are you missing a using directive or an assembly reference ) is the error I got. I'm not sure why am I supposed declare or assign it earlier on ...Show All

• Visual Studio Express Editions How to use the BackGroundWorker??

  I have an application that pulls data out of a database based off search criteria that is set in a form. What I would like to do is have a backgroundworker setup (or something else that will do the following) that allows for more then one search to be done at a time. for instance.... I want to pull all the names of people that have a name starting with "j" and I start that search and the data starts to pour in. Then as that data pours in I want to start another search with the same form of names that start with "t" but I dont want to interupt the first search and I dont want to have to wait for it to finish. In my research I believe a BackgroundWorker is the object that can handle this so what I have done is setup a BackgroundWor ...Show All

• Software Development for Windows Vista INSTALLATION ERROR

  Content of log files, [07/24/06,14:20:30] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [07/24/06,14:20:49] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0 - was not attempted to be installed. Having the same/similar problem on multiple machines moveing from different versions of CTP's after running the uninstall tool. One computer is working but it did not have previous CTP on it. I don't think this works yet. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Buttermilk Game Engine / Gui Engine

  I've submitted for a project at CodePlex. I've officially named it the Buttermilk Game Engine! The GUI portion is named the Buttermilk Gui Engine. Both are acronymed BGE, which is the same as the initials in my name. Pretty clever eh  ;) Hehehe... I typed up the current features list like so - Buttermilk is the game engine I'm building for the 2D XNA game "Rogue Bishop". It's a very easy to use 2D engine which additionally supports 3D objects in the 2D scene graph. It currently includes the beginnings of an advanced but simple to use dynamically skinned GUI system. The GUI system is completely separated from the 2D game engine in its own project module, and can be used in any XNA application, 2D or 3D. Current fe ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Undefined errorcode from D3DXGetImageInfoFromFile

  At the moment i'm programming a 2d graphical engine with directX9, but when i try to run the function D3DXGetImageInfoFromFile((LPCWSTR) filename, &imginfo); it gives back an undefined error code, i'm using the directx october 2005 sdk with the latest version of the directx runtimes. Full engine GraphEngine.h: #pragma once class GraphEngine; #include <D3d9.h> #include <Windows.h> #include "GraphResource.h" class GraphEngine { public : IDirect3D9 *D3D; IDirect3DDevice9 *D3DDevice; IDirect3DSurface9 *D3DScreen; GraphEngine(HWND hWnd); ~GraphEngine( void ); void drawImage(GraphResource *img, int X, int Y); void RefreshScreen(); }; GraphEngine.cpp: ...Show All

• SQL Server Help with Distinct SQL Statement

  I'm trying to return a select statement with distinct values. I have 3 tables: Documents, DocumentAuthors and the linking table DocumentAuthorsRel. Since a document can have multiple authors, the DocumentAuthorsRel table holds the DocumentID and DocumentAuthorID values. I simply want to run a query which displays a list of all the document titles (no document title should be repeated, i only want to show the title once, distinct) held in the documents table, and with the document title, show the last names of a documents author(s). This is the statement Im using which is returning duplicated document titles (as a result of a document having multiple authors - found in the DocumentAuthorsRel table) SELECT Documents.DocumentID ...Show All