Mathew84's Q&A profile

• Windows Forms Customizing DataGridView Selection Behavior

  I'm currently trying to use a datagridview to allow the user to select multiple items from a table. While the multiselect functionality will work for what I want. I would prefer to have the program only change the selection of the current cell when a cell is clicked. Or to basically have the program act as if the user was always holding down the Ctrl key for selection purposes. Additionally, I would prefer if I could also restrict selection based upon the value in the cell being selected. Looking around the net, I found vague references to being able to disable the ordinary selection behavior. However I have not been able to find ...Show All

• SQL Server Change query issues

  I am trying to take this statement: Select Total = SUM(gt) FROM (Select Distinct CustomerName, CustomerNumber, FeeGoal_AZ AS FG, FeeSchedule, (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt from DCR WHERE branch='00002' group by CustomerName, CustomerNumber, FeeGoal_AZ, FeeSchedule ) as dTable and change up (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt I need that part to do this instead there: (PostedAmount + Sum of all PDC where the PDC in this month + Sum all CC where CC in this month) / FeeSchedule) * 100 as gt Here is my failed attempt: ...Show All

• Smart Device Development Pocket PC SQL CE problems

  Hi All, I am really new to the .NET, C#, CE world and am working on a project with some pressing deadlines. Please bear with me. I've been having a few problems with the namespaces, let alone pulling the data. For some reason the namespaces,    using System.Data.SqlServerCe;    using System.Data.SqlCeEngine;    using System.Data.SqlCeEngine.SqlCeRemoteDataAccess; are not being identified during the build. I looked up the references and SqlServerCe is already present inthe references. Is there anything else I need to do to remove this error I am not using SqlServerCe anywhere in the code but I was wondering about ...Show All

• Visual Studio Express Editions Concat variable names

  Hello, I create in my form on-the-fly objects (textboxes). Each object get a name, for example txtAantal1, txtAantal2, etc. With an addhandler, I couple a Sub. In this Sub, I want to use an object value. I know that an object name begins with txtAantal and I know the number. For example: txtAantal 1 How can I use it als txtAantal1 As a textbox, so that I can use the value txtAantal1.Text Yea, it works, but Text isn't a special property for TextBox control... ...Show All

• Visual C++ ATL80.DLL from VS2005 RTM won't start on NT4

  If an attempt is made to load the RTM ATL80.DLL on NT4, an error message is shown complaining that the import GetLongPathNameW could not be found in KERNEL32.DLL and as such, the process cannot start. As the MSDN docs for GetLongPathName() show, it's very simple to work-around this problem in source-code (ie static library) by including NewAPIs.h.  However when linking with ATL80.DLL this solution is not possible, since ATL80.DLL does not do this, and I can't make it do it without re-compiling the DLL. So why not just link with ATL statically   Well, I have just added support for ActiveX control containment to my app, which ru ...Show All

• SQL Server Insert into more than one table

  I have this select command SELECT intUserId FROM tblUser I want to insert every intUserId into tblUserBla,tblUserBla2 I know that i can do this INSERT INTO tblUserBla (intUserId) SELECT intUserId FROM TblUser But, how can i perform a insert into tow tables, in one statement this will be the body of the after insert trigger on the first table insert into [2nd table] select intUserId from inserted which will insert only the newly inserted IDs ...Show All

• Windows Forms Save datagridview layout to file

  Hi, I want to save a datagridview layout to a file. Not the data - just the columns, their formatting and the fields they are bound to. Can this be done (and how!) Paul. I don't know if this is what you're asking for, but this article helped me: http://msdn2.microsoft.com/en-US/library/system.configuration.applicationsettingsbase(VS.80).aspx It's not for a UserControl, but it should be similar - apply the example code for a UserControl instead of a WinForm, ...Show All

• Visual Studio Team System VSTFS on Intel Itanium2 (IA64)

  I wanted to know whether VSTFS Beta 3 Refresh is compatible with Intel Itanium2 it is because i read from here: http://support.microsoft.com/default.aspx scid=kb;en-us;908452 "1.3.1 Installation of Visual Studio 2005 on the Intel Itanium (IA64) is not supported. Visual Studio 2005 does not support the Intel Itanium (IA64) processor" or it is only for Team System anyone help me.. You can install the Team Foundation Server DATA TIER on IA64.  This is the ONLY component in TFS that is supported on IA64. Please see Rob Caron's blog for more info on this topic (although I don't think it mentions ...Show All

• Visual Studio Express Editions How to move the label BOX to the middle.

  Hi im a student using visual studio and i need to know what codes do you put in your button to make my label move to the middle of the screen.. Even when the window is enlarged or minimized the label will also go to the middle instanly when the button is click.. pls help me! You seem to me to be asking two questions 1 - how do you make a button click do something ( double click it in the design view, and the IDE will generate a method that is called when you click the button ) 2 - how do you move the position of a label - all controls have Left and Top parameters, which you can set. Getting the exact p ...Show All

• Visual Basic Convert a long into a dword

  The registry setting below hides\shows the my document's icon on the desktop. I'm having a problem entering the appropriate values. Both methods below give aconversion error at runtime. If I don't specify the value type, a reg string value is created, but the value needs to be a dword. Private Sub HideShow( ByVal iconvisible As Boolean ) If iconvisible = True Then My .Computer.Registry.SetValue( "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\CLSID\{450D8FBA-AD25-11D0-98A8-0800361B1103}\ShellFolder" , "Attributes" , Hex(4030726516), Microsoft.Win32.RegistryValueKind.DWord) Else My .Computer.Regi ...Show All

• Visual Studio Team System HTML formatted results from Unit Tests

  Hi there, I am converting our project which has used NAnt and NUnit to (primarily) use MSBuild and MSTest. The only thing that I am really missing is an equivalent of the <NUnitReport> task that reads teh XML results file(s) and produces a pretty HTML report of the results. The report was very useful for mailing out in the build success/failure notification and can be easily viewd from machines that don't have VS2005 installed. It also made it very easy to drill down to any failing tests. Does anybody know of an equivalent or similar XSLT file for formatting the txr file I have done a fair bit of searching and I haven't been a ...Show All

• Windows Forms Overwriting Files (Permissions)

  How do I use the FileIOPermission Class to copy a directory of files (or overwrite them) when some of the files to be overwritten are read only or the path could be on another drive This is because I keep getting the Access is denied - System.UnauthorizedAccessException I am using the DirectoryInfo/FileInfo Classes with CopyTo... with boolean overwrite set to t ...Show All

• Visual Studio Team System How do I download Team Foundation Server (Full) ???

  I have an MSDN subscription (Visual Studio 2005 Team Edition for Software Architects). When I go to subscriber downloads, under "Team Foundation Server", there are two products listed: Visual Studio 2005 Team Foundation Server Trial Edition (English) Visual Studio 2005 Team Foundation Server Workgroup Edition (English) How do I get the full version of TFS Thanks After spending many days trying to figure out this, I've finally understood... First of all, let's get one thing straight. Regardless of you MSDN subscription level and/or your Certified Partner level. The Micros ...Show All

• Visual Studio Team System Throw exceptions by new WorkItemStore(server)

  The following exception is thrown. VSTS API seems to have issues supporting multi-app domain processes like WORD. Please advice how to bypass this issue. Thanks,Yuhang. Cannot pass a GCHandle across AppDomains. Parameter name: handle ************** Exception Text ************** System.ArgumentException: Cannot pass a GCHandle across AppDomains. Parameter name: handle at System.Runtime.InteropServices.GCHandle.InternalCheckDomain(IntPtr handle) at System.Runtime.InteropServices.GCHandle.FromIntPtr(IntPtr value) at CProdStudioObjectRoot.{dtor}(CProdStudioObjectRoot* ) at ___CxxCallUnwindDtor(IntPtr pDtor, Void* pThis) at C ...Show All

• Visual Studio Team System ASP.NET Unit Tests do not handle Redirections in Beta2

  Hi, Is there any workaround in order to use redirection in unit-tests I always get the message " The web site for page '<web site>' is not properly configured for testing. Check that Visual Studio Team Test tools are installed on the web server. " when running the test. In the known issues ( http://lab.msdn.microsoft.com/vs2005/get/currentreadme/VSKnownIssues.rtf ) it is described that ASP.NET Unit Tests do not handle Redirections in Beta2. Thanks. Unfortunately we won't be supporting redirections in beta 2 or the final release. The only workaround is to specify the site that would be redirected to as the UrlToTest (so ...Show All