msdate's Q&A profile

• SQL Server MDX query using BottomCount

  Hi, Iam facing with a very strange MDX query related problem. I want to display 2 reports one that display Five top records and the second report that displays 5 bottom records. Following is my query which returns top 5 records. SELECT { [Measures].[Order Count] } ON COLUMNS, NON EMPTY TopCount ( Filter ( { [PRODUCT].[PROD NAME].[PROD NAME]}, [Measures].[Order Count] >= 0 ) , 5, [Measures].[Order Count] ) ON ROWS FROM [ShippingOrder] I created report using SQL Server 2005 Reporting Service and the data source is pointing to Analysis Services database. The preview report shows proper records. But my second report that queries to display the bottom 5 records does not display any records. The query is same except with ...Show All

• Visual Studio Express Editions Please help: I'd like to make an informed decision

  Sorry for posting here, but I didn't see how to fit this question into the other forums. I downloaded and installed Visual Basic 2005 Express Edition and I manage to create my first application - nothing fancy but still much more useful than a "Hello World" program. However, before I commit to VB, I'm wondering if I should stick with it and learn everything there is to Visual Basic, or if I should move to C# or C++ instead. Prior to VB 2005, most of my programming experience is from many years ago in console-based versions of BASIC: Applesoft BASIC from the old Apple IIe computers (yes, I'm that old ;) ) and on the PC side, with QBASIC from MS-DOS 5. So, as you can imagine, VB wasn't too familiar for me. Leaving aside the typ ...Show All

• Visual C# Dataset problem

  Now,everyone,here is the deal: I have a sqldataapdater1,sqlcommand1,sqlconnection1,dataview,datagrid1: here is the detail:(i want to see sql result in the datagrid1) sqldataadapter1.selectcommand=sqlcommand1; this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "PART", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("id", "id"), new System.Data.Common.DataColumnMapping("desciption", "description"), new System.Data.Common.DataColumnMapping("product ...Show All

• Visual C# Intellisense for events...

  Hi! I have a component that provides some events (via the Properties Window in VS2005) So, when when selecting some event I can show some breef text telling the user something about the event in the bottom of the Properties Window (via Attributes). But, I want to provide some help of the parameters in the generted event stub; private void myComponent_OnConnected(string ipAddress) { } How to provide some info/help about my parameter ipAddress I would like some text to show up when holding the mouse over the method name... Thanks, Mats Hi, to do this, you can go to your project properties (right-click on the project --> Properties --> Build --> check "XML documentation file"), save it and close. Build the pro ...Show All

• Windows Forms Custom title bar of the Form

  Hello, I want to customize look of the title bar. In a matter of fact i need to add bitmap images to the left and right ends of the title which heights are not equal. What are the "good"/correct/efficient way to do it Here is an article on custom painting in the "non-client" area of a form, which includes the title bar and the border. http://www.codeplex.com/Wiki/View.aspx ProjectName=CustomerBorderForm&title=Painting%20NonClient%20Area ...Show All

• Windows Forms How to control another application from a form

  Hi all I am working on a C# project and i need two things... 1-- I want another text editor to open a file but want to keep that editor window under my form control i.e. as child.... How can I do this 2-- I want to open a command line window (cmd window through a .bat file) and then execute some commands on that but from my windows form... how can i do this. I also want to capture output of the command window after it runns my commands.. Please help Aamer 1] You can't. Windows doesn't allow a window to be owned by or to be a child of a window that is not in the same process. 2] You can with the System.Diagnostics.Process class. You can use a .bat file or run cmd.exe with the /c comm ...Show All

• .NET Development Using Sockets

  How can i use socket to establish connection between two compuers which IP addresses are not real IPs This question has been answered before. Please search the forum before posting. See: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=241548&SiteID=1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Changing sprite origin from top-left to center

  In the XNA help I see the following: The origin is a specific point on the sprite—by default the top left of the sprite (0,0). How do I change the origin to the center of the sprite Is this something that is done in the DirectX Texture Tool Thanks in advance! A Wilco wrote: Also you should be able to define a rectangle with 2 Vector2's, and for some reason a rectangle only takes int parameters where a vector2 takes float, but never mind. The rectangle is probably using int to make sure you get whole pixels rather than part pixels and that you display on whole pixel boundaries. ...Show All

• Visual Studio Team System TFS Evaluation remaining time

  Hi, Is there a way to check how many days of evaluation are left in my TFS server Even a messy way like looking in the registry or calling a web service is fine ... Thanks, Eli Thanks ! Eliaz from MS just emailed me with an interesting link which solves this problem easily: http://blogs.msdn.com/bharry/archive/2006/08/23/714412.aspx Eli. ...Show All

• Visual Studio Express Editions Deploying an application

  Hello Guys! Please, is there any way to deploy an application package created with ClickOnce into Windows 98 I'm asking this because the setup file asks for windows installer 3.1, but this version of windows installer is not available to win98, only 2000, 2003 and XP. Is there any other version of windows installer that will work with the setup application or I need to change anything in the way I generate the deployment package The application was written in vb. Thanks a lot for all your time and attention. Cheers. Rodrigo. andradrr, If you install the .NET Framework 2.0 on your Windows 98 OS, it is possible for you to use the ClickOnce deployment. I search the MSDN, nearly all the ...Show All

• .NET Development Why are there extra items in List after deserialization

  Actually, I know why. What I need to know is the best way to get around this. Here's the deal: I have a class that exposes a List<>. In the constructor of this class, a couple items are added to the list. i.e.    public class MyClass    {       private List<OtherObject> m_list;       public List<OtherObject> List      {          get { return m_list; }          set { m_list = value; }       }       public MyClass()       {      ...Show All

• Visual Studio 2008 (Pre-release) XLinq XElementSequence.DescendentNodes() Doc Inconsistency

  The XLinq Reference that came with the May 2006 CTP seems to be inconsistent in the description of XElementSequence.DescendentNodes method. It states it returns an IEnumerable<XElement>, but is prototyped (and named) to return an IEnumerable<XNode>. I assume the description of the return value is wrong, due to the prototype and method name, as well as the fact that the method does indeed return nodes (elements, processing instructions, comments, etc.) as opposed to just elements. ...Show All

• SQL Server Unable to update XML attribute designated as xs:SimpleType

  Hello, I am trying to update an XML attribute which is designated in my schema like this: <xs:attribute name="SpecialFloodHazardAreaIndicator"> <xs:simpleType> <xs:restriction base="xs:NMTOKEN"> <xs:enumeration value="N"/> <xs:enumeration value="Y"/> </xs:restriction> </xs:simpleType> </xs:attribute> My sql looks like this: UPDATE XMLDATA SET XML.modify('declare namespace MISMO="http://mrgdev.local/mismo/";replace value of (/MISMO:LOAN/MISMO:_CLOSING_DOCUMENTS/MISMO:CLOSING_INSTRUCTIONS/@SpecialFloodHazardAreaIndicator)[1] with sql:variable("@FloodInsRequired ...Show All

• Audio and Video Development JScript HDi Intellisense for VS2005

  Is there a way to get hdi jscript intellisense into VS2005 HD DVD uses "real" ECMA-262 for the most part, but It uses the compact profile (327), which means no eval , Function constructor, or with blocks It doesn't include the optional Annex B functionality (like substr or octal literals) It requires semicolons Everything else is host-specific (ie, the Annex Z APIs from the HD DVD spec) Unfortunately I don't know of a way to make IntelliSense better in VS... :-( ...Show All

• Visual Basic reset password while logged in as another domain

  hi , currently where i'm working there is a need for some users to use multiple Windows domains... For example CONTOSO and NWTRADERS (ok we don't use these domains, but for example's sake) The users log in under NWTRADERS and use Run As... to run programs that still needs to use CONTOSO credentials... Network drives are also mapped with CONTOSO credentials while logged in as NWTRADERs... I would like to create a utility that would le tthe user know when their CONTOSO password is going to expire, and allow them to reset their contoso password, but requiring them to enter their original password first... Basically invoke whatever windows does when you press Ctrl+alt+del then click Change Password... , except for a domain o ...Show All