TedSA's Q&A profile

• Visual Studio Team System Strange Problem --- SQL Server 2005 and TFS and Team System

  We are implementing TFS and have imported legacy work items from Excel spreadsheets. I want to connect two groups of these workitems as related work items by going into the dbo.LocalRelatedEdges table in the TFSWorkItemTracking database. I wrote a vb .net routine which inserts into this table the related ID's which should then show a related work item under the links tab of the Team System GUI. I used ADO.net (sqlclient.sqldataadapter) to accomplish this. The insert works correctly and the row is populated correctly in the table, but the related work item does not appear in the Team System GUI. But, if I manually go into the SQL database using Microsoft SQL Server Management Studio and enter the values directly into the table, the related ...Show All

• Visual Studio Express Editions How to serialize a TreeView

  I'm using a TreeView Component for my Favourites list in a web browser i'm making and i want to save the nodes(TreeView nodes) into a xml file in such a way as i can load it back up when the program loads next the following code is the problem, i dont know how to make my xmlwriter write the nodes into the document, can anybody help Dim writer As New XmlSerializer(GetType(TreeViewAction)) Dim file As New StreamWriter("C:\Program Files\Moose Inc\DHWB\Bookmarks\Bookmarks.xml") writer.Serialize(file, TreeView1.Nodes) file.Close() (PS. i Apoligise for the double posting of this, but i need the answer as quick as posible and the other topic went cold) Take a look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID ...Show All

• Windows Forms Can i use ClickOnce

  hi all. I have created a windows app that i want to distribute to my users for installation. I am testing out the clickonce technologi, but there is something i can't figure out. When i publish my app, i publish to a public server. All users can click to install. So far so good. But where is this program installed on client computers. If i search my computer i can't find the installation folder or icons. I have a icon in my start-menu which starts my application, but i also use settingsfile in my app. Where can i find this I am beginning to belive that i can't use click once and that i have to create a normal setup project . My application is beeing further developed so i need the "new version available". Can i ...Show All

• SQL Server BUG: UPDATE updates not listed fields

  Hi Everybody, I am in this forum for a first time. Today, I think, I found a bug in SQL Server 2000. I tried it on SQL Server 2005 and it is alive yet. Before I explain exact the problem I have a stupid question. Is there any type of award if I have found a real bug. It is about a situation when I try to update some fields in a table and I get updated some other wrong fields. There aren't any triggers ot something else. Create a new table, insert one row, update some fields but other ones get changed too. Is there something known about this Thanks, Hristo. Obviously, it was fixed. That version you are using is the original SQL 2000 released over 3 years ago. The solution is update. There are many m ...Show All

• Visual Studio Unable to open/debug a remote site from VS2005

  I am trying to set up a new testing server (running Windows Server 2003 R2) for remote debugging of my aspnet applications with Visual Studios 2005, but am encountering problems with Front Page Server Extensions. When I first try to extend the site, either through IIS (with the Configure Server Extensions 2002 task) or the Microsoft SharePoint Administrator link, the IE browser seems to hang while trying to open fpadmdll.dll from the Microsoft SharePoint Administration site which was installed with fpse. However the extension appears to have been successful since if I try again I can now access the Site Administration Page after entering the username and password. Once here, I try to create a subweb specifying the ...Show All

• Software Development for Windows Vista Limit Values of Dependency Properties

  I have created a custom activity which has as a dependency property an integer. I would like the designer to only allow users to type in numbers between 1 and 10. Is there a way to do this Do I have to write an activity validator for the activity to do so Amanda Amanda, You would check this in an activity validator, yes. Use the base ActivityValidator class and the ActivityValidatorAttribute to hook this all up. Matt ...Show All

• Visual Studio Express Editions Fill an array from a text file.

  Sir/Madam, I need to fill an array from a text file. My text file looks like this for different people. First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone Do you know of any way to put these into an array from a text file where the "|" symbol seperates the columns Any help would be greatly appreciated! Here is one way of doing it in c#. For small file this might be good enough. For larger files, however, this is not the most efficient approach. You may want to read up on Generics or build your own custom collection class. int i = 0; co ...Show All

• Visual C# how to known whether printer is connected

  how to known whether printer is connected ,is it on or off,is it ready to print . thanks   public static bool testConnection() { // Set management scope ManagementScope scope = new ManagementScope ( @"\root\cimv2" ); scope.Connect(); // Select Printers from WMI Object Collections ManagementObjectSearcher searcher = new ManagementObjectSearcher ( "SELECT * FROM Win32_Printer" ); string printerName = "" ; foreach ( ManagementObject printer in searcher.Get()) { if (printer[ "WorkOffline" ].ToString().ToLower().Equals( "true" )) { // printer is offline by user MessageBox .Show( "Your Plug-N-Play printer is not connected." ); // return false; ...Show All

• SharePoint Products and Technologies Setup Error: This product requires ASP.NET v2.0

  Please help, trying to install WSS 3.0 on a x64 W2K3-server that is running WSS 2.0, but i get an error at the beginning of the setup: "This product requires ASP.NET v2.0 to be set to 'Allow' in the list of IIS Web Server Extensions" I have verified that it is set to allow, so that is not the issue. I am having the exact same problem... I am also running the x64 version of Windows Server 2003. To take it a step further, when I try to run the SharePoint 3.0 installer, I get the following error language: Setup is unable to proceed due to the following error(s): This product requires ASP.NET v2.0 to be set to 'Allow' in the list of Internet Information Services (IIS) Web Server Extens ...Show All

• Visual Studio Find text

  I am using VS 2003 and working on a vb.net project. Is there an option that will cause the Find Text to search the closed regions on an open document ...Show All

• SQL Server SQL 2005 Express on Server 2k3 Enterprise

  After a few failed installs I have gotten SQL2k5Exp installed. I have update my .net and my XML. I had the server running fine for about a week. The server still 'runs' fine, but when I connect to it with Server managment studio express I can't do anything with it. It will not allow me to expand the 'System Databases' It gives the error: "Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional information: An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsof ...Show All

• Visual Basic Setting MessageBox returnValue to Yes

  I have created a dedicated WebBrowser application that is only used for viewing a program containing dynamic web pages that runs on my computer. Some of the web pages in the program utilize activeX controls so when I open up a page containing activeX controls in my dedicated WebBrowser application I get the following warning message box. An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction I click the “Yes” button and all is well. It is just that the repetition is annoying. If I set the “ScriptErrorsSuppressed” property of WebBrowser control to True, I don’t get the warning message boxes, but the activeX controls don’t work either. Is ...Show All

• Windows Forms delete from datagridview

  I am using a datagridview to display records from a database. After clicking the delete and save button on the binding navigator I receive the following error: Command text was not set for the command object. There is no command text in my table adapter. I have done this many times in my application and have not had to manually create this. Why am I having to create it now, and how do I create it The only time I have seen this error in the past is when I didn't have a primary key set. Mark Can someone tell me how to do the following: 1. Load data from an access database and display it in a datagridview 2. Allow the user to select a row of data and delete the selected row. Thanks, Mark ...Show All

• SQL Server How to Export to Excel without hyperlinks

  How to export a report with hyperliks to a excel file with these hyperlinks removed Thanks in advace for any help ...Show All

• .NET Development Fill DataSet from Txt, memory doesn't like it

  Hi all, This is my first question. Perhaps anyone can help me with what I'm doing wrong and what I can do about it. I am reading a textfile row-by-row, modelling and analyzing the data. Each row is then put in a DataSet. Afterwards, we will bind the DataSet to a DataGrid and allow the user to view/edit records before it is finally published to a SQL database. Sometimes the amount of records is substantial, so to display the status and keep the GUI responsive this process has been contained in a backgroundworker. Ofcourse not with every processed row the status is updated, but in batches. Say about every time 100 records are processed. All works perfectly fine, with the horrible exception that reading large sourcefiles (+1million rows/200mb ...Show All