Perry Choy's Q&A profile

• Visual Studio Tools for Office How can i extract my OLE Object(.xml file) from Excel and save as a file xml file programmatically?

  Hello, I have a one OLE Object(XML file) embed in Excel file. now how can i programmatically extract that OLE Object from excel and save as a .xml file. Any idea... Whether you can do this depends on the OLE Server installed on the machine that maintains the embedded object and opens it when you double-click on the object. That OLE Server has to expose an automation interface that will allow you to perform a "save". Note that this question has nothing to do with the topic of this forum - VSTO. You need to pursue this question in another venue. Since you give us no idea how the embedded object was created, nor which application functions as the OLE Server, it's difficult to point you in the right direction.. ...Show All

• Software Development for Windows Vista About GetClientRect in AERO

  I use GetClientRect function to retrive the coordinates of a window's client area and then draw a bitmap into client area in WM_PAINT callback function. But when AERO is enabled and the minimized main window is restoring, the bitmap is presented before the main window being restored. It is no problem when AERO is disabled. There is a slow animation when a window being restored in AERO. How to detect the animation is over Or, should I try another way I am sorry for that incorrect sample code. In fact , the SetWindowPos() is used to show a child window. It looks like this,     case WM_PAINT:     {         ......     &nbs ...Show All

• SQL Server Store Procedure (update)

  hello, a question please. Could anyone say me if it exists a way to create a "general" store procedure which updates data on the same file. I don't want to create a storeproc for each different type of update on the same file. Thanks... thanks. Not, I want to build one store procedure per table, but not more than one. For an update: Suppose I have only one data to update and I don't have the rest of a record I must use a store that updates only that data. If I have 3 datas to update I can't use the same store proc. The question is: I must create a store proc for each "type" of update. Is there another way Thanks... ...Show All

• .NET Development xmltextreader and digg.com rss' feeds

  Hi, I have a rss feed reader that works fine except on any of the rss feeds at digg.com: http://www.digg.com/rss/index.xml - on this feed for example the xmltextreader will crash during the do while (reader.read) loop Sample code: Sub Main() Const URLString As String = "http://localhost/books.xml" Dim reader As XmlTextReader = New XmlTextReader(URLString) Do While (reader.Read()) Select Case reader.NodeType Case XmlNodeType.Element 'Display beginning of element. Console.Write("<" + reader.Name) If reader.HasAttributes Then 'If attributes exist While reader.MoveToNextAttribute() 'Display attribute name and value. Console.Wr ...Show All

• Visual C++ about timestamp

  Hello everyone, I need to record a set of data items. For each data item, users may modify to some new content. So, I plan to use a timestamp field for each data item to record the time when user modifies data item last time. I am not sure whether I should use a simple integer value (like version information, which increase 1 each time when user modifies data item) Which approach is better What are the advantages and disadvantages of each approach thanks in advance, George Thank you Alex, Alex Farber wrote: Timestamp is better if you want to sort items by modification time. Do you mean using timestamp is always better Actually, I do not have such requirements. regar ...Show All

• Software Development for Windows Vista DelayAvtivity in whileActivity

  I have a a voting application. The users have 24 hours to vote on a certain matter. I have the a listen activity inside a while loop that count all the votes. The whole voting process must stop after 24 hours. I can not place a the listen activity inside another listen activity and when i place the delay activity inside the while activity it is resetted every time that the loop goes through. Any ideas on how to do this workflow The two options I can think of are using a Replicator with a Listen child or using a StateMachine. For the replicator option you would initialize the InitialChildData with all the users that could vote and a separate instance of the Listen will be created for each user. W ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA & noob programmer != success?

  I am way confused, In my new issues of both OXM magazine and Game Informer there are articles regaling the use of XNA to build your own 360 games, (albeit in the future) but no harm in building now and transffering to 360 when they open that option up. My question is this, I am fairly new to c++ only, I dl'd c#express, (even though I hae VS 2005 PRO...) and installed XNA and am lost. My confusion stems from both articles saying XNA is designed for ease of use by people without any programming knowledge. It says it is built around a simple interface using largely mouse clicks and drop down menus,(Game Informer, November 2006 issue#163, page 55) but where I have seen many posts here by people directly saying that XNA is a toolkit specifical ...Show All

• Visual C++ ERROR MESSAGE

  well i am a naive at vc++ and prcticing my hand on small problems like finding a factorial,string operations etc.But the problem with visual studio is that many a times when i run an application it gives the following error: This application has failed to start because MSVCP80D.dll was not found.Reinstalling the application may fix the problem. I'm tired of this error.and i don't know how to send you the picture of error to you[i'm naive please forgive me!!!) i think this error occurs generally when some decision in the program is compiler dependent. please help me out please!!!!!!!!!!!!! The error you are seeing just means you've included debug binaries in your app, which you can't distribute to other machines. ...Show All

• Visual Studio Express Editions MSDATASRC Version 7.0.3300.0

  I have written a program that works perfectly on my computer. However, when I try to execute the program on another computer, setup fails because the subject assembly is not found. What do I need to do to get the subject assembly on another's computer Will appreciate any and all help on this. Thank you. Try using the publish features of VB Express to create you setup - which will include .net 2.0 as a requirement and install it if its not already installed. It makes deploying applications much simpler. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ViewPorts - Splitscreen

  I am trying to get a splitscreen to work and it does sort of. The problem is the models drawn now look messed up, like the zbuffer is messed up or something. Here is what I'm doing: protected override void Draw(GameTime gameTime) { cameraPosition.Z = 5000; graphics.GraphicsDevice.Viewport = topViewport; Draw(); cameraPosition.Z = -5000; graphics.GraphicsDevice.Viewport = bottomViewport; Draw(); } In the Draw function I am clearing the viewport to CornfolowerBlue and drawing the models. What am I missing here. The minDepth and maxDepth are initialized to zero by default, so you have to set them to good values. Not sure how accurate or correct is my technical description of the problem, but he ...Show All

• Visual C++ separating high and low 32 bits in a 64 bit interger

  Hi, Can anyone help me to separate the high 32 bits and low 32 bits of a 64 bit integer into 2 new intergers Thanks in Advance inline unsigned long HILONG(__int64 value) { return (unsigned long )(value >> 32); } inline unsigned long LOLONG(__int64 value) { return (unsigned long )(value & 0xffffffff); } ...Show All

• Windows Forms Problem with MainMenu and Minimum Size of form

  I did a search online and on this forum and couldn't find a solution anywhere. I have a form with a MainMenu control and I wanted to set the form's minimum size. After setting a minimum size and starting my form I notice that its height has increased. It has added extra space at the bottom. I've tried changing the minimum size and the size of the form around but it seems to always add around 25 pixels of height to the bottom of the form if I have a MainMenu control and a minimum height for the form. Its a minor problem, I know, but I am interested if anyone has a solution I am observing a similar issue. In form designer there is only 1 pixel space between my bottom most control and the form border. At run ...Show All

• SQL Server Connection to DB from VB.net express

  When trying to connect to a db in VB.net express I get this warning An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) this is my code 'verbing maken mat de db Dim DBconnection As New SqlClient.SqlConnection( "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Documents and Settings\Pieter Van Driessche\Mijn documenten\Visual Studio 2005\Projects\kasboek\kasboek\db1.mdf';Integrated Security=True;User Instance=True" ) DBconnection.Open() Can somebo ...Show All

• SQL Server Nested IIF's

  I need to evalute two different fields in some text boxes. =IIF(Fields!BadAddressFlg.Value > Nothing , "Red" ,IIF(Fields!BadPhoneFlg.Value <> "G" OR Fields!BadPhoneFlg.Value <> Nothing , "Red" , "Black" )) If the valuefor bad address > nothing or Badphoneflg <> G or <>Nothing then the color needs to change to red, any of these can be true not all of them. I tried the switch, choose, all of them and if I take one of the fields out then I get it to work but I cant get them to work if they are both like this. Thanks Stokh Three ORs mean that you don’t have to differ between the cases, right =IIF(Fields!BadAddressFlg.Value > Noth ...Show All

• Visual C# convert this VB code to C# help?

  I am trying to create and populate a new access database. I found that I needed to include the reference to ADO extended in the com references. I includes the using ADOX; and the following if statement will successfully create the database. if (! File .Exists( "C:\\AccessDB\\NewMDB.mdb" )) { cat.Create( "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\AccessDB\\NewMDB.mdb;" + "Jet OLEDB:Engine Type=5" ); MessageBox .Show( "Database Created Successfully" ); } But I don't know how to add tables to this database. I found the following VB code and thought it would be easy enough to convert over but ran into some problems. Like the Columns append function require ...Show All