xeondev's Q&A profile

• Windows Forms Rotating rows and columns in DataGridView 2.0

  If only there was a way to display rows instead of columns and columns instead of rows in DataGridView .NET Framework 2.0! In another word rotate the DataGridView 90 degrees. In one of the responses that I found in my google search, posted by Jeffrey Tan (Microsoft Online Partner Support), he indicates that it is do-able in DataGridView 2.0 using Vitual mode, as he says: "Anyway, we can do the rotating in .Net2.0 DataGridView control without resorting to third party control now.". Well, if all the columns were the same, simple TextBoxes it would have been easy I imagine and I think that is what he may have been thinking. However, I have a DataGridView that the columns have different type of controls, like one column has ...Show All

• Visual Studio Team System Schema Compare Problem #5

  I am comparing a Database to a Project. One table is showing up as being different. Here is what DBPro reports as the difference: In the Database: [DefaultPerformanceEmailText] [nvarchar] ( max ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , In the Project: [DefaultPerformanceEmailText] [nvarchar] ( max ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_HumanResourcesPolicy_DefaultPerformanceEmailText] DEFAULT ( '' ), When I click the 'Write Updates' button to synch my Project, DBPro says everything was successful but when I do a recompare, this same difference reappears. DBPro is not removing the constraint. Thanks - Amos. Gert, I have 2G of RAM. All ou ...Show All

• SQL Server Stored procedure issue. a bridge too far for me

  i have a query that i need to extend but just dont have the knowledge to do so, so hoping someone here could help me this is my current query:- SELECT ES.PatientID, DATEDIFF(day, EP.DateofBirth, GetDate())/365 AS Age, CASE EP.SexCode WHEN 'M' THEN 'MALE' ELSE 'FEMALE'END AS Gender, COUNT(H.HRDID)AS HRD, ES.FourRegularDrugs, isnull(ES.FourRegularDrugsNo,0) as NoOfDrugs, ES.ReadmissSixMonths, PCE.[Primary diagnosis] FROM tblStudyServices ES INNER JOIN tblPatient EP ON EP.PatientID = ES.PatientID INNER JOIN PAS.dbo.[PAS Patient Details] PP ON PP.[PAS key] = EP.PatientInternalNumber INNER JOIN PAS.dbo.[PAS Admission Details] [PAD] ON [PAD].[PAS key 1] = PP.[PAS key] INNER JOIN PAS.dbo.[PAS Consultant Episode] PCE ON PCE.[PAS key 1] = PA ...Show All

• SQL Server ParallelPeriod, Subcubes, and SP2

  We're defining some KPIs that include trend expressions which use the ParallelPeriod function to calculate the change in a KPI value since a past time period. For example, we calculate the change in the KPI value When we use an MDX SELECT with a WHERE clause that specifies a time slice, the expression evaluates correctly. However, when we use CREATE SUBCUBE to do the filter, or use BI Studio (which creates a subcube), the result is incorrect. In particular, the there's an IsEmpty check for the parallel period of the KPI value, so we're not doing bogus math when there's no data for the previous period. With the WHERE clause, that works fine, but with the subcube, the ParallelPeriod always evaluates to empty. As a point of comparison, I t ...Show All

• Windows Forms Right menu in my computer window??

  How can I add in my application a menu like the right blue menu in my computer window Is this possible thank you very much!!! here we can find some sample of xp style menu http://www.codeproject.com/jscript/leftmenu.asp ...Show All

• Visual Studio Team System Orphaned branch

  I’m having some issues with a branch and need some assistance to diagnose the root problem. For some unknown reason, a portion of a branch doesn’t act as if it has a trunk any longer. When I try to perform a merge from that subdirectory it doesn’t show a “target branch” in the dropdown box. It acts as if this subdirectory is an orphan with no parent branch. We are trying to merge bug fixes from this branch back into the mainline and are quite perplexed as to why this has happened. About a week ago we were able to merge files from the subdirectory back to the main branch, so something was done since then to break this functionality. What can I do to diagnose this issue Was the dir deleted and re-added If you run merge /preview from ...Show All

• Visual Studio Express Editions External Tools

  Help tells me to goto Tools->External Tools to add an external tool such as the resource compiler. When I click on the ellipsis I am taken to C:\Program Files\Microsoft Visual Studio 8\Common7\IDE. When I go back one level and open Tools there is no bin folder. Help says that is where the Resource Compiler resides. I have gone so far as to remove VB 2005 Express and reinstall. What in the world am I doing wrong It's under Common7\Tools\Bin . james aka:Trucker       Edit, sorry, I missed that you already checked the Tools\Bin folder. You probably need to install the 2.0 SDK. Here is the link to download the SDK. (hope you have DSL or similar, it's a large download for th ...Show All

• Visual Studio Express Editions DataSet Update

  Hello everyone, This is probably a really stupid question, but I’m stuck… … I have crated a from with all the trimmings (looks very nice, honest), I have a panel item (pannel1) at the bottom containing 3 buttons (btn_new, btn_update, btn_close), above this I have a SplitContainer item (splitcontainer1) which the left panel contains a ListBox item (lb_name), and the right side contains three TextBox items (txt_fname, txt_sname, txt_phone), and 2 buttons (btn_save, btn_cancel). Now I have created my connection to my DataSet (address_ds) by clicking on that nice little arrow in the top right corner of lb_name, this in turn created addressDataBinding and addressTableAdaptor, I have also bound txt_fname.text, txt_sname.text and txt_ph ...Show All

• Visual Studio take too much time to add an item in the class designer

  Hello, Thanks for the reponse. I have another question, why it takes so much time when i add an item in the class designer. thanks boyi Hello boyi, As far as I know the only thing that pops to my mind is the OS - Win2K3 Server SP1 - that you are running. We will have some one take a look to see if Class Designer has perf issues in that OS. A couple of more things - do you see this perf degradation on any project could you try it with a C# project and see if you still see the slow perf Can you try the same in a client OS, Win XP (with the same project) Thanks, Ramesh Rajagopal. ...Show All

• Visual C++ "Layered" precompiled headers

  Hi, I'm reading the book "C++ templates, the complete guide", and in section 6.5 the writers suggest to use layered precompiled headers. With that they mean to have multiple precompiled headers, but also to have a precompiled header to use another precompiled header, as if it inherits the other precompiled header. For instance, have one header containing all std includes like vector, list, string etc. This is a header that is unlikely to change a lot. You will create the first precompiled header from it. Let's say we put it in std.h. The second precompiled header need all stl headers and some of our own, which are likely to change every now and then. We want to avoid recompiling the stl headers when a change is made in t ...Show All

• SQL Server Access 2000 Upsizing Wizard add-in

  Hi, I want to upsize a db from Access to SQL Server. I have a version of Access 2000 that has not got the Upsizing Wizard add-in loaded, and can't find the install disc. Does anyone know if it is downloadable, and if so, from where Thanks Thanks, I finally managed to find the install disk so all is good now. ...Show All

• Smart Device Development Smartphone projects and IE7 = broken

  I'm trying to follow the HOL exercise at http://msdn.microsoft.com/windowsmobile/reference/GettingStarted/default.aspx pull=/library/en-us/dnppcgen/html/med304_msdn_new_native_wm_features_vs2005.asp First I was unable to create the Visual Studio C++ Smartphone project - problem was solved using the registry hack described in this thread amongst others: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1131651&SiteID=1 However, I then hit a very similar problem when trying to use the Add Property wizard: Internet Explorer Script Error, line 731, char 5, "object doesn't support this property or method", code 0, URL file:///C:Program%20filesMicrosoft%20Visual%20Studio%208/VC/VCWizards/CodeWiz/ATL/Property/HTML/10 ...Show All

• SQL Server SQL Server 2005 SP2 CTP Version

  Hi, I m using Windows 2003 Server. I installed SQL Server2005 and now i want to apply CTP service pack on it. I downloaded all the SP2 patches available on the site http://www.microsoft.com/downloads/details.aspx FamilyID=D2DA6579-D49C-4B25-8F8A-79D14145500D&displaylang=en . Each of them is giving an error and it is not getting installed on SQLServer 2005; Is it a problem with my hardware or the version of Windows or the version of SQLServer 2005 Can anyone help me with this problem THanks, Srividya Yes I tried to install SQLServer2005SP2-KB921896-x86-ENU.exe but I m getting an error saying this exe is not a valid win32 application. ...Show All

• Visual Studio 2008 (Pre-release) 3D animation Performance

  Into a Canvas filled with (about 20) static 3DGeometry rectangle-shaped, each one texturized by images or MediaVideo, I'm moving a PerspectiveCamera with 2-seconds animations. I notice a quite poor performance on this; every animation shows not more then 20 different frames on a Hp xw6200 with NVIDIA Quadro NVS 285 128 MB. Animation is applied both to position and lookdirection properties of camera. I appreciated no significant progress using only images texture. Anyone has any kind of tips to apply to this It should be a better choice animate single shape instead of moving the whole canvas (moving camera) from performance point of view Some video seen on channel9.msdn.microsoft show very fluid and fast 3D animations, so where is my ...Show All

• .NET Development Excel Interop..excel.exe process still alive

  Hi, I need to realize a multisheet formatted excel file from an asp.net (c#) web page. I thought to use Excel Interop but I've some problems when I try to kill excel process after file generation.. I've read several threads about this argument on this forum and it seems to me that I'm driving in the right way.. but excel.exe process never die.. this is the class I wrote is this: using System; using System.Data; using System.Configuration; using System.Reflection; using System.Runtime.InteropServices; using System.Web; using System.IO; using Microsoft.Office.Interop.Excel; namespace FileHandler { public class ExcelManager2 { private string strPath = HttpContext.Current.Server.MapPath("./"); public ExcelManager2() ...Show All