Lant's Q&A profile

• Visual Studio Team System New To Team System? Check out these resources

  Welcome to the Visual Studio Team System forums. My name is Ajay Sudan and I am a Product Manager for Visual Studio Team System. If you are new to Team System, then you'll want to check out the resources on the Getting Started with Team System page. Thanks, Ajay Sudan Product Manager Visual Studio Team System http://msdn.microsoft.com/teamsystem The beta 3 VPC is finally up on MSDN.  In the next week or so, there will be a beta 3 refresh VPC (yeah, famous last words). http://blogs.msdn.com/buckh/archive/2005/11/22/495875.aspx Buck ...Show All

• Visual Studio Team System Deleting a Team Project

  Hi, is there any way to delete a Team Project created by me From Team Explorer exists the remove option but I couldn't find one to delete all the different parts of a Team Project (SCC, Project Portal, Work Items, etc). Is it possible Thanks a lot LucasC In VSTF Beta 3, I can not even find the deleteteamproject.exe file. Can someone confirm that it is supposed to be present, and if so, where I've installed the data tier, app tier, full client, and have searched on all of them, to no avail. ...Show All

• Visual Studio Tools for Office Microsoft Word 2003 and WordML (How to Show/Hide Content in a Document)?

  All, How to show/hide specific sections(assume a paragraph) of a document by checking/unchecking a checkbox (I'm using Word 2003) How to lock/unlock a specific section(assume a paragraph) of a document based on (Checking / Unchecking)check boxes Can we achieve this without using VBA in Microsfot Word 2003 If at all i need to use VBA, as i'm not familiar with VBA, can anybody provide the sample code to show/hide parts(assume if i check the checkbox, i need to see a paragraph in the document, by unchecking the checkbox it should be hided) of the document using check boxes. Clear instruction with sample code (if i need to use V ...Show All

• Visual Studio Tools for Office Conversion between Word and Excel

  I was given a report with about 49 pages of tabled info, except it was in MS Word, for some obscure reason. Now, anyone can understand why you wouldnt want to recopy 49 pages of info into a spreadsheet, so i was wondering if anyone knew of a way to convert word doc. to excel. Ive already tried the conversion method described in the help section, but that didnt work for me, possibly because i have a better version than 2000. Is there any 3rd party software available Im willing to pay for the software. Any help would be appreciated. Thanks, Hi, This forum is for questions about VSTO. You might try posti ...Show All

• SQL Server Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an ...Show All

• .NET Development DataTables and NULL values

  Hi there, My question is how do I handle reading NULL values from non-string columns from a datatable I'm using Visual Studio 2005. I have a datatable that I fill from a table in SQL server. Many of the columns are nullable and that is reflected by the AllowDBNull property on each of the columns in the datatable. However when I access the values in a data row I get an exception. This is obviously because the NullValue property on the column is set to Throw Exception. So given that you can't set this to Null from column that are NOT string, my question is how do handle reading NULL values from non-string columns from a datatabl ...Show All

• SQL Server how to pass XML file path as input string to a Stored Procedure

  Hello All, I need to pass the file path (or hardcode the XML file path ) of an XML file to a stored procedure. This SP will then read the values from the XML file and based on these values the Insertion / updation will be done thereafter. I am not able to pass the XML file path to this stored procedure. Right now I an doing as givn below : DECLARE @idoc int DECLARE @doc varchar(1000) SET @doc =' <configuration> <appSettings> <add key="approvalMode" value="On" /> </appSettings> </configuration> ' EXEC sp_xml_preparedocument @idoc OUTPUT,'c:\Inetpub\wwwroot\HealthandSafety\Aspx\Ap ...Show All

• SQL Server Full-text index becomes unavailable

  Hi, I'm having a problem with full-text queries on Sql Server 2k (Enterprise Ed., SP4, IA-64). I have a full-text catalog which seems to be okay when (I query its populate-status and look at it in enterprise manager) but when i perform any query using the "freetext" operator/function i get an error as shown below: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator. This message is mentioned in two KB articles (none of which a ...Show All

• Windows Forms VS 2005 Toolbox Refreshing

  Hi, I have noticed that the toolbox in VS 2005 contains a tab for every projects in my solution that contains a component derived class. During builds of the solutions each of these tabs are being refreshed / rebuild and it can take a little time. Is there anyway of stopping this refresh, or is it a matter of removing the tab from the toolbox Maybe this is a bug that has been fixed post Beta 2 Thanks for your help Graham Mike, I am going to check that out first thing in the morning.  If that does it, there will be a lot of happy people in our office.  I asked multiple developers on my team to ...Show All

• SQL Server what is [SQL-DMO]

  in computer management, when i expand the branch of my sql2005 express, i got a error message. it seems i cant register my server, but i cant login in sqlcmd i also installed sql2000, and it works fine... could anybody help really strange This will never work.  You need to use Management Studio (full or Express) to connect to SQL Server 2005.  We have a bug file on our side to determine why the server is being registered.  If we fix the server registration problem, you still will not be able to connect to SQL Server 2005 through this means. Peter ...Show All

• Windows Forms Changing account property on a service at runtime

  I have a VB.Net class, witch is launched by a service proces.  The class try to acces a diskdrive on a network mashine, but dont get acces to this. I gues that it is because that the service that launch my object dont have the right network acces privilliges. My question is then: Is it able to change the account for a service (or better  ...Show All

• Visual Studio Team System Is VSTT an appropriate choice for our needs?

  Our team is rolling out VSTF to manage our other product group releases/QFE's and we are looking at only minimal testing (really just verification) of those pkgs. So I have a few preliminary q's that don't really seem to be easily answered in the waterfall of documentation on VSTF Is VSTT necessary to run a few basic scripts Are there other tools in the suite with capabilities similar to the web page recorder i.e., Is there a way to quickly record some basic GUI testing Can VSTT be installed on a client, or does it need to run on the actual VSTF server Thanks. I will try to answer: ...Show All

• Smart Device Development Deploying to external memory card

  Hi, I've been searching all over the place to solve this problem, which I wanted to deploy files into the external memory card (Compact Flash or Secure Digital) as the default location, instead of clicking "No" when deploying and select the location. I'm using VS.Net 2005 and the Smart Device CAB Project does not have the external memory card folder. I couldn't find any results searching the net for over 2 days. :( I hope someone can help me! Thanks! Don. The only way to do it is to set default installation path to hard coded storage card path. That is, however, bad idea as card names can vary ...Show All

• SQL Server MgmtStudio: Use current connection/window when opening file

  Is there a setting that I am missing, or is it just not possible to do. When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection. Is there a way that I can set it to NOT do this, and use the existing Window/Connection. As we have to SQL Logins and thus need to type our passwords each time a new connection is made... Also, is CTRL-N not in use anymore to open a new connection/window This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. Yo ...Show All

• Visual Basic Getting the connection string for a project

  I'd like to set a string variable to the connection string for a project. I've seen the build connection string module/function and tried to use it but it's hopelessly complex for what I want. I just want the string. Is there an easier way Hello. I'm not sure whether you're trying to figure out how to build the connection string or to query an existing one. For information on building a connection string the following site is excellent www.connectionstrings.com As for storage in your application that depends on a lot of factors. If you are using Windows authentication to access your serve ...Show All