Helen999888's Q&A profile

• SQL Server AS2005. Distinct count meausure + aggregate seems to be a bug.

  Look at following Query -- the first query with member [Promotion].[Promotion Category].[No Discount und Reseller] as aggregate ({[Promotion].[Promotion Category].&[No Discount], [Promotion].[Promotion Category].&[Reseller]}, Measures. CURRENTMEMBER ) SELECT ADDCALCULATEDMEMBERS ([Promotion].[Promotion Category]. members ) ON COLUMNS , CROSSJOIN ({[Product].[Category].[All Products],[Product].[Category].[All Products]. children }, {[Measures].[Customer Count],[Measures].[Internet Sales Amount]}) ON ROWS FROM [Adventure Works] --and the second query with member [Promotion].[Promotion Category].[No Discount und Reseller] as aggregate ({[Promotion].[Promotion Categor ...Show All

• Visual C++ shortcut to access the scope and function droplist in the text editor

  what is the shortcut to access the scope and function droplist in the text editor if no, what is the corresponding command so that I can set one in the Tools->Customize... thanks Oh sorry! Now I underrstand. As far as I know there is no hotkey for this. BTW (its may be no direct solution for you): I use VA X from www.wholetomato.com . Is is a phantastic extension that allows much easier navigation with its own context bars... and it has much more really powerful features. ...Show All

• Visual Studio How to make CompleteWord feature to be called by CTRL+Space?

  How to make CompleteWord feature to be called by CTRL+Space shortcut Hi there, I have implemented Word Complete feature for my custom MPF based language service. But I can only to show my combo with the set of possible completions by CTRL +K,W shortcut. It’s very inconvenient. The more habitual way for me is to press CTRL+Space shortcut when I want to see a list of possible completions. Does anybody know how to make Word Complete feature to be called by CTRL+Space shortcut Any help will be much appreciated. Thanks! Hi Thank you! I've written the following code: private void SetShortcutsBindings() { DTE dte = GetService( typeof ( DTE )) as DTE ; Commands cmd ...Show All

• Visual Basic Copy of Screen

  Good day to you. I don't know much about the ClipBoard and GetData and so forth but there seems to me that 2005 Express is not quite the same as .NET 2003. The code that I shall give in a moment gave me a full screen copy on the Form_Load event and gave a copy of the Form on a button_click event. Now, when using the code in 2005 Express the Load event only gives a copy of part of the screen. Why is this happening Is there a way in which I can rectify matters. I would be very pleased for any info. I have tried with Imports and Inherits and Paint. It is the sizing I believe. Private Sub frmScreen_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load SendKeys.SendWait( "{PRTSC}" ) D ...Show All

• Visual Studio Tools for Office Trying to create Excel 2007 doc using Asp.Net and C#

  Hi, I am trying to learn how to create Excel spreadsheets programmatically and I believe this is the place to get help. I have been able to create an actual file, but when I try to open it with Excel 2007, a message box is displayed with "Cannot use object linking and embedding". When I click OK, I get another message box with "Microsoft Office Excel has encountered a problem..." and gives the option of sending an error report. What am I doing wrong Here are the relevant pieces of my code. Thanks in advance for any feedback. using Excel = Microsoft.Office.Interop.Excel; private void createSpreadsheet() { Excel.Application oXL; Excel.Workbook oWB; Excel.Worksheet oSheet; Excel.Range oRng; try { ...Show All

• Windows Forms how to make the form expand dynamicaly when it maximize???

  I want my form to expand regularly with the window when the window maximizes .... If you mean you want your control to resize with the window, look at the control's Dock and Anchor properties. Or do you mean MDI child form inside the main form ...Show All

• Software Development for Windows Vista Tablet or UMPC recommendations and questions

  1) Which models or brands of UMPC or tablets best support Vista's new features to capture both stylus input (signatures to be specific) yet allow four touch input (finger, not stylus) when application features simple large format tap menus or selections (restaurant or doctors's office apps) 2) How does Vista provide this dual iput technology (writing recognition and touchscreen) Is there a setting in the framework that allows you to switch on the fly between an active or passive screen input Thanks in advance, Jim Hi Jim: It's a little too early to be saying which UMPCs best support Windows Vista. UMPCs were designed to run Windows XP. There will be a next generation of UMPCs designed to run Vista, b ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Animating Billboards Using A Single Texture

  I just finished a basic billboard class that is capable of reading in multiple textures and animating. However, I would like to read in a single texture file and be able to simply change texture coordinates to change the appearance of the billboard. Now, I could recreate my VertexBuffer each frame, but that would be a lot of wasted processing. Is there a way to dynamically alter the texture coordinates for VertexBuffer objects each frame Edit: As a bonus question, how do I enable the alpha channels in my textures Right now it shows up white. I am using the BasicEffect. Would I have to write my own effect just for that Seems rather silly but I will if I have to. Edit 2: As bonus question 2, how can I disable antialiasing of my textures I'm ...Show All

• SQL Server How to retrieve current date and time from SQL2005 server.

  well i'm using java to connect to SQL 2005 server. i need to retrieve it's current time and date on the sql 2005 server and use it on my remote desktop thanks. Hi, You can use the following query : SELECT getdate () as myDate wich will give you somthing like "2006-10-27 11:29:15.373" Regards ...Show All

• Visual Studio Team System How to get changeset history in a given period

  I just wanna get the history, e.g., from Jan 1st to May 1st. But I didn't find any command matched this, is it possible thx. If you chose the Get Specific Version option, you will have the ability to select the type in the Get dialog. Select ellipse next to the changeset filed and you will get the Find Changeset dialog. You can select the created date option atht will let you select a date range. If you click Find, you will get a list of all the changesets in the date range. Unfortunately you cannot drill into the changesets to see the details, but you will have the changeset numbers. -paul ...Show All

• Visual Basic Where can I look up error numbers

  This is exasperating, trying to wade your way through all the reams of 'help'. All I am trying to do is find out what the error numbers are for errors that might occur in my program. For example I need to know what error message is given when a user cancels a download in progress before it is completed. Why in the heck is it so hard to find out the number for each error I mean, I can find tons of information on how to deal with certain errors. I am using VB and VS2005 Standard Edition if that makes a difference. Can someone direct me toward where I can find this information for now and for future reference Thanks for any help Bill Langston Thanks for the reply DMan1, but that's just it; I don't have any error right ...Show All

• .NET Development Looking for a explanation of basic Streams

  When building streams, is a hierarchy conducted For example, if I create a FileStream theFile = File.Open(@"C:\somepage.txt", FileMode.Write) and want to read from it, do I need to create a memorystream via MemoryStream rdr = new MemoryStream(theFile).. and to write to this stream use a writer via StreamWriter writer = new StreamWriter(rdr). And finally.. when closing do I need to close all of these streams up writer.close(), rdr.close(), theFile.close() or would this procedure be mostly redundant code and is there a better way I guess I'm just looking for someone to explain the intricacies of why all this passing around of 'streams' is necessary and maybe offer a more simplistic view of the process of it. Thanks in advanc ...Show All

• SQL Server Set Concurrent connections

  Hello, I'm planning to set the maximum number of concurrent connections, but I don't know what to set in there. Actually I know the concurrent connections averange, is there any way to calculate the max number of concurrent connections Thanks, ...Show All

• Visual Studio Tools for Office How to make sure I selected the correct emial in the mail list?

  Hi, How am i able to select the particular mail from the inbox default folder so that i need not need to open up the mailitem in order to do my work. e.g i select a mailItem from the inbox and i click on the delete button to delete the mail. I wanted something like that so i do not need to open up the mailItem. Thank you VSFW3 In the Outlook object model, the Application.ActiveExplorer.Selection collection represents the items (note plural!) that the user has slected in the folder view. ...Show All

• Visual Studio 2008 (Pre-release) Problem with template parameter inference

  Hi All, I want to extend all IEnumerable<T> with a method called SomeOp. Usually I would define the extension like this: static class Sequence { public static IEnumerable<T> SomeOp<T>(this IEnumerable<T> sequence, Func<T, bool> func) { return sequence; } } As the operation always returns an object of the input type, I want to be able to write: List<int> integers = new List<int>(); List<int> ints2 = integers.SomeOp(x => true); To do so, I defined the exension method like this: static class Sequence { public static Enum SomeOp<T, Enum>(this Enum sequence, Func<T, bool> func) where Enum : IEnumerable<T> { return sequence; } } Compil ...Show All