dbcuser's Q&A profile

• .NET Development How to set data in cells of a hidden column in a databound datagridview control?

  I am using a datagridview control, bound to a child class of a purchase order object to enter/display line detail of a purchase order. Some of the data, product ID for example, is set by program code and not the user, and so I have hidden the column. My problem is that I don't know if it is possible to set data in a cell when it is hidden. (It is the things that the help files and clients DON'T tell you that are killers, but I digress). I tried Identifying the column name but it gave me an error saying it could not find it. Has anyone out there done anything like this > I have to do it in the application What do you mean by that The application has access to the databinder and hence the ...Show All

• SQL Server Msg 8621: The query processor ran out of stack space during query optimization

  I got the above error when I tried to execute the following query delete from BUSINESS_ASSOCIATE where ba_name is null As you can see the query isn't exactly complicated. What the table does have is lots of dependancies. I got SSMS to show me all the dependancies and there are literally hundreds (maybe thousands - I'm not going to count them all) of dependant tables and i suspect that is what is causing the problem. So what do I do about it This is a valid data-model (industry standard in fact) but SQL won't let me delete data from this table and that's a huge problem for me. Any advice about how to progress would be welcomed. -Jamie Jamie Thomson wrote: Hi guys, I sure can. ...Show All

• Visual Basic Treeview with checkbox, check with color gray

  Hello, I use the treeview control with VB .net 2005. I would like to check an element and if the child element are not all check, the parent is check in color gray (not the name of node but the checkbox only). have you an idee Thanks, Ben Being unable to alter the checkbox itself I now just display an image over the checkbox. The images are 16 x 16 px. It works but slows down the program significantly so I'm still curious if it could be done via the checkbox. Private Sub myTreeView_DrawNode( ByVal sender As Object , ByVal e As DrawTreeNodeEventArgs) Handles treeComputer.DrawNode If e.Node.Checked Then Dim tmpNode As BackupNode = e.Node ...Show All

• SQL Server C# Server Explorer

  I cannot connect to a Sql Server 2005 database via Data Connections. I cannot find Server Explorer in C#. In Data Connections I use the Advanced button to reset the type from Express to MSSQLServer. My Visual Studio - Server Explorer works fine to connect to that same DB, and shows its tree, tables, and column names. So I know it is there, and working. Ideas Thanks. I'm using C# Express, trying to connect to a standard SQL Server 2005 database. I reset the data source type to MSSQL (instead of SQLExpress). Perhaps C# Express will only connect to SQL Express data sources I just purchased VS Pro 2005 + MSDN, which will arrive in 2 days. ...Show All

• Software Development for Windows Vista Test Case 32 and the WER mysterious behavior

  Test case 32 says : " This means that the application AV failure properly allowed Windows Error Reporting to report this crash" Create a new application with UI (Win32, C#, ..., whatever you want) without catching any exception, and inject the AccessViolation Failure. On Vista, the WER messagebox is always: "xxx has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available". With only ONE button "Close program". Definitively, this dialog box does not send any report to WER server. With some other applications, behavior of WER is now totally different. I get the following messagebox: Do you want to send more informati ...Show All

• .NET Development About the CustomErrors for the MBR object passed from client to server.

  In a application,I pass a MBR object from client to server so that I can invoke client MBR method at server side.And I need to know what happens when a exception occurs at the client side caused by the calling for the client MBR method,such as RemotingExecption and so on. To enable the complete exception information can be passed from client to server,what should I do. Thanks Lucian Bargaoanu ,you helped me! ...Show All

• Windows Forms Taskbar item flashing

  I am using VS2005 in a VB.Net 2 type application, and my main form has several buttons and functions which cause other forms within the same application to open. If the main form does not have focus (either out in another application, another form within the same application is open, etc) and information on the main form is updated, how can I get the item in the taskbar that represents my main form to "flash" for a period of time I am presuming I can take the same concept of the "solution" for this and apply it to the other forms within the applcation. Example, main form open, another form opens to display information, and remains open. The user then selects the main form, the second one gets updated information, an ...Show All

• Visual Studio Team System TF30063: You are not authorized to access [server]. How do I pass credentials??

  First, thanks for a much needed upgrade to the command line story! The Online command is bless :) Within VS, I always get the credentials dialog when I connect to our TFS (it's not on the same domain as my workstation, so I have to authenticate every time). The powertoys don't allow me to pass server, user and password... Therefore, everytime I execute, I get the "TF30063: You are not authorized " error. Am I missing something Err... /server works perfectly on the commands on which it is supported, but the question remains : How do I pass credentials to tfpt I didn't see any /user switch anywhere or (even better) /askcredentials. ...Show All

• Visual Studio application deployment and crystal report error

  I have developed a .net application using Visual Studio 2005. I have 2 reports that were designed with the Crystal Reports inside Visual Studio. I have a setup project within my app and have included as pre-requisites the following modules: Microsoft Data Access Components 2.8 .Net framework 2.0 Crystal Reports for .NET framework 2.0 Microsoft Visual Studio 2005 Report Viewer I then build my application in release mode to a MSI file. I have installed the MSI file on different machines. On several machines my report and data run fine -- operating system is XP. The other machines have Windows 2000 Professional Office. When i run the report, the report viewer displays but then i get the following error in a window; window title is - Crystal R ...Show All

• Windows Forms Keep control form uppermost

  I call form2 from form1. I would like form1 (control form) to always be uppermost. form2 should always appear under form1 in terms of order. Although I have set form1's toplevel = true and topmost = true, when I call form2 it still appears above form1. How can I resolve this Thanks in advance Thanks nobugz. That works almost perfect. Just 1 thing. After form2 is opened focus remains on form2. How can I return focus to the control form form1 ...Show All

• Visual Basic A program is trying to send e-mail on your behalf. Stop this message.

  Hi Does any one know how to disable this option ( A program is trying to send e-mail on your behalf. Stop this message .) I'm trying to send an auto e-mail with Marco from MS Access. I am executing this macro from VB.Net... Dim objAccess As New Access.Application objAccess.OpenCurrentDatabase( "D:\TestMacro.mdb" , False ) ' Add the Access File Path objAccess.DoCmd.RunMacro( "Macro1" ) ' Replace Macro1 with the name of your macro objAccess.CloseCurrentDatabase() objAccess.Quit(Access.AcQuitOption.acQuitSaveNone) objAccess = Nothing But every time that my script trying to send the auto e-mail, a security popup and saing "A program is trying to send automatically ...Show All

• Visual Studio Team System Deploy VSTS client application

  I am deploying a custom application, which uses TFS client API. The application depends on several dlls. Those dlls are installed as a result of Visual Studio Team Suite installation. I am writting a window installer package for the deployment. The installer package should be smart enough to know if the installation machine has those dlls already. If they are there, there is no need to copy them. This is a excellent article explaining how to use prerequiste for install VSTO application. http://msdn.microsoft.com/office/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOWindowsInstallerOverview.asp I was wondering if the same concept applies to TFS client application. Thanks very much! Yuhang. ...Show All

• Visual Studio Wrong notes for "How to: Create Custom Configuration Sections Using IConfigurationSectionHandler"

  The documentation for How to: Create Custom Configuration Sections Using IConfigurationSectionHandler states "This topic uses the System.Configuration.IConfigurationSectionHandler interface, which has been deprecated in the .NET Framework version 2.0.". Neither IConfigurationSectionHandler nor any of its members are tagged with the ObsoleteAttribute attribute. Could we get some clarification as to whether IConfigurationSectionHandler is or is not obsolete for .NET 2.0 Peter, thank your exaustive response. Digging more into this issue, I found out what may be causing this confusion. 1) Actually, IConfigurationSectionHandler is deprecated in .NET Framework 2.0 and above. But, because it is used internally, it has be ...Show All

• Visual Studio Express Editions how to make auto numbers?

  hi......how to make an auto numbers i'm creating a ticketing system which the ticket starts at smp-2000(textbox)... when i create another ticket the ticket will now increament to 1(smp-2001)....and so-on, and another thing once i close my app and open it... the ticket will now continue the count(not back to smp-2000 again) You will need to save the ticket number to an external text file and retrieve it each time you start the app. The ticket number would begin with 0 when you start the app for the first time. You initialize it as: ticket += 2000 when you start the app each time. Then you can use a loop to increment by one for each new ticket. ...Show All

• Visual Studio Express Editions Debugging only my code

  Hi there, I'm new to Microsoft sw development tools (I use Borland ones since my first hello.c in 1992, and some TopSpeed e Watcom for short periods...) and I didn't figured out how can I trace/debug only the code under Source Files sector of a Console app project without entering on CRT or STL code. May anybody help me on this matter TIA, WB:: Sure, I already noticed that, but all tools I already used behave the way I described and I think it will very annoying to check which key hit for this or that statement instead of just hit "Trace Into". Maybe a option on project proprieties or something... Thanks a lot for your time and effort. WB:: ...Show All