RFaircloth's Q&A profile

• Windows Forms Column Visiblitiy ?

  Morning all, Have been in the .ASP world for a while now. This is my first real windows app in .net. I have a grid with 5 columns. I want the last last invisible to the user. Heres my current code:  With dbGridOrderList      .CurrentRowIndex = 0      .Select(0)      .Visible = True     '#### Make last Column invisible  ...Show All

• SQL Server Matrix subtotal problem

  Hi, I have a matrix report like this, 　 Product 1 Product 2 Product 3 subtotal Dept A 　 　 　 　 Dept B 　 　 　 　 … 　 　 　 　 subtotal 　 　 　 　 for some issues, I must add a group filter to filter out some departments that I don't want to show them on this report (ex. Field!dept.value !="A"). Additionally, My users can input the date interval to query by report parameters. When the date interval user inputed only have Dept A data , the report return some error message(I have set the norows property to show "nodat ...Show All

• Windows Forms Setup/deployment project - conditional installation of shortcuts

  I've created a setup/deployment project.  I want to conditionally create a shortcut to one of my installed files in the user's Startup folder (for example).  I've created a checkboxes dialog box and assigned a condition to the first checkbox.  But there seems to be no way to make the installation of the shortcut dependent on any conditions.  If I do 'Properties' on the shortcut (in the file system view) then there is no condition property.  There must be a way to do this surely Boing!!! Surely it must be possible to conditionally create shortcuts Mike ...Show All

• .NET Development occasional "Cannot generate SSPI context"

  Can any of you experts help me out on this error “System.Data.SqlClient.SqlException: Cannot generate SSPI context” The weird thing is that this only happens occasionally, about 20 times per day [1] Client side: 1. What is the connection string in you app or DSN (please specify) "server=mydbserver; database=mydatabase; uid=; pwd=; trusted_connection=yes; Max Pool Size=10; Connection Timeout=60; Packet Size=4096; ;" 2. If client fails to connect, what is the client error messages (please specify) Category: 300 Computer Name: KATTEFOT Event Code: 0 Record Number: 54 Source Name: AltInn.eGA Event T ...Show All

• Windows Forms Application settings

  What are the circumstances for making the Save method work   Up to now I've only gotten a series of errors telling me that I don't have the access required to save the file.  That is entirely fine I guess, but the property setting I've mapped is a User setting, and so should probably be saved in isolated storage or some other location&nb ...Show All

• SQL Server Row and Cell Segurity

  I am trying to implement row-security in SQL 2005 but i make a query to make a view CREATE VIEW vwVisibleLabels AS SELECT     ID, Label.ToString() FROM       tblUniqueLabel WITH (NOLOCK) WHERE ID IN --Classification (SELECT ID   FROM tblUniqueLabelMarking WITH (NOLOCK)    WHERE CategoryID = 1 AND IS_MEMBER(MarkingRoleName) = 1) AND --Compartments 1 = ALL(SELECT     IS_MEMBER(MarkingRoleName) FROM tblUniqueLabelMarking  WHERE     CategoryID = 2 AND UniqueLabelID = tblUniqueLabel.ID) GO And the error is Msg 208, Level 16, S ...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

• Windows Forms DataGridView: prevent column reorder for one column

  It is more a beautification issue, but nevertheless what is a GUI for.... I have a DataGridView and it displays depending on the data different columns. I allow the user to reorder and resize columns, but also give him an "AutoSize" button to readjust the widths of the columns if he messes up. Because I do not know how long the data in the columns is, I start with sizing the columns by "AllCells" except the very last one (highest DisplayIndex) which I size to "Fill". Now I discovered that this looks really ugly when the last column is just a CheckBoxColumn, so to cover all cases more nicely I added one dummy ...Show All

• Visual C# Problems with the Process.Start

  Hello World, :D I have a problem that it is making me crazy, I hope you can help me. I’m trying to execute a .exe file with the Procces.Start, and there is no problem when the file is on my computer, the problem comes when the file is in a network drive. The most amazing thing is that in one computer I can execute my .Net program without problems independently if the file is in a local or in a network drive, but in others computers I have problems when the programs execute the Process.Start(). · If I pass the path in this mode: \\hermes\hermes\temp\test.exe , I have the following problem: ...Show All

• Visual Basic Variable Declare Error issue VB 2005

  I am having what I think might be a common problem. When upgrading my applications to VB 2005 from VB 2003, I have received a number of warnings regarding my declarations of local Strings without a default value assigned initially. Example of My earlier code: Dim tmpDriveType as Strin Warning treated as error : Variable 'tmpDriveType' is used before it has been assigned a value. A null reference exception could result at runtime. This is an easy fix by simply declaring the local variable as follows: Dim tmpDriveType as String = "" Not a problem, problem solved and understood. However, I have several code dec ...Show All

• .NET Development Memory Leaks in VB.NET

  How do you detect memory leaks (if there are any) in VB.NET windows application I have a medium complex VB.NET application, when it runs, the memory usage at the Windows Task Manager keeps increasing for the application even without any activity. Simply by switching to the application keeps the memory usage increase Any help is really appreciated. Hi Chris. I mentioned my thoughts on this when I was in Seattle, but I didn't actually meet the DX team.  I've also written online articles on the subject.  The book I have on MDX is apparently written by a member of the team, a ...Show All

• Visual Basic Gonna make me sound stupid

  I know this is gonna make me sound stupid, but I have to ask anyways because I have no clue.  I new at creating programs in Visual Basic. And I was wondering how to complete a program so that you can run it without having to open it with Visual Studio. For instance lets say that I wrote and alarm clock program for my labtop. Now how do I make the program so that it will work as a stand alone program without the need for Visual Basic Remember I'm new at this so please be nice.   Full_Metal wrote: Ok, scratch that last one I figured out how to put a link. Now how do i tell it which form I want it to go to Also, is there ...Show All

• Windows Forms Finding ComboBox Item By Value

  I know about the FindString() method, but it's only for the DisplayMember. Is there a way to search by ValueMember What's the normal way to handle what I want to do isthe combo box bound to a datacolumn if so, you can use the datasource and if the datasource is a datatable then you can use the find method. ...Show All

• .NET Development Microsoft.Jet.OLEDB.4.0 driver error on Win2003 SP1 & SQL2005 April CTP

  Hi folks, We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc).  Last week, one of developer sent me an email with error msg, : Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed.  I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box.  I am stucked.  Any advice would be appreciated. Sunny Will a 64 bit Jet OLE DB Provider be avai ...Show All

• Visual C++ Form HDC's

  How do I get the HDC of a windows form nothing I have tried so far works, I need the HDC so i can pass it to opengl to render to the form Call CreateGraphics on the form to get a Graphics object, then call GetHdc (and ReleaseHdc when you're done) on that. ...Show All