Yong Hwee's Q&A profile

• SQL Server How can I get rid of the comma in a company name by using sql command?

  For example: company_name: ABC company, inc. I want to get rid of the comma, replace by a space. How the query should be write Thanks replace(ColumnName,',',' ') example select replace('ABC,ZXX',',',' ') Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Visual Studio Tools for Office Problems with deployment at end user

  Why doesnt this code work when the msi.file is installed on the enduser machine. Nothing happens, while when run as 'Debug' in VS development environment everything works. All this code does is displaying a messagebox when Outlook is started. The project is made with VSTO and nothing in the setup project is tampered with, ie keys and such are intact. Help please! in ThisApplication.cs: private void ThisApplication_Startup(object s ...Show All

• Visual Basic **New VB.NET Forums - Are You Looking in the Best Place?

  Hi everybody, I'm Paul Yuknewicz - I'm one of the Program Managers on the Visual Basic product team, and starting today, I'll be moderating these forums.  For more info about me, check out my blog .  We have some new forums for VB that should help you find categories of questions better:  Visual Basic General Questions and discussions about developing with Visual Basic 2005, that are not covered in the other VB forums. ...Show All

• Visual Studio Express Editions What the Array is going on?

  Is there a problem with array.sort If I load an array in to a list box I get A is Element [0] in the array B is Element [1] in the array C is Element [2] in the array but when I click the button to sort the array I get is Element [0] in the array A is Element [1] in the array B is Element [2] in the array Here is the code, Private Sub btnShowAll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShowAll.Click List ...Show All

• Windows Forms AutoScaleMode Property does not exist

  Hi, I am creating a control inherited from TreeView. The designer generates this code: private void InitializeComponent() { components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; } which gives the compile error 'Error 3 'DRM.DrmTree' does not contain a definition for 'AutoScaleMode''. Could someone tell me what I should do please I'm using VC# 2005 beta 2 and I can't ...Show All

• Windows Forms System Update Required

  Hello All, I published my application using MSBuild which builds and publish the application.  However when I tried to connect to the application from a client machine it errors out on the  System Update Screen.  The error messag was "This application requires your system to be updated to Microsoft.Practices.Enterprise.Logging Version 1.1.0.0"  The dll is in the publish directory on the server.  Any idea why this is happ ...Show All

• Visual C++ Slow link time

  I am using VC++ 2003.  My link time in debug configuration, for a simple console test program with less than 600 total lines of code, is more than two minutes.  This is quite annoying in the context of a continuous build-test-debug cycle. This is on a dual-processor 2.8 GHz Xeon with 2 GB of memory, so I don't think hardware is an issue. The /TIME option gives the following result: Pass 1: Interval #1, time = 11.313s Pass 2: I ...Show All

• Smart Device Development Trap All Key Presses Independent of Focus

  Using Visual C# .NET Compact Framework 1.0, I'm trying to trap all keypresses in a top level System.Windows.Forms.Form whether or not the form has Focus. Basically I want to delegate key events on my own.   The problem is that only the currently Focused Control receives events (KeyPress, KeyDown, etc.). I would like a high level key event manager that peeks (does not consume) all key related events for a Form. Can anyone help me h ...Show All

• Visual Basic How to set different border styles in picturebox in VB?

  Hi, How to set different border styles in picturebox in VB like:-  single line,          double line, doted(...) lines and so on Please help me as soon as poosible. with regards chinna Try something like the following: Public Class PictureBoxWithBorder   Inherits PictureBox   Private _BorderStyle As ButtonBorderStyle   Public Sub New ()    Me ._BorderStyle = ButtonBorder ...Show All

• SQL Server Express cannot convert different data types automaticly????

  I have a SQL Server 2000 database which works like a charm in my asp app. Joining tables by id columns which are of different data types (eg. int in one table and varchar in the other) is no problem with the SQL Server engine, but Native Client refuses to do so and hands me back an error. Even if columns have a slightly different collation (like Slovenian_CI_AS and SQL_Server_1250_CI_AS) SQL Express native client returns an ERROR !!! Is it pos ...Show All

• Windows Search Technologies WDS & Sharepoint

  How to integrate/serach contents available on sharepoint using WDS For the Enterprise version of WDS, you can check out the Administration Guide which includes details about how to add custom search locations. For example, you can add a button next to the Desktop and Web buttons with custom text (like "Intranet") that points to a custom query URL (such as a Sharepoint server). ...Show All

• Smart Device Development reading xml file on pocket pc

  Hi, I am using visual studio2005 to write vb to pocket pc 2003. I do not seem to be able to open any files from my code. When i open an xmltextreader no file is found and i get a directory not found error message. I have read an article saying that devices do not use drive letters but taking the drive letter out does not help. Dim events As New XmlTextReader( "C:\events.xml" ) any ideas cheers nubie you would ...Show All

• Windows Forms Install TV Server into SQL Named Instance?

  Greetings, How can I install the TaskVision Server into an existing named SQL Server instance instead of the default 'Localhost' TIA, Q when it fails and shows the error, don't hit the ok button.  just let it sit there and go find  ...Show All

• Windows Forms binding to checkbox or radiobutton...

  Hi, I'm saving to a database the status of checkboxes and radiobuttons (using this.checkBox/radioButton.Checked.ToString() ). The fields where these are stored are of type Yes/No, and in access everything seems to work fine, cause in the field appears a cheked&nbs ...Show All

• Visual Studio Team System errors in load test ("Object reference not set to an instance of an object")

  When I use the following code to enumerate dependent requests, I dont get the error "Object reference not set to an instance of an object" foreach ( string s in LastResponse.HtmlDocument.DependentRequestUrls) { WebTestRequest loopRequest = new WebTestRequest (s); yield return loopRequest; } if I add in the following check, I get an "Object reference not set to an instance of an object" mor ...Show All