Adraw's Q&A profile

• Visual Studio Team System TFSWarehouse DB tables is not getting updated

  On updation of contents from VSTS, the following tables of TFSWarehouse DB are not getting updated.Tables like Current work item, work item history, Work item , etc. This has directly impacted on the Reports generated through these tables. Whereas, TFSWorkitemtracking  DB tables shows the latest entries done through VSTS environment. There are no problem on creating/updating  any workitem. Please note, this trouble has been persisting since last few days. Please help ASAP Deepti, What version of TFS are you running Is it the RTM version or SP1 Beta Also do you see any errors or warning in the NT Event application log Thanks, ...Show All

• SQL Server "Copy" within a table - plain SQL

  Hi. I'm quit new into SQL - have a problem - and hope someone here ca n help me. I have a table TABLE1 with different fields. A part of it looks like this: FIELD1 FIELD2 FIELD3 111111 121212 0 111111 121212 91 222222 232323 0 222222 232323 73 etc. etc. I want to "copy"/write over '0' in FIELD3 with the number in FIELD3 from the line that has the same numbers (and unique for these two lines) in FIELD1 and FIELD2. The table will then look like this: FIELD1 FIELD2 FIELD3 111111 121212 91 111111 121212 91 222222 232323 73 222222 232323 73 I can make a temporary table or a new field if necessary. I j ...Show All

• Windows Forms Adding Files to the Partial class?

  When I create a form in visual studio it creates 2 files for me using the partial keyword to spread out the class. My question is: How do I add more files to that system I first thought I could just right click on the form in the solution explorer window and add new code file. That option was not there. I tried adding a new code file to the project, and then typing all the same "using"s, the same namespace, and the same partial class name, but then it made it its own form with its own 'designer' mode. I don't understand how it could even do that. All I want is to spread out my code to multiple files because this one big file is getting huge and ugly. Any help would be appreciated. ...Show All

• Windows Search Technologies Do I need to create a new store?

  I'm working on an app that stores files in "docs & settings\...\app data" in a profile. I want to add search functionality to my app. I've added the path to the indexable paths in WDS (2.6.5) and the docs I'm interested in get indexed, but I don't really want the to be returned normally by desktop search so I'm not happy with that approach. I thought I may settle for using 'in:myfolder mykeyword' but as far as I can tell I cannot use a full path for 'in' and it doesn't search recursive subfolders (is that right ). so I'm thinking I'll have to create a store so I can do something like "WindowsSearch.exe /url search:store=myapp mykeyword". If that seems to be the thing to do, then I need to create a pro ...Show All

• Visual Studio Express Editions Visual Basic 2005 Express Edition

  First the question - I am leery of removing my .NET Framework 2.0 prior to installing this program. I now have NET Framework 3.0 installed and am unsure if this will present complications. Second the history - I had this up and running and all seemed well, until I installed Visual Web Developer Express after having installed Visual Basic 2005 Express. When I did this I ran into problems. I was informed that there were updates for NET Framework 2.0 and 3.0 ... but they wouldn't install. I was instructed to first uninstall then reinstall 2.0 ... but it wouldn't reinstall, and everything started going wrong with my computer ... so much so that I reformatted everything and reinstalled everything ...up to the point where I am now read ...Show All

• Visual Studio 2008 (Pre-release) WPF & Thread.CurrentPrincipal

  In a method which is attached to the loaded event of a window I am setting the thread.currentPrincipal to a custom principal object which I manually create. If i try to access the same thread.currentPrincipal in a method which is attached to a button click event the thread.currentPrincipal in this click method is automatically set back to a generic principal. Why In retrospect if I set the thread.currentPrincipal to my custom principal in one button and access it from another button its fine and is never reset to a generic principal... Anyone have any idea whats going on Actually, you are encountering an intentional feature of WPF. The Dispatcher is the central pump that keeps things moving in the applic ...Show All

• Visual Studio Team System Visual Studio 2005 Team Foundation Installation Guide

  It seems the link to the Visual Studio 2005 Team Foundation Installation Guide is broke http://www.microsoft.com/downloads/details.aspx familyid=e54bf6ff-026b-43a4-ade4-a690388f310e&displaylang=en File Name: TFSInstall-v61004.chm Version: 8.0.61004 Does anyone know of a link that works The URL above works fine for me, but the version is now 8.0.61230. Looking at Rob Caron's blog the guide was recently updated so I'm guessing you hit the site while they were doing the update. Give it a go now and see what happens. ...Show All

• SQL Server How to display money type data with commas every 3 digits?

  How to display money type data with commas every 3 digits I tried : CONVERT (money, ProjectCost, 1) AS ProjectCost but it gives me the type as 1234.56 no commas in it can anyone help me with that thanks! I think the best answer is "it shouldn't be." You should use the presentation layer to format data and not use SQL. The presentation layer should be fed raw data as often as possible. But if it is one of those situations that you can't avoid, the other ideas with converting to a varchar will work. ...Show All

• SQL Server Why date Columns default to 1900 after inserting dates in SQL Server Everywhere.?

  I have created a sample Database for the school project, After executing the query below, the Date column is supposed to have the dates I have entered before, However the dates shown are 1900. Any idea why is this happening I appreciate your help. Thank you. Query:   Drop table AccountReceivable GO --BEGIN TRANSACTION Create table AccountReceivable (   AccountRecID int identity ( 1 , 1 ) not null,   PatientID int not null,   PresentCharges int default 0 not null,   PaymentMade money default 0 not null,   PreviousBalance money default 0 not null,   BalanceDue money default 0 not null,   LastPay ...Show All

• SQL Server ReportViewer (WinFprms) View Reoprt button

  I'm using the ReportViewer winforms control. It works great except for one annoying issue. The "View report" button shown to the right of the parameters for the report is rendered too far to the right. So when my application is running in 1024*768, the button is rendered outside the visible area. It doesn't seem to make any difference if I have one or several parameters, the problem remains. Is there any way of controlling the renderingposition of that button Regards Andreas Thank you for your answer Teo (even though it wasn't the answer I wanted to hear) =/ Sounds like something to improve until the next release of the ReportViewer control, or ...Show All

• Visual Basic in my vb.net windows application i have a requirement of automatically pressing the prtscr button

  in my vb.net windows application i have a requirement of automatically pressing the prtscr button in the key bord form every 5 minutes i am using the timer control but i dont know how to do automatically pressing the prtscr button event my requirement is to taking screen shots for every five minutus for every five minutus i am using the timer control and i dont know how to execute the button press of prtscr button for every 5min You don't need to push the button. Use the code from these threads: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=874972&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=644666&SiteID=1 ...Show All

• SharePoint Products and Technologies Integration of web app to Sharepoint Portal 2007

  Hi, I am wondering if it is possible to integrate an existing web application into Microsoft Sharepoint Portal. The application could be in the form of an opensource cms or web digital assets management (images/documents/videos) application in J2EE, php running Oracle/MySQL. If yes, what are the factors that have to be considered How can i do it Any links, resources would be great. If not possible, pls explain as well. Thanks a million! Hi, What are the things you need to know about the existing application How would the migration be done Is there some kind of generic template or wizard that facilitates this Wud appreciate if i could be pointed to the right direction in this. Thanks ...Show All

• .NET Development How to send folder in stream

  Is where any way to send folder direct in stream with all content inside it (structure, files, subdirs) with an ability to recover it later from that stream You can serialize FileInfo objects into a stream. You'll find a code sample below. When you deserialize the stream, you could re-create the folders with the information in the FileInfo object. What you're going to do with a file is murky; you can recreate it but not recover the data. using System; using System.Windows.Forms; using System.IO; using System.Runtime.Serialization.Formatters.Binary; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sende ...Show All

• SQL Server implement manual replication between two SQL Server 2005 Express?

  Hi, I need to synchronize the data between two SQL Server 2005 Express. The database is really simple, just few tables (but data are inserted very often) without any triggers. Since Express edition could not behave as a Publisher I was thinking about implementing manually a sort of Replication mechanism... It should be a sort of Transactional Replication with queueud updating. Does it sound a good idea Has anyone done this before o there are better solution Thanks in advance, Stefano Hi Andrea, Thank you for your kind response... I know that the Express edition doesn't have the SQL Server Agent nor it does support Replication (as a Publisher). In fact I was wondering how to achive a similar behaviour con ...Show All

• Windows Forms Print Preview problem(Bug)

  Hey, I have this code in the PrintDocument control under the PrintPage event: private void printDocument_PrintPage( object sender, PrintPageEventArgs e) { RtextboxUC thisrichtextbox = GetCurrentTextBox(); //Start printing text and store last letter... checkPrint = thisrichtextbox.Print(checkPrint, thisrichtextbox.TextBox.TextLength, e); //Check if there should be more pages if (checkPrint < thisrichtextbox.TextBox.TextLength) { e.HasMorePages = true ; } else { e.HasMorePages = false ; } } There are no errors, but when I test it on my program and click print preview...when it opens the PrintPreview dialog It shows the dialog that is telling you how many pages it is det ...Show All