Dvlnblk's Q&A profile

• SQL Server MDX AVG function

  Hello, I have a table with two colums Sex and Age. Sex, Age ------------- M 25 F 32 M 85 F 44 I would like to see average age for Sex. Something like this: Avg Age ------------- M 33,3 F 42,3 I tried this MDX with MSSQL 2000 Analysing services WITH MEMBER [Measures].[AvgAge] AS 'AVG(Descendants([Sex].[Sex] .CurrentMember) ,[Measures].[Age])' SELECT { [Measures].[AvgAge] } ON COLUMNS, { [Sex].[Sex].Members} ON ROWS FROM PCPCube but I doesn't work. Any idea Thank you Jindra Create a new measure in your cube for "Age" with aggregation function set to count - named it "AgeCount". Then run the following query (i assume the aggregation function for the existing "Age" is set ...Show All

• Visual Studio Tools for Office Event Handling - Can't figure it out

  I have been searching all over for an answer to this question. I am creating a document in Microsoft Excel 2003 and I am using the Visual Basic Editor 6.3 to add some functionality. I would like for a KeyDown Event by any Control to use a shared function as the EventHandler. I have written the following as a simple example of what I am thinking. I would expect this code to cause every control I list in the TabSequence array to create a MsgBox saying "it worked" whenever a key is pressed and the control is in focus. Needless to say it does not work how I think it should. Any help would be great. Thank you in advance! Public Function TabSequence() As Variant TabSequence = Array([TextBox1], [CheckBox1], [ComboBox1], [Tex ...Show All

• Visual Studio 2008 (Pre-release) Orcas svcutil Suport?

  Hey! I found out that I can download Microsoft Pre-release Visual Studio Code Name "Orcas" today from : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1129583&SiteID=1&mode=1 When using "Add reference" will it suport paramters/switch on the svcutil I need two parameters that are not suported in Visual Studio 2005 IDE (with orcas suplement): /a = asynchronous methods /r = Shared types ex svcutil /o:proxy.cs /a /r:SharedTypes.dll http: //localhost:8000 I have got an asware for this question: " We are planning to support this in the Add Service Reference feature in Visual Studio Orcas. In fact, we’re half-way implementing those very options as we speak. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A VERY simple question. I'm obviously missing something -er- obvious

  Ok firstly, please forgive what MUST be a simple simple question... I've done the From DOS/BASIC->QBasic->VB3----->VB6 as well as some delphi, C, C++, lost of PHP a bit of ASP, some MySQL and some MSSQL, So I didn't think VS2005 would be a real problem (and after a month I'm starting to get my head around it), however, I devided to make a program to start learning somethign 3D-ish. Now I tend to prefer VB over VC as I'm more familiar with it (Yeah, I know Learn VC well is on my to do list) I started reading an article here: http://msdn.microsoft.com/coding4fun/gamedevelopment/beginning/default.aspx and am stuck on the first page. Having Downloaded the August DirectX redist, the August SDK and the October SDK, I can't work out how ...Show All

• Visual Basic Bizzare problem! IDE won't accept any changes.

  Something very bizzare is happening and I have no clue as to why. Whatever changes I make to a form in the IDE whether it be adding a button, removing a button, or changing the text (title of the form), it will show in the IDE designer. But when I run it, it's as if none of the changes were made. A button I removed is still there and the code behind it still executes although I commented that code out. Saving the files doesn't fix it. Closing the solution and reopening it doesn't fix it. Exiting Visual Studio altogether and restarting it doesn't fix it. And restarting Windows XP doesn't either. It's as if my application is stuck where I left it last night. When I reboot everything, launch Visual Studio, and open the sol ...Show All

• Visual Basic Call Stack Frame

  Hi, I have a routine which transfers data from an excel worksheet to a data table, then I iterate through the datatable to update records in an Sql database. Works fine up to a point, however half way through the process, I get the following error message. "No symbols are loaded for any call stack frame. The source code cannot be displayed" Whe I click OK on this messagebox, the following error information is shown. ContextSwitchDeadlock was detected Message: The CLR has been unable to transition from COM context 0x1a1de0 to COM context 0x1a1f50 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumpi ...Show All

• Windows Forms Cannot add record in VB 2005 Express Edition

  I am just getting started with VB 2005 and built a data application following the example in the video "Absolute Beginners video" and have never been able to add or change a record using the update method. I even downloaded the project and still could not add or modify a record. Is there a reference I need to set or possibly an update I need I have Windows xp home SP2 Was there an option to do that during install I may have skipped it thinking I already had it set up. How could I check Do I have to re-install VB2005 Thanks ...Show All

• Visual Studio Team System When should I create a new TFS project

  Hi, I have question regarding Team System. I am a little bit in doubt of when I should create a new Team Project. I have several small internal software projects and I have one large external project. For now I have created two Team Projects one for all internal projects and one for the external project. Would you recommend me to create one per project My external project also consists of different modules and customizations for different customers, should I spilt that up Thanks Henrik Skak Pedersen. This should provide you some guidance: http://blogs.vertigosoftware.com/teamsystem/archive/2006/10/04/3867.aspx ...Show All

• Architecture Problems with Owner Draw Menus in an out of process ActiveX Document Server

  My Document Server is written with C++ MFC and built using VS .NET 2003 and is targetted to WinXP and newer. I’ve now run out of ideas on how to resolve my owner draw problem when an OLE container attempts to render my shared menus. Everything is fine when the keyboard is used to activate the menubar items. This is because the container is using WM_NCPAINT etc to create a real screen drawing context. This context is then passed through to the in place frame of my server where it will succeed in drawing the menu items ( WM_DRAWITEM ) When the menu bar item is clicked on with the mouse, however, the container make use of WM_PRINT, WM_PRINTCLIENT to render to a memory HDC. When this HDC is passed to my out of process serve ...Show All

• Windows Forms Gradient backgrounds.

  How would I go about creating a gradient background in a component such as a label, text box, or panel I have never really fiddled with the System::Drawing namespace, which I know is what I would have to use. Anyone know how to do this at paint event use LinearGradientBrush to fill the background LinearGradientBrush lgb = new LinearGradientBrush(rect, gradientFirstColor,gradientSeconedColor,lgm)) For more info look at Simple Label Gradient Using The LinearGradientBrush Working with Brushes in GDI+ LinearGradientBrush Class ...Show All

• Visual Studio Express Editions How to create a string from a field of the selected row

  Ok, I have a super simple form that works, but not how I want it to... My form has 1 combobox, 1 label, and 1 button. I have a datasource, tableadapter, and a bindingsource. The database has 3 fields in 1 table. ID, Name, URL ID is not displayed on the form, the combobox is binded to Name, and the label is binded to URL. on btn1 click call shell("internetexplorer path " & label1.text, 1) All works well and good. However, I dont want to have to show the URL... now, the ghetto work around is to make the label1 font color the same as the form back ground color, and that works... but, I'd like to know the 'right' way to do it. I need to know how to dim url as string = url colum of the selected row basicly. ...Show All

• SQL Server Seeking help demonstrating a simple drill down in Report Builder using Adventureworks

  Folks, I'm interested in demonstrating how ReportBuilder can let a user drill down through relationships, as it described here, where it suggests that a report of employees could have them click on department to see other employees in that department: http://msdn2.microsoft.com/en-us/library/aa337330.aspx Unfortunately, it only says that "the person who created the data souce" made the fields "interactive". It doesn't clarify how they are to do that. I realize there's an option to create a report and save it as a clickthrough from another, as described here: http://msdn2.microsoft.com/en-us/library/ms365324.aspx But I was hoping that instead something more straightforward may be possible in the report model design proce ...Show All

• Visual Studio Team System Unshelve to different branch

  Is there a way to get code shelved from branch A easily into branch B Yes, you can do all of this from the TFS APIs. In fact, every power tool we've released so far has used nothing but public APIs. Rest assured this one is on our list... ...Show All

• Windows Forms paint animation

  Hi, I wanna draw animation using OnTimedEvent(). I tried passing a PaintEventArgs e into OnTimedEvent() but the PaintEventArgs seem to be changed frequently. I also tried to do drawing inside Form2_Paint() but it draws only 1 time. How can I do drawing in OnTimedEvent() What API should I look for Hi, Why do you not use System.Windows.Forms.Timer And in the OnTimeEvent, you can use Graphics graphics = this .CreateGraphics() to get the graphics, and then do any painting you want. But you use System.Timers.Timer, you can access 'this' directly. ...Show All

• .NET Development Failed to install Visual Studio 2005 Extensions for Windows Workflow Foundation (EN).exe (3.00.4203.2)

  Hi, I'm trying to upgrade my install to .NET 3.0 from the .NET 3.0 RC1 and during the install of the workflow extension I receive an unhandle exception from Visual Studio 2005 Team edition. After that my VS 2005 does not start any more. To make it work back I have to rollback to the RC1 that everything works fine. This is my upgrade procedure: 1- uninstall Visual Studio 2005 Extensions for Windows Workflow Foundation RC5(EN).exe 2- uninstall WindowsSDK Vista RC1 (6.0.5536.0.2) 3- uninstall .NET 3.0 RC1 (3.0.4324.17) then 1- install .NET 3.0 RC1 (3.0.4506.30) 2- install WindowsSDK (6.0.6000.16384) 3- install Visual Studio 2005 Extensions for Windows Workflow Foundation (EN).exe (3.00.4203.2) I took my downloads ...Show All