Leo Diao's Q&A profile

• SQL Server StrToMember problem

  Copy of an unanswered post on the AS forum I am very much a beginner to Analysis services and MDX. I am using SQL Server 2005 Analysis Services together with Reporting Services as the client. I wish to use a report parameter to select the members for use in a standard report. So I have set up a report dataset:- WITH Member ChannelName AS StrToMember ( "[Measures].[MAvg_Ch0]" ) SELECT NON EMPTY {ChannelName} ON Columns , NON EMPTY {[Time].[Date].[Date]. ALLMEMBERS } ON Rows FROM ... "MAvg_Ch0" is a calculated variable in my AS cube, computing a moving average. This provides me with a mechanism for entering the report parameter which will ultimately replace "Ch0 ...Show All

• Visual Studio 2008 (Pre-release) Issue with WCF method in client app

   have a Web Project called secure that I would like to use a WCF service on the server. In the Solution, I have another project, WebFuncs, that is some common code, and includes the Service Reference to my WCF Service. Because secure imports WebFuncs I was able to use this code: Private proxy As New OrderCompletion.OrderCompletionProxy ... Private Sub btnSend_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSend.Click  ...  OrderNum = proxy.CreateOrder(Me.CartID, Me.tbComments.Text)  ... End Sub However, in use I get this error: System.MissingMethodException: Method not found: '!0 System.ServiceModel.ClientBase`1.get_InnerProxy()'. at secure.OrderReview.btnSend_Click(Object sender, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Internet and network gaming

  Im still green as far as programmers go. I need to know, is there a way to get two copies of my game to communicate over a network using only C# and XNA or am I looking at integrating it with a different language. Also for internet gaming, will I need to set up a server for my game or is there somewhere I can subscribe to (or ultimately better "FREE") where I can set up a chatroom and main access point for those who want to play my game. I also want to keep gamefiles on a central site if possible, kinda like Blizzard does with Diablo II, in order to cut down on cheating. Lastly covering cheating itself, does anyone have any hints on how I can protect the internals of the game so people cant hack it (imposible I know) but ...Show All

• Software Development for Windows Vista HTMLHelp context popups

  Sorry if this is slightly off-topic, but it is 'Vista UI Development' related. On versions of Windows prior to Vista, HTMLHelp's context popup windows have a 'translucent' drop shadow, albeit that it's achieved by a dot screen. Under Vista (RC1) the drop shadow appears to be opaque and black! To my eyes this is ugly, and out of keeping with Vista's emphasis on translucency, particularly Aero Glass. Are there any flags or settings that can improve the appearance of HTMLHelp popups Failing that might the appearance improve in a future version HTMLHelp is supposed to be the preferred Vista-compatible solution for context help. Richard. Help generally seems to have a low priority in Vista. Winhelp has ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Background Picture

  I followed the tutorial Tutorial 1: Displaying a 3D Model On The Screen and I draw the spaceship correctly on the screen! Now I want to display a background picture in that project! I followed the instruction in the Programming Guide -> Content Pipeline -> How to: Draw a Texture But I have some problem! If I do the: spriteBatch.Draw(backgroundTexture, new Rectangle (0, 0,graphics.GraphicsDevice.Viewport.Width,graphics.GraphicsDevice.Viewport.Height), color .White); AFTER the mesh.Draw(); I Only see the background. If I launch the sprite Draw BEFORE the mesh.Draw(); I see the background, but the rotated mesh is not displayed correctly! Seem's that It's culled in the wrong way,like the face are rendered with a ...Show All

• Windows Forms Where are DialogKeys processed in Designer?

  I want to be able to move the controls around in the desgner by pressing the arrow keys but I can't find where the ProcessDialogKey is being fired. Is it in a service somewhere I don't know about Ken Thanks for the reply. I don't know if this matters, but I have a custom IMenuCommandService. For grins I added the following to my constructor AddCommand( new MenuCommand ( new EventHandler ( this .MoveUp), MenuCommands .KeyMoveUp)); AddCommand( new MenuCommand ( new EventHandler ( this .MoveDown), MenuCommands .KeyMoveDown)); AddCommand( new MenuCommand ( new EventHandler ( this .MoveLeft), MenuCommands .KeyMoveLeft)); AddCommand( new MenuCommand ( new EventHan ...Show All

• Visual C# How to name DataSet Tables through a Stored Procedure?

  Sorry for the very basic C#/SQL question. I have a stored proc that returns several tables of data. In my code I have a dataset that is populated by this stored procedure. I can access the various tables of information in the general manner: myDataSetTables.Tables[ 2 ] or myDataSetTables.Tables[ "myTableName" ] My question is that when the dataSet is filled from the stored procedure the table names of all the tables that are generated in the dataSet are always Table1, Table2, Table3, etc... What I would like to be able to do is define the table name through the stored procedure, but I don't know if this is even possible. Again, I'm sorry this is such a basic question, and there might not be a solution. I thought a sto ...Show All

• .NET Development What is the best way to insert 4000 records to database every 5 secs. in C#?

  Hi, just like the subject, what is the best way Currently, I have a stored proc. to do the inserting of records that is invoked by my C# app. So, every 5 secs, a code is called to insert the 4000 records. I also have a some sort of a header record for the group of 4000 records. When I look at the record created date of the header record, they roughly 14 secs. apart. Thanks, Rick.. Can you explain the reason for inserting 4000 records every 5s. That is to much data. Is this occurs all the time or just in periods. To speed up the inserts, you need to remove indexes of table, also trigers are out of order, not to mention foreign keys. Also autogrowt must be bigger than default 10%. And the way of inserting ...Show All

• Visual Studio Express Editions Why Is It So Difficult To Save and Load Form Text Boxes?

  I would appreciate any help someone could give me. I have searched this forum endlessly trying to find a way to save 60 or so text boxes on form1 to a file and then later read the information back into the same text boxes. It seems like I have tried every bit of sample code that I can find and nothing works. I have 5 books on VBE and VB5. I am a complete novice at this so please be gentle. Thanks in advance for any ideas/help. Glenn Well let's assume I would use another type of GUI then. What type would you suggest and how can I save and retrieve the user/data inputs to and from a file that is not beyond my abilities to accomplish I can’t speak for your abilities, but what you ar ...Show All

• SharePoint Products and Technologies ObjectDataSource in a web part?

  Hello All, My code below works perfectly when I put it in an ASP.NET application (default.aspx code behind for example), but as soon as I put it in a web part (compile it into an assembly and place it into GAC) I get this error: "The type specified in the TypeName property of ObjectDataSource" ObjectDataSource objDataSrc = new ObjectDataSource ( "Fully qualified name of my type" , "select method name" ); objDataSrc.SelectParameters.Add( "Perosnid" , "123" ); GridView grdViewPersons = new GridView (); grdViewPersons.AutoGenerateColumns = false ; grdViewPersons .DataSource = objDataSrc; grdViewPersons.DataBind(); this .form1.Controls.Add(grdViewPersons ...Show All

• Visual Studio Team System MDX syntax question

  Hello, I am starting to play with customizing some of the TFS Reports and have been able to create a couple of simple ones on my own. I am just trying to get my head around MDX and learn the basic syntax by playing with some of the box reports. I am having a simple problem however and I don't understand what is wrong. I am trying to modify the Remaining Work report and add in a filter in the WHERE clause that only returns items where the Exit Criteria is set to false. i.e. [Work Item].[Microsoft_VSTS_Common_ExitCriteria].&[Yes]. So my modified query looks like this. ---START WITH MEMBER [Measures].[Date Key] AS [Date].[Date].CurrentMember.UniqueName SELECT { [Measures].[Date Key], [Measures].[Cumulative Count] } ON COLUMN ...Show All

• Visual Studio Express Editions How to limit decimal places after a double?

  Hi, everyone E.g. double op, Q = 0.112233445566778899, H = 100.0, k = 20000.0; op = Q * H * k; Can the decimal places of "op" be limited to ..... let say 6 decimal places Thanks jrboddie for the solution. It needed a little tweak: V = Math.Round(V,n); Using string is only good for displaying as a label n stuff like that, in my case I need to do additional calculation so using string is out of the picture.But thanks anyway. Happy New Year to all !!!!!! :-) ...Show All

• SQL Server Subreport with a matrix

  Hello, I got a report with a landscape format, and inside it i got some subreports, but two of them are subreports with matrixes. Those two subreports are making the page to be printed into 2 pages, but the second page is always empty, is there a bug, a misconfiguration or misusage of the subreport Because instead of having 42 pages i will have two times more. How can i avoid this Using borders i noticed that it is the subreport that grows much more than when it is generated individually, since individually it fits in one landscape page, as a subreport it needs 1, 5 that makes it 2 pages, and the last one always empty Thank you If it was that simple i wouldn't ask. I do resize the sub report within a landscape size, an ...Show All

• Visual Studio Team System Not Ordinary MS Project mapping

  In my WI Task” I’ve added field name “Task Type” with two values: “Grouping field” and “Detailed field”. I wont to map this field to MS Project. It should change its value depending on the fact if in MS Project the task is a grouping task (have subtasks) or not. In other words. I Have two tasks – A and B. When I change in MS Project task B to a subtask of task A (A will become a grouping task) and send changes to TFS, then the field’s “Task Type” value for task A should change to “Grouping field”. Is there any possibility to achieve this effect Best, It can be achieved but it will need some coding from your end. 1. Has you are doing currently. Have a WI, Task with "TaskType" field, have a rule fo ...Show All

• SQL Server Hoy to Deploye VB.net Application Along With Database....Please Help.

  Hi Guys, I had a little Problem With My Application Deployment. I want To Make Setup For My Application(VB.NET) Such that When it begins To Install,The Database Of the Application Will Automaticallly Get Installed..... Even I have Generated Script For That But I dont Know How to Execute It With Installation File.I have made Complete Setup Of My Application Exept Database. Now,I want Few Code Lines To Execute My Database Script. So how can i Execute My Script Through Installation.. And Also If there is another Way To Accomplish This Please Suggest Me. All Suggestions Will be Accepted... Thanx In Advance.. WOuld C# code also be ok for you :-) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All