tom_xiao's Q&A profile

• Visual Studio Copy build files

  Hi, I need copy all my build files in a result folder. I use this task but don't work... Can you help me Thanks <Target Name="AfterBuild"> <Copy SourceFiles="@(TargetDir)" DestinationFolder="c:\foocopy" /> </Target> Not sure if you've redefined TargetDir, but looks to me like it would resolve to a path, where what you want is a list of files...since you can't ...Show All

• Microsoft ISV Community Center Forums VBA and Excel Deleting Worksheets without user interaction

  Hi I have a VBA application in Excel where I want to delete quite a large number of worksheets in a workbook, and I want to do this without user interaction. Unfortunately the modal dialog pops up each time and waits until I click OK. I have looked but can't find a way of preventing the modal dialog from appearing. Does anybody have any ideas on how to solve this Many thanks in advance This examp ...Show All

• Visual Studio iwizard vstemplate

  What is the proper way to abort loading of my custom package I added a cancel button to my form for new project types and I want to abort loading if they click cancel and return to VS2005. The form is being shown from my class that inherits IWizard interface. Mike Try this code in the cancel button action handler <CLSCompliant( False )> Public myWizRetval As EnvDTE.wizardResult myWizRet ...Show All

• Visual Studio Team System Problem with Workitem access control - does VS cache things?

  Hello! We have a problem with what seems to be access control in the work items. We are running TFS Workgroup edition (with domain accounts) on single-server installation Virtual Server running on Windows 2003 Enterprise Edition R2. The TFS version is RTM Workgroup. The problem occurs on user account that was defined to be Server and Project administrator as well as belongs to SharePoint services defined administrator user group. ...Show All

• Windows Forms DataBinding to a SQL Field of type money

  Has anyone ever had a problem DataBinding to this field type   I have a method that sets up all my DataBindings for my controls on the form and when I run it I get this error: "DataBinding could not find a row in the list&nb ...Show All

• Visual Studio Team System Dropping Files into Source Controlled Projects Fails Checkout

  I have just created a project within Team System and checked the source code in. Now when I drag and drop newer files in, generated from CodeSmith, it asks the following questions... "Destination File Exists [Title] A file with the name "xxxxxx.cs" already exists. Do you want to check this file out and replace it [ ] Apply to all items. Yes, No, or Cancel" I select "Apply to all items" and then " ...Show All

• SQL Server SQL Server 2000 Personal Edition or Enterprise Edition

  I am trying to access SQL Server from a seperate VMWare session. I have instsalled SQL Server 2000 Personal Edition on my main PC and am trying to access it from a seperate VMWare session. When I do this, I get the following message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. I have checked my Enterprise Manager and is is setup with SQL Server and Windows authentication. Am I able to ...Show All

• Visual Basic Dynamically populating a combo box .?

  I am trying to populate a combo box on a form based on the contents of a field within SQL. i.e. I read the data from the SQL field.  In this case I return the string "Select * From Transactions" I populate my dataset and set the dataset as the datasource of my combo box.  This works fine. However what I want to do is to use a where clause in my select statement such as "Select * From Transactions Where AccNo = '" & strAccNo & " ...Show All

• SQL Server Free space information in Management Studio

  In Enterprise Manager, the taskpad view showed me how much space is available in the data and log files. Is this information available anywhere in SSMS For instance, in one database EM shows me that I have 1200MB free in the data file and 400MB free in the log file. It also says, at the top of the taskpad view, that I have 0 free space in the database - I'm not sure how they relate, but in SSMS the only number that I can see is the 0. It also t ...Show All

• Visual Studio Tools for Office Adding InfoPath Form as Mail Attachment

  Hello, I try to add an InfoPath form as a mail attachment with vsto. I create my mail with this code : Outlook.Application outlook = new Outlook.ApplicationClass(); Outlook.MailItem Email = (Outlook.MailItem)outlook.CreateItem(Microsoft.Office.Interop.Outlook.OlItemType.olMailItem); Then I try : Email.attachments.add() but : 1) I don't know how to get the form. Should I use thisXdocument 2) what arguments should I use in the method add ( ...Show All

• Windows Forms right-click event

  where is right-click event on button and another cotrols I can't see it in events list... This answer is for .NET only. If you are not referring to a Windows Form (eg. this is MFC), then please ignore my answer. You have to catch the MouseClick event. This event catches both left and right mouse events (and middle button and 4th button and ...). In the click handler, the 2nd argument is a MouseEventArgs objec ...Show All

• Visual Basic Connection String with Inherited Forms

  What I’m trying to do is put some common procedures into a project, and have other projects inherit from these forms, but I am having problems passing my connection string to these forms. I have an user setting that I add the user name and password that the local dataset uses, but the inherited forms have their own database and connection which works fine in that project. Thanks Pass the string in the ...Show All

• SQL Server HELP - Problem with Replication

  Hello, I have transactional replication running between two SQL Servers. It's a push subscription and the distributor is on the local publisher. Recently after running for a year the replication stopped working and we get the following two errors. 1 - The process could not bulk copy into the table "History_Rep" String Data, Right Truncation. Error Number 22001. ----------------------------------------------------------- ...Show All

• Windows Forms Using Keyboard and Mouse Hooks

  Hi all, I am using win-32 hooks to implement macro recording and playback functionality for our application. This is not general purpose utility to use across application but a feature within the application. I launch record/playback palette as dockable window during recording/playback sequence. I am using Sendkeys.Send during playback to simulate key strokes. Currently I am facing typical problem during playback with Pause functi ...Show All

• SQL Server File in use error on connecting to database.

  * Running SQL 2005 on XP Pro * After running a ETL package to populate a sample DW which completed successfully, I attempted to open the SQL Server Management Studio.  After login, an error was reported : TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFOR ...Show All