Jon Braganza'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 Hello, how can I create new measure aggregation function in Analysis Manager ( MS SQL 2000 ) In edit cube I can see only calculated members. And in this form I have to put some MDX.. Sorry I am a beginner Thank you Jindra ...Show All

• Visual Basic Trying to Do an inplace Update of Rectangle Objects stored in generic List

  This is a strange one for me. What I have is a List(Of Rectangle) that are each 200 by 200. I want to be able to go through the list iteratively, change each ones location to being 10 pixels to the right and 10 pixels down and then shrink their size by 20 on each dimension. Initially, I planned on something like this: Private Sub prepareMenuSquares( ByRef squares As List( Of Rectangle)) For Each thing As Rectangle In squares thing.X += 10 thing.Y += 10 thing.Width -= 20 thing.Height -= 20 Next End Sub I assumed I would be passing the List by reference and then would have access directly to the Rectangle objects themselves and could do an inplace modifcation, no problem. Well that didn't work a ...Show All

• Windows Forms Merging ToolStip toolbars

  I developed an app using VC# Express Beta that included an mdi parent and an mdi child form. Both forms contain a ToolStrip and, while using the Beta, these ToolStrips merged together as I expected them to. Now, I've updated to the final release of VC# Express and my ToolStrips no  longer merge. What happens now is that the ToolStrip on the mdiparent displays and the ToolStrip from the mdichild never gets displayed at all. Does anyone know why this might be The MDI parent form ToolStrip is called "toolEdit" and has allowmerge set to true. It contains four items with their MergeAction/Merge Index set to Append   1 Append   2 Append   98 Append   99. The child T ...Show All

• Software Development for Windows Vista Applying TrackingProfiles to a base class workflow and all sub-classes

  Is there any way of applying the same TrackingProfile to all workflow instances that inherit from a common base class workflow e.g. BaseWorkflow ---> has its own tracking profile DerivedWorkflow1 : BaseWorkflow DerivedWorkflow2 : BaseWorkflow etc. My experiments suggest that when using the SQL Tracking service a separate (in my case identical) profile must be defined for each and every DerivedWorkflow type: a BaseWorkflow profile is not applicable to the derived workflows. This is a bit of a maintenance headache when large numbers of derived workflows exist. I think Joel was clarifying that you can insert your shared profile as the default profile, which gives you what you want (all of your derived ...Show All

• Windows Forms Font style not found issue/exception -- how can apps work with this problem?

  I have the following code (generated by the designer): this .panelTabs.Font = new System.Drawing. Font ( "Verdana" , 11.25F, System.Drawing. FontStyle .Regular, System.Drawing. GraphicsUnit .Point, (( byte )(0))); A user running our app gets the exception: ArgumentException: Font 'Verdana' does not support style 'Regular'. because the user's computer has all verdana font files but the "Regular" one. So he has bold, italics, etc files but does NOT have the "regular" font style. If all the verdana fonts are missing, Windows smartly does a font substitution. However, when certain style is missing, it does not seem to do it. How can I avoid this exceptioon without having to go through hundred ...Show All

• Software Development for Windows Vista Power icon problemw

  Hello, I've just installed the Windows Vista Beta 2 (Build 5384) and so far so good, except for one thing: somehow i can't activate the option to show the power icon on the "notification are" of the "taskbar". When i go to the properties of the "taskbar", and then go to the "notification area" options, i'm allowed to select to always show the clock, volume and network icons, but not the power icon. Do you know what can i do to fix this problem Because of this problem, i never know when the battery is low. Thanks for your help!! It is true, I have an Acer TravelMate 4002WLMi Notebook and I have the same problem as mentioned here..... I tried installing drive ...Show All

• .NET Development ExecuteScalar() and Primary Key

  I have a sql command that inserts into a Datbase....and i pass it the parameters in my table...It breaks though...When i do a call stack i see the new values being loaded into the memory through the parameters...but i also do a stacktrace and i see it breaks when i try to retrieve the _CustomerID that is also the primary key..... which is line 990.....take a look at the command could it be structerd different...... private void Insert() { string sql = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; using (SqlConnection connect = new SqlConnection(sql)) { using (SqlCommand command = new SqlCommand("Customer_Insert", connect)) { command.Parameters.Add("@CustomerC ...Show All

• SQL Server is there a collection of all database objects

  i want to write a tool to make scripting of databases easy. the user will select the server and dababase, then they will select what they want to script: eg tables, sprocs, permissions, scheemas etc etc. currently i have a load of check boxes , one for each type of object in the db ( one for tables, one for sprocs etc). this is very long winded,and if there was a collection of the db objects i could call into a list box it would be a lot tidier and easier. There are a number of collections within the Database object in SMO which you can use, such as Tables, Triggers, StoredProcedures, Users and Views. Each of these is a collection of the named objects within the database. (At the Server level of course, th ...Show All

• .NET Development BeginSend and bytes send reported by EndSend

  I was hoping someone could help me understand the number of bytes sent if I am using BeginSend. Let's assume I send 100 bytes of data using BeginSend. In my async callback, if I call EndSend it will return me the number of bytes that were actually sent. My question is under what circumstances will the number of bytes reported when calling EndSend not match the number of bytes I wanted to send. So, EndSend says it sent 50 bytes and I wanted to send 100 bytes. If the case is that EndSend reports only 50 bytes were sent, do I need to resend the remaining 50 bytes again by calling BeginSend again with those 50 bytes From MSDN, the EndSend method: If you are using a connectionless protocol, EndSend will blo ...Show All

• Windows Forms Export DataGridView to Excel

  Hi I'm new to vb, I'm using VB 2005 I have a DataGridView that i want to export to Excel what is the simple way of doing that I usually export it as an xml spreadsheet which will work with office xp, and 2003. There is an example on the VB-tips website . ...Show All

• SQL Server temp table naming

  I have a procedure that creates temp tables. I made the temp tables local - using # instead of ## - but I still get a 'table exists' error, when I run it from 2 qa sessions at the same time. I am deleting tables at the begining of the proc and again at the end - using IF EXISTS(SELECT name FROM tempdb.dbo.sysobjects where name = '#Archive_In')DROP TABLE #Archive_In Is this expected behaviour   I thought using # would make it local to the connection If this is expected, how do I make it work   I thought SQL used the spid or something, appended to the end of the table, and maintained that reference No, it's not new in 2005. It is, however, an undocumented system procedure. We recommend that you do not use undoc ...Show All

• Visual Studio Express Editions how to use a custom cursor (.cur)

  I have made a .cur file and have embeded it in my.resources so I can easily acess it from in my code but I don't know the correct syntax. Whatever I try never works. Can someone please tell me the few lines of code I need to use my cursor I tried it and this error message came up. It is probely something basic, but is there possibly anything left out in the line: Dim Cur As Cursor = New Cursor( "c:\windows\cursors\pen_rm.cur" ) Thanks for trying! Error 1 Overload resolution failed because no accessible 'New' can be called with these arguments: 'Public Sub New(stream As System.IO.Stream)': Value of type '1-dimensional array of Byte' cannot be converted to 'System.IO.Stream'. 'Public ...Show All

• Visual Studio 2008 (Pre-release) Another puzzle on how to access ui elements inside datatemplate.

  Recently, I am trying to use the DM-V-VM model (see dan 's blog) to develop wpf applications. In this model, I can define DataTemplate like this: <DataTemplate DataType="{x:Type local:Contact}"> ........ </DataTemplate > <DataTemplate DataType="{x:Type local:ContactVM}"> <Grid> <ListBox ItemsSource="{Binding Contacts}" ></ListBox> <Grid Name="grid"> <Button Name="button">Test</Button> </Grid> </DataTemplate > ...... <Grid> <ContentControl Content="_content"/> </Grid> In such a model, we can see the DateTemplate is applied to a DataType(C ...Show All

• Visual Studio 2008 (Pre-release) How To set the ClientBase Address To be Routable

  Hi All Using the WCF service, I just finished writing a little pub/sub e-mail application that resembles outlook (a little bit some how) The WCF service I Created uses a Duplex communication and when an a new email is sent for an online client, the service automatically invokes a call back event attached to the client. In order for the service to find the client, the client first has to provide its base address on the binding information of the client side when it subscribes to the service. Now everything works fine as long as I am on local area network but if I am on a different subnet or I am trying to access the service form a different network, then the service can not find the client and Vise versa How sho ...Show All

• Visual Basic How to add default text to a dynamic created text box

  I have the following code that creates a text box at run time I want the default text to be based on a raido button selection button1 text = "Start Pcba" button2 text = "Start FI" button3 text = "Start Cable" How do I set the default text for "stepstart" base on the button click Dim dynamicText As TextBox = Nothing dynamicText = New TextBox Dim intstep As Integer = 1 dynamicText.Name = "stepstart" dynamicText.Location = New Drawing.Point(10, 100) dynamicText.Size = New Drawing.Size(232, 20) Me .Controls.Add(dynamicText) btnAddStep.Visible = True Not completely thought out code ... but here it ...Show All