Kate Boothby's Q&A profile

• Visual Studio Tools for Office How to access worksheet in VSTO 2005 SE Addins

  I tried the following codes in ThisAddin_Startup method to access active worksheet and I got "Exception from HRESULT: 0x800A03EC": Excel. Worksheet sheet = (Excel. Worksheet ) this .Application.ThisWorkbook.ActiveSheet; How can I access a workbook, worksheet and cells from addins class Thanks Harry Liem Hi Harry I'm not sure why ThisWorkbook is available in an Add-in. Maybe it has something to do with the VSTO heritage of the tools. But when working with an Add-in you're communicating with the entire application, so "ThisWorkbook" is not "appropriate". To pick up the active sheet of the active workbook (which would be the one Excel creates when it starts) ...Show All

• .NET Development pooling large objects

  Hi, I need to know how can I pool a large object , since I have a few memory (only 512 RAM) and need to allocate a large arraylist in it. help me please , Thanks in advance, Aya. Hi Aya The amount of physical RAM doesn't have a bearing on how much memory your application can allocate, since the OS uses 2GB of Virtual Memory by default on x86. Generally there is less than 2GB of contiguous address space due to VM fragmentation by the OS, so you won't be able to allocate arrays that large (incidentally, this is true for all 32-bit Windows processes, native and managed). Pooling large objects is for the case where you have many short-lived objects larger than 85000 bytes. Since the GC d ...Show All

• Windows Forms how can i print the data of a datagrid placed on a form using windows application project, developed in visual studio.net 20

  how can i print the data of a datagrid placed on a form using windows application project, developed in visual studio.net 2003 using vb.net. how can i print the data of a datagrid placed on a form using windows application project, developed in visual studio.net 2003 using vb.net. This question has been talked many times ,you can find many useful answers from this forum http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=47524&SiteID=1 ...Show All

• Visual Studio Team System Creating custom tests

  I'm implementing integration of NUnit tests into Visual Studio 2005 Team System for Testers. I saw that Visual Studio UnitTests have Extensions .dll and .exe and not .cs. If I set in my package attribute RegisterTestTypeNoEditor parameter extensions to .dll and .exe my Tip.Load method is not invoked. If I set extensions to .cs this method is invoked, but gets path to source code files in location parameter. VS UnitTests get there assembly path. What do I need to do to get assembly path instead of sourcecode file What is CMProcessor CMProcessor is the way that unit tests and coded web tests find tests in code. Instead of parsing through the tests, we use the code model to parse code. It looks like ...Show All

• SQL Server Looking for Book

  I have the book 'Advanced Transact-SQL for SQL Server 2000' by Itzik Ben-Gan and Tom Moreau, Ph.D. Is there a similar book for SQL Server 2005 No, there is not "a" similar book... there are two you'll want to buy :)   http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/sr=8-1/qid=1157294696/ref=pd_bbs_1/103-8045562-4351038 ie=UTF8&s=books   http://www.amazon.com/Inside-Microsoft-Server-2005-Pro-Developer/dp/0735621977/sr=8-2/qid=1157294696/ref=pd_bbs_2/103-8045562-4351038 ie=UTF8&s=books   ... both by Itzik Ben-Gan and others, one focused more on querying and one more on programming T-SQL. -- Adam Machanic Pro SQL Server 2005, available ...Show All

• Visual Basic creating help for application

  Hi, Can anyone guide me to any good threads, links etc. on how to make help for an application It seems that most books have left it out, and my app needs a help feature to make the grade. Thanks for all assistance tendered. Thank you. A.F.B wrote: Hi, Can anyone guide me to any good threads, links etc. on how to make help for an application It seems that most books have left it out, and my app needs a help feature to make the grade. Thanks for all assistance tendered. Thank you. Hi AFB, I recommend looking into using Microsoft's HTML Help 1.4 SDK. It is a free program with good documentation on how to create your own help file. The MSDN homepage for the HTML Help 1.4 ...Show All

• Visual C# How to make VS to add lines(splitter) between functions ?

  How to make VS to add lines(splitter) between functions There is no way to do this in C#. I do it with Resharper. Please check the link below for the Resharper option. http://www.jetbrains.com/resharper/documentation/help20/Options/blanklines.html ...Show All

• .NET Development Ping timeout < 500 ms

  Hi, I have to connect to many machines defined in IP addresses ranges at startup. In these ranges, it is possible that some IP addresses does not exist or some machines are not started so I Ping (using System.Net.NetworkInformation.Ping) each IP address before trying to connect to it to prevent big Tcp timeout. It seems that, whatever timeout I specified < 500 ms, a Ping timeout is always at least 500 ms ! As I have to ping a lot of machines, I would like to specify a timeout of about 100 or 200 ms. To avoid too many threads, I send the ping sequentially in 1 dedicated thread. Thanks in advance, Droopy. Have you tried overloaded, Ping.Send() or Ping.Async() which takes second argument as TimeOut But i ...Show All

• Visual Basic Programming Languages

  Hi, I'm relatively new to programming, and Visual Basic doesn't seem to be that good of a language, and not that much used in real applications. I want to move onto a different language, one that is very popular, can do almost anything, and can be and IS used in professional applications. Another important factor is platform compatibility. Java provides that, but Java isn't that popular for Windows, and Windows is my primary target. C++ works, but I have a couple of questions: 1) Can C++ be used on any OS Is it a good language to use as my primary language 2) Is C# going to replace C++ Does that work on other OS's C# is newer, and so I'm thinking maybe its the new version of C++ that's going to replace it, as xhtml is probably going to do ...Show All

• Smart Device Development regarding VoIp

  hello all, where can i get the Voipguid.lib. can anybody send the basic steps for developing VoIP application in VC++.NET. Hi , This forum is primarily monitored by Visual Studio for devices group. Please check this link for more appropriate forums for this type of queries. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 Thanks Srikanth Bogadapati / ...Show All

• Windows Forms flipping tabpages programmatically

  This is what I want to do: when I click a button on tabPage1 I want the tabControl flip and show tabPage6. I've treid numerous tricks--none worked. In the button Click event I have: this.tabPage6.Focus (); SendKeys.Send ("{ENTER}"); this.tabPage6.Show (); No effect. I've tried MouseEventArgs, MouseDown, MouseClick for tabPage6 but none of them even fired. Thanks for help. Hi Alex Correct command is: tabControl1.SelectedTab = tabPage6; Yours Markku ...Show All

• Smart Device Development Problem-Connecting to sql server using pocket pc 2003 emulator..

  Hi Folks, I am trying to connect my remote sql database using the pocket pc emu. 2003. I am getting the error "SQL Server does not exist or access denied.". The thing is I have ASP. net projects and I connect without any hassle. I have also tried connecting to an online database using the pocket pc '03 emu. and it works....I just don't understand why it isn't working remotely.... Can someone kindly help I am not seeing the emulators manager. I was doing some reading...and saw that you needed to click on tools and the go to device emu. manager and I am not seeing that. I am using VS .NET 2003(C#). Also the connection string I am using is User ID=myuserid;Data Source=myserver(I pu ...Show All

• Visual C# Accessing printer spooler

  Hi, I am batch printing a number of reports but do not want to over load the print queue of the printer I am printing to. Does any one know if there is a way in C# to get a handle on the printer driver/spooler so that I can check if the current print is complete. If it is possible then I can delay sending the next report for printing until the previous one has finished. This would also solve such bottle necks as running out of paper... Thanks Andrew ...Show All

• Visual Studio 2008 (Pre-release) controls on top of each other

  I got a scenario, where I have to have some controls pop up on top of some other controls, basically just like a popup. So in my first attempt i used a Popup, but this element has some behavior, which gave me headaches. The biggest problem was, that the popup won't follow the original pop-up location when i.e. the window is moved or the content of the panel is scrolled up or down. Then I thought about using an adorner. Everything worked fine, except that I cannot interact with any control in my adorner layer. Here's my adorner class: using System; using System.Collections.Generic; using System.Text; using System.Windows.Documents; using System.Windows.Controls.Primitives; using System.Window ...Show All

• SQL Server Error Code if Row is locked

  Hallo, if a row is locked in SQLExpress and an other user want to update this row, SQLExpress waits until timeout. And than I get the errormessage "timeout". What I need is an immediately errormessage "row is locked" ! So that the user dont need to wait if the row is locked and I need the correct errormessage so that I can check if there is a databaseproblem or only the row locked because an other user is editing the same rows. Thx Wolfgang (please excuse my english) Thank you for your help! I need a small timeout if the Updatecommand "meets" locked rows. I do not want to reduce the timeout for the SqlCommand itself. The solution i have found is to use the keyword ...Show All