Edward Stephen's Q&A profile

• Visual Studio Team System Link Work Item to document on project portal

  Is it possible to attach a link to a Work Item that points to a document on the project portal For instance, if you have the work item Create requirements document, you would want to have the finished document in TFS. Either attached to the work item or in some document folder on the project portal. The latter one is the better location, I would say, but then I would want to link the work item to the document on the portal. However, it is only possible to link to a document if it is a Source Code File. The target item seems to point to the sharepoint portal, but I can't find my uploaded documents. What am I doing wrong Thanks, this ...Show All

• SQL Server how to convert rows to columns

  hi i have a sample data like patientno visit experimentdate 101 1 23-Dec-2004 101 2 23-Mar-2005 101 3 23-Jul-2005 102 1 23-Dec-2004 102 2 23-Mar-2005 102 3 23-Jul-2005 i want it to display like this patientno visit1 visit1date visit2 visit2date visit3 visit3date 101 1 23-dec-2004 2 23-Mar-2005 3 23-Jul-2005 102 1 23-dec-2004 2 23-Mar-2005 3 23-Jul-2005 ..please suggest how can we do it select patientno ,visit1 = max(case when ...Show All

• Visual Basic Where is the executable created by ClickOnce Deployment?

  ClickOnce creates on the target server an application reference (extension appref-ms) which is used to start the application. I cannot find the executable. I use a service that starts automatically other (non-service) programs after a restart. This program requires the path of the executable. Many thanks, Dan The ClickOnce Deployment does not place the executables in c:\Program Files, but in folders such as this one: C:\Documents and Settings\wa1\Local Settings\Apps\2.0\2431K6CQ.OLW\CEKX2VEB.P7R\easy..tion_6ce3c96fe75c93ea_0001.0000_85d54fc9d1298abc One can find this folder making a Search w ...Show All

• Visual Studio August CTP Visual Studio 2005

  Hi,   I installed Augist CTP of VS2005 and it also does not have the Microsoft.VisualStudio.Package.Project.dll. hence how do I build my VSIP packages referencing Microsoft.VisualStudio.Package.Project.dll. Posts on this forum indicated that August CTP of VS2005 worked fine. Thanks, -K  There is no version of the SDK with package.project for RC. You will have to go back to one of the SDKs that supports B2. July or Aug. But, that wont be much help because it will depend on an assembly that is no longer part of the product. Really, its best to wait the 2 weeks until our Oct CTP is out. ...Show All

• Visual Studio Express Editions error during installation

  Hi, I receive the following error when I try to install the express edition: Error 1935. An error occurred during the installation of assembly 'Microsoft.VisualStudio.Configuration, Version="2.0.0.0", etc. I had the beta version of Visual Web developor installed, but I have since uninstalled all versions of vs, the framework, and sql server. Does anyone have any other ideas Thanks. Please read this blog entry from Aaron. http://blogs.msdn.com/astebner/archive/2005/11/10/491653.aspx ...Show All

• .NET Development problem with com object

  Hi, I must create a com object that has some methods described in an interface. One of this methods is          new(par1,par2,par3) as short The only problem is that i can't create a method with such name because it is seen as the constructor of the com object (and the constructor for the com object must have no parameters). So when i write Public Function new(...) as short i get the message The constructor must be declared as Sub and not as Function Thanks for your answer, i did not knew this feature of .net. However my problem is that i am writing the com " ...Show All

• Visual Basic When I open a form "FORM.VB" how do I auto exec a sub in form "FORM.VB" ?

  When I open a form "FORM.VB" how do I automatically execute a sub in form "FORM.VB" Michael   Michael Dyrnaes wrote: When I open a form "FORM.VB" how do I automatically execute a sub in form "FORM.VB" Michael Call the sub you want to execute from the form load event: Private Sub Form1_Load ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles MyBase . Load InitForm () End Sub ...Show All

• SQL Server Adventure Works.sln DEPLOY ERROR first time

  After opening the Adventure Works.sln. I build. I deploy. I get the following error ... ------ Build started: Project: Adventure Works DW, Configuration: Development ------ Started Building Analysis Services project: Incremental .... Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: Adventure Works DW, Configuration: Development ------ Performing an incremental deployment of the 'Adventure Works DW' database to the 'localhost' server. Generating deployment script... Add Database Adventure Works DW Process Database Adventure Works DW Done Sending deployment script to the server ...Show All

• Visual C# Cast string to variable?

  Is there a way to cast a string to a variable name In my code I need to instance classes on the fly. In psuedocode I want to do this: Variable KeyValue<x>; With <x> being replaced by an incrementing number on every call (so you might end up with KeyValue0, KeyValue1, KeyValue2, etc.). Is there any way to do this in C#  I recall a way in Pascal, but that was many years ago... No, there isn't a way as the variable name must be known at compile time. You could implement this using a collection class such as:   // in your constructor List<Variable> m_keyValu ...Show All

• SQL Server Remote creation of a Maintenance plan

  I'm trying to remotely create a maintenance plan using the management studio in order to backup databases. I get the following error. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// TITLE: Maintenance Plan Wizard Progress ------------------------------ Create maintenance plan failed. ------------------------------ ADDITIONAL INFORMATION: Create failed for JobStep 'Subplan'.  (Microsoft.SqlServer.MaintenancePlanTasks) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microso ...Show All

• Visual Studio How to add items to toolbox

  I know this is strange, and it's a long story about how my team got to this place, but we are producing a set of dependent assemblies that are stored in different bin directories. When we try to "add" one of these assemblies to the toolbox so we can use the controls it defines, the "add" fails because VS cannot find the other assemblies it depends upon because they are spread over several other directories. Is there any way to control WHERE VisualStudio looks for these other assemblies when adding to a toolbox tab VS will look in the folders listed within devenv.exe.config at the value given in the probing t ...Show All

• Visual C++ Need help C++

  Hi, I have a program written in C++. I want to create a track tool that even running in Release version, the track tool also records into a text file every line code that get executed. I need this tool because I got a customer running our program and get error which I can't reproduce. So I want to know which line code is a last executed before the error occurs. Any idea is appreciated. Thanks Why don't drop your customer an instrumented version of your application that record any debug info or traces. Also, you can probably remote debug the application from your customer's machine. Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server Encryption By Passphrase

  I am investigating methods of encrypting data in a large number of databases. It seems to me that encrypting by passphrase would be optimum because it would prevent me from having to create all those database and symmetric keys on the various databases (there wil lbe dozens of them). Can anyone give me any advice as whether or not using encryption by passphrase is a good secure method of encrypting sensitive data in a large-scale production environment I would most likely create a unique passphrase for each database and pass it to a stored procedure as an imput parameter. Thanks, Al If you en ...Show All

• Visual C++ How to get rid of the funny scroll bar or expand it in a Dialog?

  I add items to the comboBox by _ASSERT( CB_ERR != SendDlgItemMessage(hwndDlg, IDC_LIST_CONTEXTS, CB_INSERTSTRING, 0, (LPARAM)_T( "None" )) ); In C#, the comboBox automatically drops down to a certain size before it has that scroll bar. Here in my C++ Dialog, the comboBox when you click on the down arrow, it drops down another row with a tinny up and down button(underneah the comboBox's big down arrow button) for me to scroll through my small list of just 3 items. Can any one tell me how to fix this problem Thanks. It's a weird quirk of the dialog resource editor. Sorry, this is going to be quite tough to explain w ...Show All

• Smart Device Development Sorting NETCF DataGrid

  Hey Everyone, I've got a NETCF DataGrid that is being populated by Fill method generated for a SQL Mobile datasource. The DataGrid populates much quicker when I do not have an "ORDER BY" clause in the SQL statement. Is there a quick and easy way to sort the contents of the DataGrid programmatically outside of SQL Thanks, Lee DataGrid does not have sorting capabilities, in fact it does not even have data storage. It simply shows whatever's coming from data source. To sort data in the grid you need to sort data in the data source. DataTable has embedded sorting/filtering support (i.e. DataView class), ResultSet ...Show All