Helen999888's Q&A profile

• SQL Server Newbie question - Getting the headcount at the beginning of the year using OpeningPeriod

  Hello, Here's a newbie question that I am having a heck of a time figuring out... I want to return only the balance at the begining of the year. My time dimension has a hierarchy as follows: -Fiscal Year --Month ---Period I then created (from the template) a Calculated Member that does return the number. However, as you can see, it is only from Fiscal Year 2006, the first period (Period Number = 1) Aggregate ( OPENINGPERIOD([Dim Row Date Vw].[FiscalYear - EnglishMonth].[Period Number], [Dim Row Date Vw].[FiscalYear - EnglishMonth].[FiscalYear].&[2006].&[1]), [Measures].[ACTIVE] ) How do I change this so it pulls from the first period for each year, at the beginning of that year Thank you for the help. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating a GUI builder in visual studio

  I'm curious as to #1 if it's possible and #2 how to get started building a GUI creator where you can drag and drop gui controls in 'design time' to create code files or a form of XML How do I tap into vs.net to create my own design time/code time pages The GUI controls wouldn't be .net controls, but controls that inherit from a custom gui control class and so on. Thanks, Jonathon More specific to designers and serialization of code, you may want to read this: http://msdn2.microsoft.com/en-us/library/aa720032(VS.71).aspx You'll note that this is all about designers for Winform controls and Components, which is not what you want to do. However, you can read this to get an idea of what a visu ...Show All

• SQL Server SQL Server 2005 Everywhere Edition: Replication with MS Access?

  Hello @all, does anyone know whether a SQL Server 2005 Everywhere database can be replicated with a common MS Access database Is there any possibility to synch a database on a mobile device (SQL Everywhere) with a central database on a server computer (like MS Access or SQL Express) without having to use a full version of SQL Server Replication is just needed for merging a small database (4-5 tables) so I think the full version of SQL Server is a little bit oversized for this issue (and too expensive, too). Thank you very much in advance, Tim Microsoft is also going to provide a solution where a SQL Server 2005 Everywhere database on a mobile device can be synchronized with a MS Access on the des ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help please: GraphicsDevice in a form

  I'm new to C# and Windows coding, and I'm working through some books, but I wanted to jump ahead a bit and do something interesting, have a SplitContainer panel do something using the XNA graphics engine, even just clearing to cornflower blue or something like that. I looked around to see how to do something like this, and found a few partial examples, so I tried to piece together something that would work. I tried, and I keep getting a DeviceNotSupportedException when I tried to create a new graphicsDevice. I can do the XNA tutorials, so I have to believe my graphics adapter is capable of this, but I'm doing something wrong. Thanks in advance. Here is what I have: using System; using System.Collections.Generic; using System.ComponentModel ...Show All

• Visual Studio 2008 (Pre-release) XAML Namespace Mapping

  Hello *, I already read the wpf sdk, but there are still a few questions left... I wondered what is behind the xml Namespace Mappings xmlns= http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x=” http://schemas.microsoft.com/winfx/2006/xaml in the root tag of a xaml page. In the SDK: "Within the namespace declarations in the root tag of many Extensible Application Markup Language (XAML) files, you will see that there are two xmlns declarations. The first declaration maps the overall Windows Presentation Foundation namespace as the default: xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " The second declaration maps a separate Extensible Application Markup Langu ...Show All

• SQL Server Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work   No, I did not get the debug trace function to work, it simply dont dump any data, dont ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rotating model, with multiple parts

  Hi all, One of the persons on my team has designed a model, that has more than one part. When we try to rotate the model in XNA, it rotates every piece. If there anyway to choose to rotate the whole model, instead of the piece Here's a hack that will probably work: Tell your artist to set the all the pivot points for the model as one location. Then, all the pieces will only rotate around that pivot point, not their individual pivot points. There might be a better software solution, but I don't know it. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Game Development Contest

  For those who haven't heard, there is an XNA game development contest taking signups on my site: http://xbox360homebrew.com I was hoping someone else would post it here, but I didn't want you to miss out if you hadn't heard. Man, I was hoping no one would mention it so I'd have a better chance of winning! ...Show All

• Visual Basic How do I make DirListBox select a folder and display a new list of folders with a click?

  The Windows OS on my system is setup to respond to single clicks as opposed to double clicks. The DirListBox in my app only acts when double clicked, and only selects an item when single clicked. How do I change this so the DirListBox will act like my system and the rest of my app. I have a TextBox which can handle the select (single click) action. My code for this is such a mess (at least where DirListBox is concerned) I'm going to start over, but I would like some ideas before I try again. Thanks. I was doing that, but for some reason it was not working at the time. However, once it started responding I was able find a number of bugs which I seem to have solved ...Show All

• Visual Studio Tools for Office Word 12 Document Project & Ribbon Controls

  With a Word Add in Project i was able to sucessfully create a ribbon control.. Now i am working with a Word 12 Document Project and i would like to create a ribbon control inside of that project type but i dont see the option.. Are ribbon controls only avaiable inside of addins Is this by design or just that they haven't implemented it yet inside of other project types thanks MJ Hi MJ, You can only add a Ribbon Item to a VSTO project when you create an add-in that supports the ribbon (such as a Word add-in or Outlook add-in) using the June CTP of VSTO. Kathleen McGrath http://blogs.msdn.com/kathleen/ ...Show All

• SQL Server Converting Date Data type in stored procedure

  HI Experts... I am using SQL SERVER 2005 standard edition I have encountered a problem regarding converting date data type in stored procedure As i was having problem taking date as input parameter in my stored procedure, so, then  I changed to varchar (16) i.e. CREATE PROCEDURE sp_CalendarCreate                                       @StDate VARCHAR ( 16 ) ,                            &nb ...Show All

• .NET Development What is the 3.0 runtime going to look like?

  I'm looking at (and have installed) the RC1 of .NET 3.0 and it seems empty. Are LINQ, ADO.NET Entities, WCF, etc.. all shipping as individual libraries / downloads or is this just how it is for pre-release so each project can release betas as needed I've been looking around for a good explanation of "what versions of everything to download" and I haven't been able to find anything. Right now I can't seem to build ADO.NET Entity projects that use LINQ because of version dependency problems, and there seems to be a project-type in Visual Studio for each library I plan to use. What do I pick if I want to use multiple libraries I can understand keeping everything seperate during development but I would have expect ...Show All

• .NET Development How to get user identity while invoke a Web service Method

  In my case ,I just want the method in web service be invoked by Authenticated user. for example. [WebMethod] public string HelloWorld() { if (HttpContext.Current.Request.IsAuthenticated ) return "Hello World"; else return "Not Authenticated"; } TestWebService.Service service= new TestWebService.Service(); //before i calling this method ,the IsAuthenticate equals true; string hello=service.HelloWorld(); when i calling this method , the IsAuthenticated equals false. I don't want to pass the user name and pass word every time i am calling. so anybody can give a answer any help is great appreciate. Hi Alan, Mark the post(s) which ...Show All

• Visual Basic Saving an image to a database from an OpenFileDialog!

  I am looking for a way to take an image from an OpenFileDialog and save it into a database as an Image, then use the Image data from the database to display it in a PictureBox and set it in an image list. Can anyone help Sure. try this (untested) Save Image to SQL imports System.IO ... ... Dim theFileInfo as new FileInfo(Me.theOpenFileDialog.FileName) Dim theContent(theFileInfo.Length) as byte Dim theFileStream as FileStream = theFileInfo.OpenRead() theFileStream.Read(theContent, 0, theContent.Length) theFileStream.Close() .. 'Your SQL Stuff here Dim theSqlCommand as new SqlCommand("INSERT INTO TableName (FieldName) Values (@theImage)") 'prefer to use Stored Procedure...this is just an example ...Show All

• Internet Explorer Development IE7 and ParseURL function

  Since I installed IE 7, I am experiencing a problem browsing a CD using an application running under Internet Explorer which (apparently) isn't able to parse the url / link anymore. As a matter of fact, when I click on a link, for instance the one giving me: javascript:location.replace(sHOME+' cronolog/_indice.htm') in the status bar, the " page cannot be displayed" message appears and the address bar reads: res://ieframe.dll/dnserror.htm#file:///D:///D:/20060126/cronolog/_indice.htm Code-source for the javascript ( indici.js) I am using is: function ParseURL( sURL ) { var i=0, j=0; var sTmp=""; sTmp = sURL; if (sTmp.indexOf("_rastrib")>0) sRivista="nome rivi ...Show All