Paul Nystrom's Q&A profile

• Windows Forms Automating Interaction with Remote Sites using the WebBrowser Control

  We have several remote customers who, in order to save time, require us to interact automatically with their web sites (automated data entry, data retrieval, etc.) yet will not allow us direct access to their databases or web hosts. And these customers do not provide Web Services. In the past we have used the AxWebBrowser web browser control to build 'wrappers' around our customer's web sites - this worked well UNTIL we migrated to VS 2005. The WebBrowser control in VS 2005 appears to have lost several events that made our 'wrappers' possible; for example, we see no equivalent event for WindowClosing which tells us when our customer's ...Show All

• Visual Studio Team System Upgrade RC to RTM

  Is it possible I only found information about how to upgrade from B3R to RTM. Can I just uninstall RC and install RTM Regards, Max Hi Max The following posts should answer your question: http://blogs.msdn.com/team_foundation/archive/2006/03/06/544808.aspx http://blogs.msdn.com/robcaron/archive/2006/03/17/554115.aspx Regards Michael ...Show All

• Windows Forms Form Resizing Problem

  I've got a basic hex editor that I've been working on to help myself learn VB.NET.  I have a form with 3 panel controls on it.  The offset panel on the left, the hex panel in the center, and the ascii panel on the right.  I've overridden the paint procedures for them, and I have been manually controlling the resizing of the for ...Show All

• Visual C# Windows Start Button

  How can mimik the windows start button without component please thank you Fahd looks great! how can I keep the button held thank you guys for your help!! ...Show All

• .NET Development problem with enum

  I am using Visual C++ .NET Beta 2 ... I have ported some code where an enumeration from a class library was viewable in the Object Browser. I can no longer use _value unless I use /Clr:oldcode -- but when I use that I lose the ability to set /Doc which I would like to use to generate XDC files. Any suggestions If I understand correctly, you want to know how to create managed enums using C++/CLI. Please tell me if this is wrong. To create managed enums in C++/CLI, you would use the following code: public enum class day {   Sunday = 0,   Monday,   Tuesday,   Wednesday,   Thursday, &nbs ...Show All

• Visual C++ cannot convert from 'LRESULT

  I have a MFC Application that creates a thread to do some processing. I am able to pass event messages from the thread to the main program. But, when I used similar logic to pass a message from the main program to the thread, I get this error message in the thread's .cpp file: Arc220Thread.cpp c:\Visual Studio Projects\mh53\mh53\Arc220Thread.cpp(16) : error C2440: 'static_cast' : cannot convert from 'LRESULT (__thiscall CArc220Thread::* )(WPARAM,LPARAM)' to 'LRESULT (__thiscall CWnd::* )(WPARAM,LPARAM)' None of the functions with this name in scope match the target type The error message concerns this bit of code in the thread: BEG ...Show All

• SQL Server WMI alerting error

  After installing SQL Server 2005, I tried to create a WMI alert by doing the following: USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Database Created', @enabled=1, @delay_between_responses=0, @include_event_description_in=0, @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER', @wmi_query=N'SELECT * FROM CREATE_DATABASE', @job_id=N'00000000-0000-0000-0000-000000000000' GO This produces: "The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct synta ...Show All

• SQL Server How to encorporate IF

  How can I put an If statement saying If # RECORDS returned from the query below IF  # records returned is > 1 then     SUM(rmstranamt) AS  rmstranamt10   ELSE rmstranamt AS  rmstranamt10   here's my statement ------------------------- SELECT     RMSFILENUM,           rmstranamt AS rmstranamt10   <-----If statement goes here base on if the amount of records found in select is >1 or not FROM RFINANL WHERE RMSTRANCDE = '10' GROUP BY RMSFILENUM, rmstranamt ) AS rf10 ON rf10.RMSFILENUM = rm.RMSFILENUM     ...Show All

• Windows Forms scrollbars in windowsforms

  I have a form with a maximum height, the width always the same. When the maximum height is exceeded, scrollbars automatically appear. I want to keep the vertical scrollbars, but a horizontal also appears, because the vertical one is placed inside the form. (the width of the vertical scrollbar is the width which the horizontal appears for) How can i solve this problem Adjusting the width of the form doesn't help. I really want the horizontal scrollbar to go away, because it's very ugly. I think it's a combination of changing some values but I can't find it. Thanks! I don't know if this ...Show All

• Visual C++ My Visual Studio does not load stdafx.h & stdafx.cpp in my project file

  Whenever I create project file it won't work because stdafx.h and stdafx.cpp files are not preloaded into the project file, how do I fix this problem Thank you for your input on my problem and your wise thoughts on my future.  I appreciate your time and effort on everything.                         Fellow Programmer,                                    ...Show All

• Windows Forms Column spanning cell editor

  I have got display of colunm spanning cells working in the datagrigview control bydrawing in the RowPostPaint event handler. However, I cannot seem to find the correct event to handle in order to change the size (and if necessary, type) of the cell editor. Can anyone point me in the right direction  Thank you, this has helped a lot. Seein ...Show All

• Windows Forms ClickOnce Installs fail, ADODB 7.0.3300 required?!

  While trying to use the new ClickOnce in 2.0 (RTM), the installs fails on the majority of machines.  I receive the error that says.  "Unable to install or run the application.   The application requies the assembly ADODB 7.0.3300 to be installed in the Global Assembly Cache (GAC) first." The only 2 depenencies that this app requires is the .NET Framework 2.0 and the report viewer pack.  I believe it the report viewer pack is causing the problem.  Any ideas or suggestions on this problem   If I can't use apps that use the new reporting controls then clickonce is basically worthless for the majority of ...Show All

• Visual Basic Auxiliary file locations in VB 2005

  Compared with pre- .NET versions of Visual Basic, VB 2005 generates a number of additional files, mostly in project subfolders like Bin, My Project, and obj: .pdb, .resources, .cache, .vshost.exe files, and the like. So far as I can tell, they're auto-generated perhaps at build time, but because they reside in the folder tree with the source files the whole collection gets backed up, ballooning the backup unnecessarily. Is there a way to break out those files into another location separate from the source and form-design files you can set the build output path to a location outside of your project location. ...Show All

• SQL Server sql in C# Select

  What is wrong with is sql statment. I get a error in the sql statment public string GetAccessLevel( string UserName) { string sqlString = "SELECT MentorUserName, MentorAccess FROM MentorUserAccess WHERE MentorUserName= " + UserName "; } Also, you should not use string concatenation to prepare the sql command. You open up your sql statements for sql injection, use SqlParameters instead: string sqlString = "SELECT MentorUserName, MentorAccess FROM MentorUserAccess WHERE MentorUserName=@UserName"; SqlCommand sqlCommand = new SqlCommand(sqlStr ...Show All

• Windows Forms Simple column sorting in a datagridview

  I am binding a custom class to a datagridview (like List<Orders>). Everything appears to be working just fine except sorting on column headings. They are all set to 'automatic'. ANything I am missing Thx. ...Show All