MU786's Q&A profile

• SQL Server WHERE Clause overwriting SubQuery restrictions

  Hi, I've been experimenting with subqueries in Analysis Services 2005 and have discovered some strange interactions between subqueries and the WHERE clause for an outer query. To start with, it seems that if the subquery SELECT just picks a single member from a hierarchy, and I also choose a different member from the same level in the outer WHERE, then the member from the outer WHERE sort of "overwrites" the restriction. This query: select from [Adventure Works] where [Sales Territory].[Sales Territory].[Sales Territory Group].&[North America] returns the same value as this query: select from ( select {[Sales Territory].[Sales Territory].[Sales Territory Group].&[Europe]} on 0 from [Adventure Works] ) whe ...Show All

• Windows Forms regarding microsoft.office.interop.excel(how to copy a excel sheet single cell content and paste them to cell present in another

  hi, i need to know how we can copy a cell content from one excelbook and paste that to another cell present in another workbook.note : iam having 4 to 5 sheets per workbook so i have to locate the sheet also.... can you give any sample.... Thanks. I found this Microsoft KB article. It's in VB.NET: http://support.microsoft.com/kb/306022 Here's the same thing in C#: http://support.microsoft.com/kb/306023/ ...Show All

• Audio and Video Development Help me about rendering audio from IWMReaderCallback::OnSample using DirectSound

  I need to play the PCM audio date from IWMReaderCallback::OnSample, when I use " waveOutXXX " it can work,but when I try to change volume with " waveOutSetVolume " , system wave volume is changed,this is not what I want . I wish to change the volume of wave date by operation before I play it with " waveOutXXX " , but I can not find the arithmetic, so I changed to use " DirectSound " to play it, the volume can be controled as expected, but even more worse thing happened, when first data block from "OnSample" arrived, I fill it to " DirectSoundBuffer " ( use Stream buffer),and begin to play it, for example: the length of the first data block is 14000, but when I try to fill the seco ...Show All

• Windows Forms Sorting a dataTable by date

  Hello everyone, My problem is that I cannot sort my dataTable by date. I tried to use sorting filters ( with the Select command ) and also using a DataView. But nothing changes. Is there a way to achieve this programmatically Best regards. Here is my code : DataView dataView = dataTable.DefaultView; dataView.Sort = "FolderDate"; // // foreach row from the selected data // foreach (DataRowView dataRow in dataView) { .... } What I mean by "nothing changes.." is that the dataView is not sorted. Thanks anyway ...Show All

• .NET Development XSLT Irregular child order xslt:foreach

  I have a question. I have an XML file which is actually an XML representation of Excel VBA code (but don’t let that out you off!). I am commissioning a program to parse the code into three types of XML element which will be styled in three different colors. If you look at an Excel VBA environment you will see keywords in blue, comments in green and other text in black. I have a fragment of XML thus < xml version = " 1.0 " encoding = " utf-8 " > < vbacodemodule > < line > < keywords > Option Explicit </ keywords > < br /> </ line > < line > < br /> </ line > < line > < ...Show All

• Visual Studio Express Editions Compatibility problem with MSVC++ 6

  Hello! I was using VC++ 6 with the library Allegro, without problems. Then I decided to try the Microsoft Visual C++ 2005 Express Edition, and installed it. After some tweaks, it compiled and ran my program. Perfect! However it doesn't come with MFC, so I had to go back to VC++ 6. However, when I tried to run the program (release or debug), it gave me the message "library file msvcr80d.dll not found, can't run the application". I tried to uninstall Express, nothing. Uninstalled VC++ 6, reinstalled, nothing. Why is the VC++6 trying to use the library from the version 8 Anyway, I went to another computer also with both VC++ 6 and Express Editions. To my surprise, the VC++ 6 said "library file alld42.dll not found, ...Show All

• Smart Device Development How to zip XML?

  My app uses web services to get downloads from a server which returns a chunk of XML. To reduce the volume of data that is transmitted, I'd like to zip the xml packet before it's sent. How do I do it Is there a 3rd party tool I can use Thanks for the help, and have a good weekend everyone :-) Here's an MSDN article on compression using the J# API: http://msdn.microsoft.com/msdnmag/issues/03/06/ZipCompression/default.aspx I generally using #ziplib (which is mentioned in the above article) when I need to explicitly compress data, found here: http://www.icsharpcode.net/OpenSource/SharpZipLib/Default.aspx -- Alex ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWars - can you work around Shader limitations?

  Two days ago I started working on the XNA framework. This is also the first time I've had any dealings with C# or DirectX. I got the first game tutorial working pretty easily, but I couldn't get the SpaceWars starter kit to run properly. Firstly, I had to set AllowMultiSampling to false (this is a known, and widely discussed problem), and also switch to keyboard mode. With this done, the game ran, but I could not see some of the graphics (ships, backdrop & bullets) in either retro or evolved mode. Score and explosions appeared ok. As far as I can tell, this is because the missing graphics are using CompiledEffect shader objects which are loaded from the FX files. My poor graphics card (Nvidia GeForce 440MX) doesn't support any shader ...Show All

• Visual C# LowLevel Keyboard Hook

  Hello- I'm using a low-level keyboard hook for trapping key presses and had two questions: 1. What is the name of the enum value in Keys for the context-menu button 2. Is there a set of flags pre-defined somewhere for the flags member of the low-level keyboard struct Thanks... Ah, I see. It's extremely unlikely that those would be defined anywhere in the .NET Base Class Library, although I'm open to correction on that. I'd just declare them as consts in your code. ...Show All

• Visual Studio Why is VS2005 (pro) taking 1,5 gb of my c: partition before installing

  hi when i want to install visual studio 2005 professional, the setup requires 1.5 gb of my c:/ partition. Why is this And is there a remedy against it i read the readme and it stated that it needs 2 gigs on the non primary drive and 1 gig on the primary drive so i thought there is no way of bypasing the "primary drive" instalation, and so far i cant even instal visual studio 2005 it wont even go into instalation, it states that it had some problems and it needs to close. ...Show All

• Silverlight (formerly WPF/E) WPF/E & accessibility?

  Hi, I need detailed information about WPF/E and support for accessibility standards. Thanks, Mathias For our 1.0 release we will be exposing an accessibility system for the root plug-in (e.g. root canvas) to provide some alternative text. This will help with smaller scale Silverlight content such as an ad. More complex applications that create concepts such as "buttons" or other "control" type UIs will not have accessibility support in 1.0 but will in 1.1 when we create a control framework. In 1.0 we don't even have the concept of focus or tabbing to elements (such as the element you styled to look like a "button"). In 1.1. we will. We also support close captioning usin ...Show All

• Windows Forms Delete menustrip item

  How can I delete a particulat item from main MenuStrip. I would like to restrict access to particular area's application, doing that base on menu items available base on user's level. thanks in advance for your help, Edward I think you can also set the Available property to remove the item from the list without having to remove it from the Items collection as in: myMenuItem.Available = false; ...Show All

• Visual C# Querying AD using System.DirectoryServices

  I am new to querying AD and could use some help. My requirements are to get all email addresses, email aliases, and email domains from AD. Does anyone have a sample of this Thanks, Derek Do these scripts need to run on the Domain Controller Locally Or can you connect remotely using the LDAP connection format thingy ma' jig LOL... ...Show All

• Smart Device Development RAS & WM 5.0

  Hello, I'm using the RAS API in one project in Windwos Mobile 2003 and all works fine. Now I have to migrate this project to WM 5.0, but connections with RAS don't work. Is there a way to make them work Any suggestions For code compatibility reasons with other Windows versions I cannot use the connection manager API for this project. Regards Hi Alex, When connecting using the RASdial API with a Windows Mobile 5.0 device (using an Symbol MC9090) the device connects but the established connection is not usable. Accessing a our server (or just using IE for browsing) a "Cannot Connect. End the current phone call, and try again" message bubble is shown and no data is transferred. I download and teste ...Show All

• Visual C++ Calling .Net delegate from C++/CLR

  Hi, I am writing a managed wrapper arount native C++ code and I need to call C# delegates. The way I do it is to call the Marshal::GetFunctionPointerForDelegate function and get a pointer to the managed method, which I can call later on. This is with VS2005, my question is how to get the pointer with VS2003 and .Net v1.1 since the Marshal::GetFunctionPointerForDelegate function is available only under .Net v2.0 Thanks in advance. With great difficulty, apparently. It looks like you need to create two adapter classes--the first of which will marshal the .NET side of things (delegates), and a second class which will thunk the native side (function pointers). This article (from Nish) shows how to use the callback from EnumWindows. ...Show All