dvh's Q&A profile

• SQL Server Union Ordering

  Hello, I'm attempting to run three separate queries and have them returned as one recordset. I need to show the top 10 customers based on the number of orders they placed for each of three months, then combine them to give a representation of which customers have been within the monthly top 10 for the overall period of three months. My problem is when I run a count on the number of orders they have placed and order by that count, it is in ascending order which in escence shows me the bottom 10, not the top 10. To resolve this issue, I can specify descending order. This works fine with one query, but when I run all three queries using union statements, I can only have one order by which returns incorrect results. Here is my query. In thi ...Show All

• Visual Basic Full Socket Methods...

  This is in relation to my last post, 'Chat Clients in VB'. After much searching of the help files and online content, I haven't been able to find a full socket method example in VB. This is annoying as I cannot learn how to structure the socket class i need to write... Can anyone help me, have a website link or have a file which has a full socket method that can be sent to me so that i can learn the structure. Thank You, Nick Rawe ahmedilyas- this is very helpful, but can it be modified for a server/client chat service. my idea is that i would have a server come online and create a socket for use and then listen for incoming calls while sending out a signal every few minutes. the client would listen on the po ...Show All

• Visual Basic ToolStripButton (VB.NET 2005) - how to remove the square which appeare at mouse over.

  Hello all, Is there possible to remove the square effect, which is visible at mouse over for an item of a ToolStrip control I want to remove this effect since i need to put my own effect, i want to set an image for a ToolStripButton and, on the event MouseHover to change this image. I made this but still remais the native effect with the square. I mention that i used an image with round corners and with transparent background. Thanks. leo,poteleanu, According to your question, I suggest you to pay more attention to the RenderMode property of ToolStrip control. The default RenderMode value is ManagerRenderMode, however, when you change the value to System, then run the form application. You can see your ...Show All

• SQL Server Time Calculations and Calculated Measures

  Hey Guys, I have used the following document to create some time intelligence in the cube as the standard way that is in SSAS didnt fit to what we wanted. http://www.obs3.com/A Different Approach to Time Calculations in SSAS.pdf I have implemented the suggested solution and it works well, although i cannot add in a calculated measure in the scope statement. Everytime i do, i get the following errors: Error 1 A set has been encountered that cannot contain calculated members. 0 0 Error 2 MdxScript(Sales By Market) (51, 1) A set has been encountered that cannot contain calculated members. 0 0 Error 3 The END SCOPE statement does not match the opening SCOPE statement. 0 0 Error 4 MdxScript(Sales By Market) (118, 1) The ...Show All

• Software Development for Windows Vista Looking for Developer

  Hello All, My company is currently interested in developing tools for the Tablet PC. We would like to establish a relationship with a developer who is knowledgeable with this platform. If anyone is interested in possible application development for Tablet PCs, please contact me at vpetrillo@spellex.com . Or if anyone would happen to know where we could find developers for the Tablet PC, please let me know Thank you in advance for your assistance! Best regards, Vince ...Show All

• Visual Studio Team System TF source control structure and bug fix processes for large web projects

  Reading the thread Team Project Version Control Organization got me thinking about the source control structure of my current project, an asp/asp.net based commercial web site. The source code, along with all static files are stored in Team Foundation source control. The site and the components are split up into several areas (folders), each containing a number of .NET solutions, using a structure like this: $/WebDev - CompA - CompB - CompC - WebUtil - MainPortal - SubSiteA - SubSiteB - SubSiteC $/WebRelease - Production - CompA - Ver 1.0 - ThreadingHelper\ThreadingHelper.sln - LoggingHelper\LoggingHelper.sln - ... - Ver 1.1 - CompB - Ver 1.0 - Ver 2.0 - WebUtil - Ver 2.0 - WebMonitor\WebMonitor.sln ...Show All

• .NET Development impersonating the user initiating an action over the network

  I am trying to write a simple server/client application that will perform operations on the server using the permissions of the person running the client. I have saught to do this by serializing a WindowsIdentity object representing the client and sending it through a NetworkStream that is connected to the server (which will run as a windows service). Then I attempt to impersonate the user on the server using the WindowsIdentity object. Well, aparently the WindowsIdentity object does not contain a full set of credentials because once it gets to the server it simply sais that the handle is bad. I can see how this situation would happen, but what to I need to do to transmit the user's security token to another comput ...Show All

• Windows Live Developer Forums Reducing Browser Memory Leaks

  I spotted this in the google API documentation and wonder if it has been address in VE Reducing Browser Memory Leaks The Google Maps API encourages the use of function closures , and the API event handling system GEvent attaches events to DOM nodes in such a way that almost inevitably causes some browsers to leak memory, particularly Internet Explorer . Version 2 of the Maps API introduces a new method, GUnload() , that will remove most of the circular references that cause these leaks. You should call GUnload() in the unload event of your page to reduce the potential that your application leaks memory: Hey for those of us who can't directly edit the page, in my case i'm inside a CMS, can we add the following in our js code ...Show All

• SQL Server Using SSIS packages to process SQL Server 2000 OLAP Objects

  Can a SSIS server, i.e. staging server be used to create packages that update SQL Server 2000 Analysis services objects on another server running SQL server 2000 OLAP   It appears that the OLAP connection manager ion SSIS supports only connections (and thus updates) to 2005 OLAP objects.  I work for a company that has a huge investment in a 3rd party DW that uses Analysis Services 2000.  the DW tool vendor will not support an upgrade to SSAS 2005.  We wish to extend the DW from other data sources.  My thought was to use a staging server with SSIS, used solely as the ETL tool for all new development (thus no more DTS development), and to update the sql server 2000 operational data st ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. "The project type not supported by this installation"

  Any clues as to the cause of this error whenever I open templates Alex, I've investigated possible causes of this error, and it seems the most likely issue is that some XNA-related registry entries have been corrupted. This could be the result of a failed install/uninstall of Beta 1 that left something behind that is interfering with the Beta 2 installation. Here is what I suggest. Uninstall XNA Game Studio Express Beta 2 Uninstall Visual C# Express Start regedit.exe, and delete the following registry keys (including all subkeys): HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\XNA Re-install Visual C# Express Re-install XNA Game Stud ...Show All

• Visual C# Translucent Image

  I would like to know how to determine the color of a translucent image when it is on top of another image. To better explain it, for example, let say I have 2 images A and B and B is a translucent image and is on top of A. I would like to know the RGB values of the overlapping area of image B. I know I can use GDI+ to create translucent images and it will do the rest for me. But that's not what I want, I would like to know the way to determine the color. Thanks in advance. The easiest way is to draw the images and get the resulting color, as suggested. If instead you want calculate the result without drawing, I think the formula is something as follows: Assume we have two pixels, one with components a, ...Show All

• .NET Development Trying to Install "Windows Worlkflow Foundation Beta 2 (build 3.0.3807.7 or later)" for SharePoint 2007

  Hi, I'm trying to install SharePoint 2007. It prompts me to install "Windows Worlkflow Foundation Beta 2 (build 3.0.3807.7 or later)". I'm using the following site as a guide ( http://technet2.microsoft.com/Office/en-us/library/f49862ab-e067-4723-bb90-7eb1182c65ce1033.mspx mfr=true ) on that page it says to go to here( http://www.microsoft.com/downloads/details.aspx familyid=5C080096-F3A0-4CE4-8830-1489D0215877&displaylang=en ) to download the "Windows Worlkflow Foundation Beta 2 (build 3.0.3807.7 or later)". When I follow the link I find an option to download 1) Visual Studio 2005 Extensions for Windows Workflow Foundation Beta 2_2(EN).exe 2) Windows Workflow Foundation Runtime Components Beta 2_2(EN) for x86.exe ...Show All

• Windows Forms TextbBox size in GridView Edit mode

  I have a GridView with a field that contains long strings of text. I would like to make the grid directly editable, rather than using a details view. I finally figured out how to make the TextBox in the Edit view bigger, but I cannot find option to to make the text in it wrap or for adding scroll bars. Is there a way to accomplish what I'm trying to do, either with control properties or through manual coding Thanks in advance for your advice. Steve I struggled with trying to prevent text from wrapping in my GridView and have come to the conclusion that NONE of the property controls seem to be able to provide "Wrap=False". I solved the presentation issue by setting the column to a template ...Show All

• SQL Server DTExec via xp_cmdshell

  In my previous post here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044739&SiteID=1 Michael Entin provides a number of responses to my questions regarding programatic execution of remote SSIS packages. Having experienced some significant reliability problems with the Microsoft.SqlServer.Dts.Runtime components from an ASP.NET process (the page either times out, or inevitably just stops responding), I have been prototyping the DTExec command option which Michael suggests as being a better approach to remote programability. So, off I've been prototyping this all day today... I have a stored procedure that wraps a call to xp_cmdshell which takes the DTS (DTEXEC) params as a big long argument. This scenario would h ...Show All

• Windows Forms datagridview doesnt save in editmode

  Hi, I'm unable to save when a column is in editmode. it doesnt save the new value. it shows only the last saved value for the column under editing. thanks venp-- Hi, If i setfocus on some other control before saving the data, it works. But still i need to know proper way of doing this. Venp-- ...Show All