ACCOUNTINGONLINE.US's Q&A profile

• Visual Studio Team System Custom Check-In Policy: Time That Task

  I just created an interesting check-in policy and wanted to share it with you all. I'm interested in your feedback. Custom VSTS check-in policy that gathers hours worked on a task during each check-in. This policy requires check-in to be associated with only one task that is in an "Active" status. It also gathers the number of hours worked on the associated task incrementing the completed hours and decrementing the remaining hours. If the number of hours worked on code in check-in is greater than remaining work hours on the associated task, user will be asked to re-estimate the number or hours remaining for the task. http://www.gotdotnet.com/Workspaces/Workspace.aspx id=9375fae2-5104-4d46-8b3a-c0b170b08320 Reasons why I created th ...Show All

• .NET Development ExecuteReader requires an open and available Connection. The connection's current state is Open, Fetching

   cmd.ExecuteReader Run-time exception thrown : System.InvalidOperationException - ExecuteReader requires an open and available Connection. The connection's current state is Open, Fetching.  I'm having a issue with my program. My application does a search first, then the user has the ability to edit the search results. So first a datareader is created and the ExecuteReader is called and you know the rest. Then once the user is ready to submit their changes and executeNonquery is called and you know the rest. The code fails at cmd.exectuenonquery line. Here is my code First the user searches for records based off an id: Private Function RetrieveErrorRecords(ByVal ErrorID As String) As DataTable      ...Show All

• Visual Studio 2008 (Pre-release) downloading jan orcas - confused

  Hi, I have just installed VS2005 on my Vista laptop and now want to install Jan Orcas from here: http://www.microsoft.com/downloads/details.aspx familyid=1ff0b35d-0c4a-40b4-915a-5331e11c39e6&displaylang=en#filelist I am a bit confused as what to download - there are multiple files but I am not sure which ones to use. any help would be great - thanks ...Show All

• SQL Server SQL Server 2005 SP_ADDLOGIN

  Hello Everyone, We have a mixed environment consisting of some SS2005 with most servers still running on SS2000. Several operating systems are in use. We use mixed mode authentication. To date, all of our SS2005 servers have been installed on Windows Server 2003. In each of these environments we have the password policies disabled on the operating system side (Administration Tools | Local Security Policy). On these servers we have been able to successfully use SP_ADDLOGIN to add logins for SQL Server authentication. Recently I installed SQL Server 2005 on Windows 2000 SP4 (old I know) as a test environment. Like the 2003 servers, password policies and complexity are shutoff. When I attempt to use SP_ADDLOGIN, however, here I receive: Ser ...Show All

• Visual Studio Team System Portability

  How portable is TFVC to various operating systems, computer architectures, and other types of systems All communication with the server is done via XML web services. That said, re-implementing our client object model isn’t trivial; use it when possible. (I’m not sure how well it runs under Mono; in theory it should work). TeamPrise has a Java implementation and provides their own clients for Eclipse. Several other partners have built web interfaces. You can read about TFS extensibility here: http://blogs.msdn.com/jimlamb/articles/tfsfaq.aspx#Interop http://msevents.microsoft.com/cui/webcasteventdetails.aspx eventid=10322 58556&eventcategory=5&culture=en-us&countrycode=us http://msdn.microsoft. ...Show All

• Windows Forms Visual cue between groupings in DataGridView

  I want to give a visual cue to distinguish groups of rows with the same CompanyID in a DataGridView.  Is it possible to insert a separator on a break in CompanyID  Or would alternating background color be better/easier  What is the best way to achieve   Thanks. Take a look at the datagridviewadvancedborderstyle class ...Show All

• SQL Server SQL Server 2005 - Database Modeller

  Hi all, I was wondering which tools are you using to create your database models... I am using Visio, but I have a lot of problems with it. Is Microsoft has released a new tool for database modeling with SQL Server 2005 Thanks, Martin You can use the Database Diagram feature in Management Studio to do physical modelling of databases. Database diagrams are "live", so any changes you make in a diagram modify the database you are working to match when you save the diagram. Hope this helps, Steve ...Show All

• SQL Server Help required in import Data into sql 2005 from excel 4.0

  Hi I have to import data from a number of excel files to corresponding tables in SQL 2005. The excel files are created using excel 4.0. I have created an excel connection manager and provided it with the path of the excel sheet.Next i have added an excel source from the toolbox to the dataflow. I have set the connection manger, data access mode, and the name of the excel sheet (the wizard detects the sheet correctly) in the dialog window i get when i double click the excel source. Every thing goes fine till here. Now when i select the 'columns' in this dialog window or the preview button, i get this error TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [Excel Source [1]]: An OLE DB error has occurre ...Show All

• SQL Server Pie chart slice break up

  Hi, I have a pie chart i whih i show the slice percentages for some categories.There is a slice named Miscellaneous for which i need to show its break up as the mouse hovers over that slice.How do we do that Steps: 1. Open the chart properties dialog 2. Go to the Data tab 3. Edit the chart value (data point) which opens the "Edit Chart Value" dialog 4. Go to the Action tab 5. Add a "Jump to report" action -- Robert ...Show All

• Visual Studio 2008 (Pre-release) Need drag n drop example using xaml and vb

  I'm new to xaml and wpf and am wanting to learn how to drag and drop rectangles. I've found a number of samples all in c# but I havent been able to convert them to vb. One sample was by Lester Lobo at http://blogs.msdn.com/llobo/archive/2006/12/08/drag-drop-library.aspx and the other was by Josh Smith at http://www.codeproject.com/WPF/DraggingElementsInCanvas.asp . Can anyone recomend a good tutorial in vb Thanks. Dear moondaddy, Try this link http://blogs.msdn.com/unnir/archive/2006/01/31/521065.aspx Even though not in vb, you should be able to get an idea on drag drop operations. Let me know if you have any problems translating the code to vb. HTH, Suprotim Agarwal ...Show All

• Visual Basic Help!! Using labels

  Hi- I'm trying to write my first program but I really have no idea what I'm doing. How would you display text on a form without having it appear in a message box I think you would do something with a label but I have no idea how to use it. Also, if I have text in a button that is currently being displayed in a messagebox upon double-clicking on the button, how would I make it so that when you double-click on the button, it appears in a label Thanks!! Hey, I would use the videos here: http://msdn.microsoft.com/vstudio/express/visualcsharp/learning/default.aspx To learn how to code C# or VB or whatever (click VB section for VB) ...Show All

• Visual C# C# project unable to start debuging

  I can debug the code file in C# in administrator login of WinXP but could not debug the same using win2003 user on the same computer.Following message displays while debugging. Unable to start debugigng.Access denied. ...Show All

• .NET Development Reading A Single Line Of An XML Document

  Hi, I am using VB 2005 to create a hangman game and have saved a word document containing a list of words as an XML Document. Would someone be able to help me with loading a single line of the XML file into a String in VB 2005, I have tried using Readers etc but haven't got very far. Or better still... is there an easier way to load a single line of text from a file (e.g. a text file) without loading the whole text up to that line into an Array, as I have a file with 100,000+ words, which would take ages to load into an array. Thanks in advance for your help. //is there an easier way to load a single line of text from a file (e.g. a text file) without loading the whole text up to that line into an A ...Show All

• Visual Studio 2008 (Pre-release) How to get mouse position in screen coordinates?

  Is there any way how to get mouse position relative to desktop (in screen coordinates) I know about static method Mouse .GetPosition() but it requires parameter specifying IInputElement. Is there something like “screen” or “desktop” or something else I can use as parameter to GetPosition As I need to get this screen mouse position inside method in my class derived from Grid I could use this: PointToScreen( Mouse .GetPosition( this )) But still I think there could be some “desktop” object, or not Code Snippet using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawi ...Show All

• Visual C++ Exception handling showing undefined behaviour. Help !!!

  Question #1 : The following code crashes in Visual C++ compiler. It fails in the expression _BLOCK_TYPE_IS_VALID(). It means that, it is deleting a bad pointer. When I give a copy constructor, it works fine but the control does not even go in the copy constructor. Why is it showing this behaviour Question #2 : If I throw a local primitive type like an int, the address of that variable matches in the catch block if I am catching by reference. But for objects, the address for the variable in the catch block changes. Why #include <iostream> using namespace std ; class Exception { char * m_pszError ; public : Exception ( const char * p ) { cout << "Exception::E ...Show All