YU_MSVB's Q&A profile

• Visual Studio Tools for Office Excel: show XML data horizontally

  I am not sure if this question is appropriate here. If not, I will try to find a more appropriate place. I am working on reports using VSTO with Excel. The program will produce the report data in XML and import into Excel. But when I design the format and drag the data from XML Source , the data will be shown vertically . And the report will be arranged in a cascade manner. I wonder if there is a way to change this default behavior. That is, ins ...Show All

• Windows Search Technologies Problems searching with German IMEs

  I have found that when using a German language keyboard, I sometimes receive no search results for terms that yield several results if the keyboard language is U.S. English, or anything else for that matter. For example, a search for the term "ipass" yields 623 results on my machine with English as the keyboard, but 0 results when the keyboard is switched to German (Germany). A search for "ipas" returns the expected set of re ...Show All

• SQL Server Transaction log keeps growing

  I have set the dboption 'trunc. log on chkpt.' to true; yet the transaction log keeps on growing. sp_dboption pubs_db does show 'trunc. log on chkpt.' to be set. I tried DBCC SHRINKFILE ( pubs_db_log , 100 ) and for a while, the pubs_db_log.ldf was about 100M and then it grew to 10GB. I have a process running that is inserting more than 15K rows per hour and I would like to keep the transaction log from growing. How do I control the tx log g ...Show All

• Windows Forms DataGridView + RowValidating = Index 4 does not have a value?

  Hello, I recently setup my DataGridView to use the RowValidating event.  However, whenever a user types something in to a NewRow (as to cause the DGV to create a new row and consider the current row's NewRow = false) and then hit escape to cancel the edit, the DataError exception goes nuts.  It keeps spitting out "Index 4 does not exist" in what seems to be an infinite loop. Here is my RowValidating code: private void dg ...Show All

• Visual Basic Casting Error

  Dear Team    there is a field ' Date' in the db allow null...    On the form after binding and adding NewRow to insert ......    if the user left the textbox empty an error will raise    " Casting "" to Date is invalid "    How to solve this error       Thank you very much Thank you very much HuyN_MS Thank you very much Mr Yer i am looking ...Show All

• Visual Studio Tools for Office Using NativeWindow seems to crash Word

  I create NativeWindows and attach them to various windows in Word, like the scrollbars, to monitor events, as suggested by Geoff Darst here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=219393&SiteID=1 Event monitoring works great, but when I exit the application, Word crashes (the big "send your error report" dialog): The program '[3796] WINWORD.EXE: Managed' has exited with code -5 ...Show All

• SQL Server Error "No Connection could be made because the target machine actively refuses it (System)"

  I am using SQL 2005 CTP April (Upgrade of a SQL Server) on Windows XP SP2 Setup a New Analysis Project Solution Connected to my Database (ApolloV42) Setup a Data Source View to two tables Event_STS and STS_PostOP Created a cube and used all the defaults. I get the following error when trying to browse the data "No Connection could be made because the target machine actively refuses it (System)" When I look inside the SQL Server Management Studio ...Show All

• Visual Studio An error has occurred while attempting to load the Crystal Reports runtime

  I am trying to connect to a VS 2005 MDF database. It appears that the only way to connect to it is through a datset. Is this right But when I try to use the report, I get the following error at runntime: --------------------------- Crystal Reports --------------------------- An error has occurred while attempting to load the Crystal Reports runtime. Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports run ...Show All

• Visual Basic Using FpSpread in vb.net

  Hi guys, I am using FpSpread in my vb.net program, but now I encounter a problem, appreciate you could revert. I set the cellnote and TextTipPolicy attribute in order to show the note at runtime, but I found it's a bit harder to catch it(because the "red point" is too small). Can I get the note when I move the mouse on the cell or click it at runtime rather than point to the "red point"(just like excel),how to archive it,thanks in advance. ...Show All

• Visual Studio Express Editions Can not open new project

  I just downloaded and installed VB 2005 Express last night. followed the on line instructions for removing old beta's to a T. when i run VB2005E and choose New Project and pick any of the templates displayed ireceive this error: the file name, directory name, or volume lable syntax is incorrect (Exception from HRESULT 0x8007007B) it seems that the templates dont exist. so i uninstalled every thing again today and still get th ...Show All

• Visual C++ Rebuild using shared precompiled headers doesn't work

  To combat a long build time, I consolidated common headers across 20+ projects into a single precompiled header, to be shared.  The pch file is generated from a separate project (pch.vcproj with stdafx.cpp/h), and it works with clean builds and incremental builds (from editing one of the files belonging to the 20+ projects), but I get compile errors when I choose Rebuild.  Before presuming a bug, I'd like to ask the forum for he ...Show All

• Visual Basic Deleting all but 1 Duplicate Rows in a datatable

  I've spent hours search on msdn and google and i can't for the life of me find an answer that even remotely makes sense. I'm completely stuck in my app until i can resolve this. It seems like a simple thing... why is it so hard to find a clear and precise answer I have a datatable with the following rows (as a sample) CODE DATE TYPE1 TYPE2 REF REFB VALUE 01000001 15/02/2006 INVOICE SALE ...Show All

• .NET Development cached dataset or sql table

  Hi... I have an xml file with approx 3000 nodes..i need to create a keyword search facility and am undecided on whether to go down the cached dataset route with results extracted into a dataview or just use a sql table..does anyone have any experiences or comments to share...thanks ang That really depends. If DB or network issues have ever caused bottlenecks, then it would push things toward the caching side. If data needs to be absolut ...Show All

• Visual C++ MCF and Framework .NET

  Boyh are libraries What's the main difference It's usefull to learn MCF or nowdays is better only learn Framework .NET My personal opinion is that it really depends on the nature of the application you are developing as well as how familiar you are with the two technologies. Here is another post that might be helpful: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=39599 Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Windows Forms Set Property via string (possible bug)

  Ok I have done up a bunch of code, but in my code I would aways have the size and location set directly I only needed to set other properies via string. I recently ran into this problem. Ok I pop a button on the page (winforms) a ...Show All