He Hua's Q&A profile

• Windows Forms Null Reference Exception

  Hi all -  Here is the problem.  I have a program i used in VB6 that had a set of APIs (not windows but from another program) that were referenced in a module.  The code called the api functions and they worked just fine. &nb ...Show All

• SQL Server SQL 2000 : Triggers

  Why there can be only one instead of trigger vs. multiple after triggers. pl. discuss in detals INSTEAD OF trigger executes in lieu of the DML operation so there can be only one. And the logic in the INSTEAD OF trigger is supposed to re-issue the DML again to make the actual changes. The main purpose of INSTEAD OF trigger is to allow modifications on non-updatable views. ...Show All

• Visual C# Fixed Pitched fonts

  How can I detect if a font is Fixed Pitched Yes, I see. I checked MSDN and WinGDI.h - there is no way to get LOGFONT from HFONT, it's input structure only. So the only way I found (but not tried yet) is to use GetTextMetrics() from Win32 API - there is same pitching information that in LOGFONT. May be this can help. ...Show All

• Visual C++ interface/struct strangeness

  Hi, I just noticed a very weird bug when compiling a c program: Every time a variable with the name "interface" appeared, the compiler gave a lot of errors. I managed to trace the bug but it seams that the compiler substitutes variables with this name with the word "struct". This happens after i included <winsock.h>. Here is the shortest program where you can see the behaviour: interface interface; #incl ...Show All

• .NET Development Recurse and Enable WebControls

  It seems like this ought to be such a simple task. We have several pages where the ASP WebControls have property Enable set to false. The idea being that not everybody can edit, and even if the user can edit, we want them to click the edit button first. My first go at the code behind (abbrieviated to show just one example) on the edit button looked like this: Protected Sub recurseControlEdit( ByVal oControls As ControlCollection) F ...Show All

• .NET Development Security - Data Access Best Practices

  Hi there, We're developing an in-house employee self-service portal that allows employees to access and modify various pieces of private data such as vacation requests and so forth. We have the options of either using a smart client application (deployed via ClickOnce) or a web application. If we went with a smart client application, the number one security issue I see with direct database access is the connection string. I don't believ ...Show All

• SQL Server CPU Utiliization reaches 100% when using ExcelPivot Table to browse AS 2005 Cube

  CPU Utiliization reaches 100% when using ExcelPivot Table to browse AS 2005 Cube. Only one user is using the cube. Its a single CPU with SQL Server running on the same box. Is there any configuration parameters I should be changing Thanks Selva Hi Selva, This is nothing to do with your question.  But I was wondering if you have been able to drill down hierarchy levels from your cube in your excel pivot table   Because I can't.&nb ...Show All

• Visual Studio Team System How do I check search for All files that a certian user has checked out

  How do I check search for All files that a certian user has checked out Refer to http://forums.microsoft.com/MSDN/showpost.aspx postid=324014&siteid=1 Swamy ...Show All

• Visual Studio Team System web projects, .net 1.1 and TFS?

  we are looking to migrate to TFS. I have been tasked w/ getting this whole thing up and running. Our cash cow product is a (set of) web application(s). We are unable to migrate this product to 2.0 so I'm looking to see what there is in the way of custom integration for this piece. I can see using the TFS:SCM for normal .net 1.1 projects hosted inside TFS, but because someone thought it would be a great idea to totally change projects in 2. ...Show All

• SQL Server SSIS Import and Export Wizard Data Sources

  I'm just beginning to use SSIS (bracing for a steep learning curve due to lack of helpful documentation) and am starting out trying use the Import and Export Wizard.  On the "Choose a Data Source" page there is a dropdown for the Data Source.  I see a list of possible data providers, but not one of "Microsoft OLE DB Provider for ODBC drivers," which is the one I wanted to use because I'm trying to connect to an obscure databa ...Show All

• Windows Forms Saving a webpage and all it's images to html file

  Hello, Is there a way that I can save a web page as a HTML file and all of it's images from VB.NET without prompting the user I basically want to automate the file save as html in internet explorer. I have been trying with the axwebbrowser control and only managed to do it with a prompt, any ideas on this would be very helpful. Regards, Matt I would be glad to look into a solution for this only if I was confident that you don't plan on usi ...Show All

• Visual Studio Problem Trying to integrate the VSTA IDE in a Host Application

  Hello, I am trying to use the VSTA IDE in a sample application and I've used the tutorial given in the documentation. I get a COMException on the following code line: IDTEProvider dteProvider = ( IDTEProvider ) new VSTADTEProviderClass (); The error message is: Retrieving the COM class factory for component with CLSID {AE3BA5A5-2E1E-4FD3-937C-9119AA69E0E4} failed due to the following error: 80040154. The tutorial explains th ...Show All

• Visual J# Maybe stupid question but: How to get float out of System.Single?

  What is the method to extract value from System.Single to standard float variable (defined float x = ) when using J# This sounds so trivial that I must have overlooked something when I did not find the way I have to use System.Single when I'm communicating with certain COM controls. This question is better suited for the J# forum. Please reserve the Base Class Library forum for questions related to the BCL i ...Show All

• Software Development for Windows Vista Always allow an application

  Hi Is it possible to authenticate an application/exe so I don't need to press continue every time I start my computer My prob is that every time I start my computer I need to press continue to two Logitech driver exe's. That a bit irritating :) And when I start Firefox, or if I click a link i e.g. outlook firefox need to be approved. /nOrphf Someone has to know about a solution here.. In my case its the Synaptic ...Show All

• Visual Studio Convert Property to Item with transform

  If I have a property $(MyProperty) with semicolon separated items and need to have a item list @(MyItems) it's fairly easy to convert: <PropertyGroup> <MyProperty>a.xml;b.xml;c.txt;</MyProperty> </PropertyGroup> <CreateItem Include="$(MyProperty)"> <Output ItemName="MyItems" TaskParameter="Include" /> </CreateItem> <!-- now I can display just the filenames, li ...Show All