Henry Ong's Q&A profile

• Visual FoxPro command window always on top

  Hi, I am trying to figure this out for over an hour without much luck. When I open a table and browse it, the command window always stays in front. How can I get it to go to the back so it won't be in the way Thanks, Mark ...Show All

• Visual C# Best Practice for Handling time

  I host a SQL Server 2005 database that has users in different time zones. I just discovered that data that is saved in Central time zone at 12:30am on Jan 9th is displayed as being entered on Jan8th on a machine looking at the data from the Eastern Time Zone. A look at the XML for a serialized dataset shows the date is being saved with UTC offsets. I need to understand what exactly is happening with the date times so I can know what to expect. For example, when I send a select to the database across time zones, is it changing the date If both users run a report of data entered on the 9th, it appears they are going to get different reports, which sounds like a nightmare to me. Can anyone summarize 1) what is being done w ...Show All

• .NET Development SqlDataAdapter: Unable to save data in a SQL database, What's wrong?

  Hi All, I am unable to save data in a SQL database, What's wrong I am coding with VB .NET and I am unable to retrieve data from the database, beside I can read from the database without problems. How can I do, This thing is driving me crazy, it is 4 days that I am tryng to write in the database and I ahve tried everything update, insert. Somebody Know how to manage the SqlDataAdapter, beside the SqlDataReader is working perfectly. I am not used to the SqlDataAdapter. Is there anyone who know how to write in the database or where I am in mistake Thanks in advance. Here is the code: Dim oCmd As SqlClient.SqlCommand Dim oDR As SqlClient.SqlDataReader Dim strSQL, strSQL1, strSQL2 As String Dim adapter As System.Data.SqlClient ...Show All

• Software Development for Windows Vista Passing Activity Properties between Activities in different States

  Hello I have created a custom activity, that stores a string in a property at the end of its execution. I want another activity in another state to be able to access this property. The first activity sets the string but the second activity gets a null value when trying to retrieve the string. Is it possible for activities in different states to access each others properties and if so how I have tried attached properties etc... V Because of spawned contexts, for more information go here , it is not possible to directly access a property value on an activity in another state. You will need to bind each property to a workflow level variable. ...Show All

• Visual Basic Custom Dialog Help

  I created Dialog1 in my current project. I cannot figure out how to get it to come up when my "New" button is clicked. The various ways I have tried all fail. Thanks for the help. Double click on the new button in the designer to create a click event. Inside put Dim dlg as Dialog1 = new Dialog1() dlg.ShowDialog() That will work. Now, go and buy a book to help you get over the initial learning curve that includes these sort of questions. We will be happy to help you either way, but you really need some sort of reference to accelerate your early steps, or it will take you ages to get past them. ...Show All

• SQL Server system account for sql2005

  I have a big trouble with update from MS SQL 2000 to SQL 2005. Because my aplication runs as System Service, I use system account for login to SQL server. At the SQL 2000 I created SQL account like "DOMAIN\PC_NAME$" and service started at PC_NAME was able to logon on the SQL2000 server. But on the SQL2005 it DOESN'T work. Does anybody have some idea how to create system account on SQL2005 to log on SQL server from another computer under system service account Thanks for your help. What was the error you get when you are starting the SQL 2005 services using that domain account Make sure it is a local administrator on the machine where the SQL 2005 instance is installed. ...Show All

• Visual Basic in my richtext box i need to load a ms word document file content

  in my rich text box control i need to load the msword document file my word document file contain but it is accepting onely a text file can any one help me Did you save you documents from works as rtf documents and NOT word doc files. If they are not rtf files they will not work in the RichTextbox control. ...Show All

• SQL Server problems with sum()over(order by field) syntax

  Hello I'm experimenting with window functions and I'm having troubles with the sum()over() syntax. I've followed the syntax from many examples and i'm still getting this error. I can get it work with sum(field1) over (partition by field2) but every time i add order by i get an error I have the following query, this is from the adventureworks sample use adventureworksdw select *, sum ( scenariokey ) over ( order by amount ) as test1 from FactFinance and I get the following error Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'order'. Any suggestions. Thanks in Advance Daniel SQL Server 2005 only supports partition clause for aggregate window functions. The ranking win ...Show All

• Visual C# Move Directory Across Volumes

  I have developed an application designed to copy a directory on the D:\ drive to the C:\ drive, and I recieve a message that it can't copy across volumes using the following line of code: System.IO. Directory .Move( "D:\\WBWU" , "C:\\My Documents" ); Would that work, or am I wrong yes indeed. but remember the computer must have the .NET Framework installed in order to run your application. If you are creating some installer, it is advised to use the Setup and deployment project to create a proper installer ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vista Compatibility

  Looking for any hints on when a Vista version will be released. (Note that I'm in the middle of installing the same version as everyone else is right now, but the web site says it won't be out for a bit). I really don't want to put a third OS on my system just so I can run xna express. (I've already got Vista Ultimate 32 and 64 bit on here - starting to get crowded) Dan Yup. It made it to a certain point, then failed, and rolled back. Nice to see something do the right thing if it can't install fully. I'll probably purge off vista 32 bit, and put an xp pro partition back on. That leaves me 64 bit vista for spiffy stuff, and 32 bit xp pro for game development. Sigh. Another os instal ...Show All

• Visual Studio Team System Database Project: "Add Project to Source Control" error

  When I try to add my Database Project to Source Control, I get the following message: --------------------------- Microsoft Visual Studio --------------------------- Error TF50322: Unrecognized project name. --------------------------- OK --------------------------- I tried to use different project names, I tried to add the project to Source Control during its creation and after its creation - nothing works. Thank you. A person on my team has been trying to reproduce that error but has not succeeded. What is the full path\name of your DB project & the solution I'd like to be sure we're following the same steps you are. What steps do you take create the DB project and add it to Source Control Thanks, ...Show All

• Visual C# Creating controls at runtime vice dropping Controls at Design Time???

  I'm not so new at C# but I'm still a beginner! I'm very confused about the above subject ... I am a former VB (and COBOL) programmer and, I'm confused as to why or when to drop controls on a windows form and when to create them at run time Are there do's and don'ts for this, or is this feature available for the "hard-nosed" programmer who likes to fully control the app When I wrote VB apps for instance, I would not use the Data control (unless I absolutly had to) because I wanted more control over the data and how it was displayed and edited. Yeah, more coding and work but I knew what was happening when. Any information that will help clear this muddled mind of mine would be appreciated! Thank you Greg ...Show All

• .NET Development Update DataSet with the values of the inserted row

  Hey, First of all i work with an access database. In my program i made an DataAdapter with retrieves rows from the database from two tables(through an inner join). Because the dataset linked to this DataAdapter is represented in a datagridview i also wrote insert, delete and update commands. The way i solved the insert in two tables is with an transaction. In the RowUpdating event of the DataAdapter i create an transaction and manually insert the row in one of the tables. The insertcommand of the dataadapter will handle the insert in the other table. In the RowUpdated event of the dataadapter i commit the transaction. This works all fine, except for the fact that some values in the datagrid are left empty because then the defa ...Show All

• .NET Development Controlling values from a Combo box

  Hello, I am very green at this and I'm hoping for a bit of help. I've created a very basic program that creates some html code based on what a user enters. One of the fields they complete is "DIVISION" (I've called the combo txtDivision). There are four pre-defined selections - but you have the ability to enter in others. The combo simply displays the company division. I also have four company logos, one for each division. "FGSig.gif", "FSSig.gif", "FGSig.gif" and "FHSig.gif". If the user enters their own division, or leave division blank, "FGSig.gif" should be used. I have declared the logo as image and the company sub division as division Each logo is located on a web server. ...Show All

• Software Development for Windows Vista TrackingRecord not serializable

  Hi, I have written a custom tracking service and the corresponding tracking channel. I have overriden the Send method which the runtime would invoke by passing the tracking record. I need to pass this info to some remote object hosted in a Windows Service using Remoting. However while passing this data, I got a serialization exception and subsequently I realized that WorkflowTrackingRecord and ActivityTrackingRecord are not serializable. Any particluar reason why these two classes are not serializable. Now that they are not, I need to extract the contents into a serializable class and pass it across the remoting boundaries which could have been avoided had the class been serializable. Thks Giri ...Show All