Answer Questions

• priyanka.dash from database to excel

  Hi. I have 3 colums in my database: Machine#: Regularhours: Overtimehours: 444444 5 6 555555 5 6 444444 4 0 I want to display (maybe msgbox or write to Excel file) only not repeating Machine# with overall Regularhours and Overtimehours. Secon question: how can I update my database Thank Hey Renee, I don't believe any assumptions are being made about the type of DB.  We are telling him to use Structured Query Language to get the data from the database to excel...Of course like I told that other poster, if you have the Access application, there is a menu item for importing from exportin ...Show All

• leclerc9 File Properties

  I'm Trying to make a app that can change a files properties with the following code for applying the read-only property. It compiles and runs, but never changes the property... Any ideas The code for the button press is: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim filetoapply = "" If OpenFileDialog1.ShowDialog() <> Windows.Forms.DialogResult.Cancel Then filetoapply = OpenFileDialog1.FileName Shell("cmd.exe /c ATTRIB +r " & filetoapply & " /s", AppWinStyle.NormalFocus, False) Else filetoapply = "" End If End Sub Better advice: System.IO.FileInfo.IsR ...Show All

• ramsarvan Subscribing Check-in events using tfs api?

  Is it possible to use the TFS API to create a tool to subscribe check in events. The problem with Bisubscribe.exe has to run on the application server. For many reasons we cannot always do that. Also, running a webservice on the application server requires a lot of maintenance. But webservice is still an option. I wanted to find out other possibilities. Please reply. Thanks, Parth Bissubscribe tool can be run on the client machine as well, check its params, it has one "/server " param wich is used to say in which TFS server you want to create the subscription, so you can use it from remote clients, with the Team Client installed as Naren said. Also, check out this project: http://www.projectdistributor.net/Pr ...Show All

• Kyle McK Allocating memory to array

  Hi, I am declaring a character array of size 10, e.g. char[] var=new char[10]; var="Anil Narayanan".ToCharArray(); The 'Q' is why am i allowed to assign a string > 10 characters. Why doesn't the compiler generate an error It generates a run-time error only when i try displaying the contents of the array through a loop, otherwise it works perfectly fine. Pls clarify. Thanks in advance Anil It is possible. You must first see the difference between return an array reference , and modifying an existing array . You can return an array with ToCharArray, so it "writes over" the existing array (in fact the variable just refers to different memory allocation, and old allocation is deleted eventually) ...Show All

• DanMeyers TFS VPCs

  I am unable to find the current VPCs for TFS on the MSDN subscriber downloads. Is this no longer available as a VPC The Orcas VPC is out there, but when I downloaded it, it didn't seem to have TFS on it. (Just the client Visual Studio stuff.) Am I wrong on this Take a look at the viewer feedback (comments) on this post to see if anything helps: http://blogs.msdn.com/bharry/archive/2007/01/11/january-visual-studio-orcas-ctp-available.aspx So Visual Studio Team Foundation server is on the Team Suite VPC as well hmm, i downloaded virtual pc 2004, the base image and the team suite image of orcas today. created the virtual pc, when starting it asked me for the base image ... so far so good ... unti ...Show All

• AIMDBA type bool

  Hi, Could someone please tell me why the compiler won't accept the type bool I'm not using the SDK. Is there a header file I need to include (Visual Studio C++ Express). Thanks.   WENZU5 wrote: Could someone please tell me why the compiler won't accept the type bool I'm not using the SDK.  Is there a header file I need to include   (Visual Studio C++ Express). To add a couple of thoughts to what nobugz and Martin have already provided: 1. bool is not a standard type in C , only in C++, and that might be your problem, as nobugz mentions.  2. If you ever build native Win32 WinApps , using the Platform SDK, then you may need to be using BOOL (capit ...Show All

• Tryin2Bgood How can I create Dynamic Query between two dimension parameters.

  I have created a report which has two parameters: Build and Run. I want to create Dynamic Query between them. ex. If I select a value of @Build, then the @Run should be generated by @Build. That is to say the @Run should just display the values which have run on the selected Build. Any help highly appreciated. Thanks, You can set the Report Parameters Default value to come from a query. For an example see the Builds report. When you select a Flavor, for example, the list of values in the Build parameter change accordingly. The default value for a parameter can be set (in a Report Server Project) by selecting Report -> Report Parameters (having the Data or Layout view active -- not the Preview ...Show All

• Jough MSF Documentation: RUP vs. MSF - A comparative study

  L.S., This thesis makes a comparative study of two software engineering processes, namely the commonly used IBM Rational Unified Process and the new Microsoft Solutions Framework for Agile Software Development. Both software engineering processes have the same objective, to create a solution that meets the needs and expectations of the stakeholders. However, they have different approaches to reach their goal. The Rational Unified Process focuses on the time schedules and budget to create a predictable and disciplined software development environment. Microsoft Solutions Framework for Agile Software Development does not believe in predictability, it considers the fact that changes are inevitable and do occur during the software devel ...Show All

• Chaithanya J Upgrading TFS trial edition

  I just upgraded our TFS application tier server with our new key, which was easy. Now I want to upgrade my data tier server as well. However, there is no way to enter the key there. Is that right Thanks, Thijs Adam, Thanks for your reply. I found that article also but it does not mention the TFS upgrade for a dual tier setup. It only mentions data tier and app tier where the SQL upgrade is concerned. So for now it seems that once you upgrade the app tier the data tier just follows that. Which raises the question: why do I need 2 licenses then I'm not sure I understand-- you need one license for the Team Foundation Server. Note that users who connect to the server will also need a Client Access License (CAL), which is include ...Show All

• ramjamman Technical Differences btw. VS Load Test and Load Test Agents and Controllers

  Hi, I was asked today if there are any significant differences btw. the load test functionality of the Tester's Role / Team Suite and the agents Does the Studio have a load test controller and agent included for doing load tests Another question that came up was, if it is possible to use a VS Test Client as an additional agent in a rig Last but not least I was not sure where exactly (on which server) the testee is run when using a rig for testing. Thanks in advance, for any answers. Tom Hi Tom, I'll try to answer you questions. Ok first of all the Team Test Load Agent SKU is a separate product, that you can use to execute your tests on different machines. It basically consists of an agent and a co ...Show All

• kenny125 inserting into an array

  I need to insert a comma separated string into a two dimensional array. The data will be in the following format: (an order number followed by a quantity number for each. e.g. 12345611, 1, 1234566, 1, 13131313, 3, 2112121212,1 Can anyone please help Try something like this: public static int Csv2Array(string csv, int[,] array) { // Converts <csv> to a 2-dim <array>, returns number of elements int cnt = 0; for (int ix = 0; ix < csv.Length; ) { int jx = csv.IndexOf(',', ix); if (jx < 0) return cnt; int kx = csv.IndexOf(',', jx+1); if (kx < 0) kx = csv.Length; array[cnt, 0] = int.Parse(csv.Substring(ix, jx - ix)); array[cnt, 1] = int.Parse(csv.Substr ...Show All

• Buddhist Reporting Serrvices Error

  When I told users to view reports in Project portal after setting them as Readers/ Contributors in TFS project portal setting, they complained that they can not see any report and get this error: The permissions granted to user 'Domain\UserId' are insufficient for performing this operation. (rsAccessDenied). There are lots of info about this error from SQL Server 2005 standpoint. But when I am trying to give users access to TFS team projects, what extra things I have to do for them being able to see the reports. Unfortunately, in V1 you have to separately control permissions between TFS and Reporting. In this case, the error is coming from reporting services (the "rs" part of "rsAcc ...Show All

• DeanoCalver Multiple vsmdi files

  Hi, We are getting multiple vsmdi files.Everytime someone runs a unit test the solution is automatically checked out and a new vsmdi file is created using the naming pattern MySolutionName1.vsmdi, MySolutionName2.vsmdi, etc. I've compared the files and they are the same. They live in the solution root and always have. The workaround that we have is to undo checkout on the files in question and then it works fine unti one next restarts the IDE. Any ideas anyone else getting odd behaviour with vsmdi files I've C&P'd the XML contents below:   < xml version="1.0" encoding="utf-8" > - < Tests >   < edtdocversion branch =" retail " build =" 50727 " ...Show All

• m14cus Public Properties.. Help

  Hi there. I want to create an application that the user will write down one string in a text box, named strTest, in the first form (Form1) and then will hide Form1. The strTest string of the Form, is going to be handled in another form Form2. I've tried to make public properties or to create a new class, but I didn't managed to solve my problem. What I have to do I would appreciate if you could send me a example code.. I would really appreciate any help of you.Thank you in advance.. Thank you very much I've done it... create a constructor which accepts a string parameter on your Form2 and instantiate your Form2 passing in your strTest parameter: //*Form1.cs Form2 frm2 = new Form2(strTest.Text); ...Show All

• Ferzle Saving and Opening files

  I want to save and open a file with a unique extentions. How do I do that Are there other ways to do it besides writing a text by console. And to do it where it performe an action when the file is opened. For example: Writing a text to a lable and saving it onto the computer as file with a unique extention and when you open that file with that unique extention the same lable comes up. I was thinking that this function might help. I dont know. I am not that good with enmues in VB. Overloads Public Shared Function Open( _ ByVal path As String , _ ByVal mode As FileMode , _ ByVal access As FileAccess _ ) As FileStream http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpr ...Show All