hfleong's Q&A profile

• SQL Server how can i use The "Use Database" statement >>>

  the question is how to use use database statement if the name of the database contain spaces please help me Thanks CREATE DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME] GO USE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME] SELECT * FROM INFORMATION_SCHEMA.TABLES USE Master GO DROP DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME] -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de ...Show All

• Visual Basic Crystal Report in VB 2005 Express

  I just upgraded to test new features of Microsoft Visual Basic Express. The new features are really very useful and had made using VB even more easier and a powerful RAD tool. I've almost completed my semester project (expect the reporting part). All I got at the end a shock — "Where is the crystal report" Could anybody help how to design reports in Visual Basic 2005 Express It's urgent! ...Show All

• Visual Studio Express Editions Not necessarily "Express" Related, but what about WinMX

  With the cnahge from VB 6 to .NET 1, now .NET2, are we going to have to learn all over again to program under WinFX I'm just now getting my bearings in VB2005 (from VB5 Pro), will this be obsolete in a few months as well Am I misunderstanding the concept First of all, it's not VB.NET anymore it's just VB8 or VB2005. I think Microsoft is laying down a very solid foundation so that obsolescen ...Show All

• .NET Development Web service client doesn't handle returned sequence.

  Hi, I'm trying to accept a returned array (or sequence) from a web service in a .NET 2.0 client, the array is sent ok (checked with TcpTrace), but in the .NET client I get an empty array. Did anybody experience similar problems or knows a way how to work around this issue (Web service is implemented with gSoap running on linux by the way). The WDSL looks like this (highlighted the relevant sequence section): < xml version="1.0" en ...Show All

• Visual Studio Tools for Office How to get char(13)&char(10) in Excel ?

  I got string in excel to covert HTML by VB.NET but when i got a string with alt-enter(enter row in excel) i used this code str = str.Replace(vbcrlf,"<br>") to replace any crlf in string in excel but this code not work. Anyone help me Oh i know that but i tryed but can't get return of excel thats problem!!! ...Show All

• Visual Studio Team System CA1804: Remove locals that are not used, but this local is getting used

  Hello, (I searched the forums for CA1804 but couldn't find anything similar) FxCop flags the variable intOldId with CA1804 --8<-- Dim intOldId As Integer = -1 For Each drOrder As DataRow In dtMulti.Rows     If intOldId = CInt(drOrder("OrderId")) Then         'Already processed this id, skip duplicate row          Log("Skipped row")     Else    ...Show All

• Visual C# return value from a application

  Hello, I'm developing an command line tool which is started by another application Is there a way to handle all posiple errors with in my application an set an error code for the application manual at the end, so that i can tell the application, which started the commandline tool, that there was an error Thanks, Chris Yes when exiting the application do: Environment.Exit(int theErrorNumber) y ...Show All

• .NET Development How do I get a .NET TextBox to implement MY OWN INTERFACE

  This is a tough one.  I know how to use and implement interfaces from my own classes, but how do I take a system.windows.forms.textbox and get it to implement an interface that I designed.  I really don't want to have to inherit a textbox into a usercontrol and then do it from there... isn't there a more direct means to do it    I have tried creating an empty class file and making it look like the following... =============== ...Show All

• Visual Studio Express Editions Beta 1 SQL Server express refuses to uninstall

  A while back I uninstalled VB 2005 Express, but didn't uninstall the SQL Server that came with it.  Now, when I try to follow the explicit instructions for uninstalling beta 1 of VB 2005 Express, I get an error message stating I "need to install VB first", and then it quits.  I no longer have the beta 1 VB express setup files, so I'm kind of stuck.  Can anyone tell me how to remove the beta 1 SQL Server parts so I can proceed ...Show All

• Windows Forms DataGridView RowLeave

  I used the RowLeave event to execute tableadapter update to the database. This works fine. But when I try to edit a dropcombobox the value chosen is diplayed but as soon as I click another row the value get's resetted to the previous value. When I first select another cell on the same row! after editing the combobox and then click on another row, the value stays as it shoulds. It seems like the combobox (wich has editcontrolshowing) has a ...Show All

• Windows Forms Date Time Picker

  Hi, Anyone know how to format the Date Time Picker in C# to shows MONTHS only Hi, Sorry, please allow me to ask more, can you guide me more details on how to traverse the list view items and create the loop Thanks. ...Show All

• Visual Studio 2008 (Pre-release) PointToScreen/PointToClient Question

  Ho do I implement 'PointToScreen' like functionality I know how to do that from within mouse event handlers by using GetPosition(Inputelement), but in general case is there any reusable function, which would do that Thanks Look in VisualTreeHelper, there are methods for getting transformations from one element to another. Then you can use the transformation to transform a point, rect, or other shap ...Show All

• Windows Forms BindingNavigator jumps back to first row on clicking "move next"-Button

  I connected a BindingNavigator and a DataGridView to a DataTable of a DataSet. Clicking on the "move next"-Button, the navigator shows a funny behaviour: it moves to the next datarow, but with the next click it jumps back to the first row. With each cycle of clicking "move next" I reach one more row: row 0 -> row 1 (jumps back to row 0) row 0 -> row 1 -> row 2 (jumps back to row 0) row 0 -> row 1 -> row 2 -> row 3 ( ...Show All

• Visual Studio Express Editions MIcrosoft Visual C++ Runtime Library

  I am getting this error when trying to open my newly installed quickbooks: Runtime Error! abnormal program termintaion Any Ideas on why this might be Thank you Chris This is not a VC2005 issue. Contact the author of the application. Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server How to optimize data import with huge volumes and joins across data sources not all SQL Server based?

  I need to periodically import a (HUGE) table of data from an external data source (not SQL Server) into SQL Server, with the following scenarios: Some of the records in the external data source may not exist in SQL. Some of the records in the external data source may have a different value at different imports, but this records are identified univocally by the same primary key in the external datasource and in SQL Server. Some of the records i ...Show All