subink's Q&A profile

• SQL Server How to use FlatFileSourceErrorOutputColumn

  I am testing the functionality of XMLTextWriter in regard to handling errors.  The scenario is that I have a text file with some bad data.  I wrote a script component to take any rows containing bad data and write them out to an XML file.  Here is the entire script: Imports System Imports System.Data Imports System.Math Imports System.Xml Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Dim xWriter As XmlTextWriter Public Overrides Sub PreExecute() xWriter = New XmlTextWriter( Me .Connection ...Show All

• Windows Forms “Verified by Provider” security tool

  I am posting this here because one of my wishes that I posted here a year a go will become true in Longhorn, so maybe this wish will come true too  :)   ------------- I wish if there was a magic tool that will scan all executable files in my computer, and tell me if any of those files is up-to-date and it is really from th ...Show All

• Visual C# Reading A File...

  I have created a form with a menu, which contains the menuitem 'Open'. What I want to happen is that when the user selects the 'Open' menuitem, the user is able to specify a file to open. Note: The file just contains the following text: "1,2,3". I will then want to read the text from the file and modify it. I'm not too sure how to go about doing this. Any help is appreciated. Thanks, Create an instance of the Open File Dialog and fill the properties. Then show the Dialog. OpenFileDialog openFiles = new OpenFileDialog ( ); openFiles . InitialDirectory = "C:\Temp\&q ...Show All

• Visual Studio Team System Product Studio

  Is Product Studio available at this time as a standalone app   If so, where would I be able to get that Thanks! I see.  The backend server for the work item tracking is SQL Server 2005.  Right now, there's no way to install one piece (work item tracking) without another (source control, for example).  You would need to install the server including SQL Server 2005 even if you could actually install them separately. The best thing to do at this point would be install it all on one or two machines that are isolated from the rest of your environment. Buck ...Show All

• Visual C# C# Parameter not passed to Web Service

  In a revision of the Distributed Application Walkthrough located here: http://msdn2.microsoft.com/en-us/library/1as0t7ff.aspx , we have changed the WinForms app portion of the walkthrough the use the designer tools in VS2005 instead of a manual placement of the datagridview control and the Load/Save buttons. When we use the VS2005 designer tools to drag and drop from the DataSources window after adding a Web Reference to the project, everything appears to work fine. The Datagridview populates beautifully with the following code in the form class code: public Form1() { InitializeComponent(); localhost. Service ws = new localhost. S ...Show All

• .NET Development Problem publishing project with ClikOnce

  I had a project written in VS 2003 (framework 1.1). I converted the project to VS 2005 and tryed to publish it. For some reason I get this error: Could not find file 'Microsoft.Windows.Common-Controls, Version=6.0.0.0, Culture=*, PublicKeyToken=6595b64144ccf1df, ProcessorArchitecture=X86, Type=win32' Does anyone know why this happens Miha i had the same problem. deleted manifest file from project and rebuilt - success.! ...Show All

• Smart Device Development Read specific line from a file?

  Hi, Is there a method to read a specific line of a text file The StreamReader class does not seem to have a method to do so. The Peek method isn't what I'm looking for either. Would appreciate your help. Thanks. Will threading help If you know in advance what is the file to be processed, you can start a thread to index it first. I did a simple test program, and indeed, with indexing, reading any line is extremely fast. In my program, if the user wants to read a line that has been indexed, the result is displayed immediately, otherwise, a timer is started to repeatedly check if the line has been indexed. Here ...Show All

• Visual Studio 2008 (Pre-release) When WCF release will be avaible?

  Hi, I have a project using WCF that should be finished in october. Will WCF be released at this time Thanks, Remi Is there any roadmap for future CTP drops We're currently using the Jan. CTP build, and avoided moving to the Feb. build so we won't have to constantly be fixing breaking changes with each CTP build. We want to move slowly, every 2 or 3 CTP drops. The more time passes, the more we feel we're wasting time by using outdated interfaces but we also feel moving to the Feb. bits is counter-productive with a future drop just around the corner. Couldn't find any such roadmap on www ...Show All

• Visual C++ C++/CLI Syntax Change in Beta 2?

  Hi KluchDev! In Beta 1, a programmer could use the "bool System::Array::Contains(Object ^o)" method in order to determine if an array contained an instance of an Object.  It seems as if this method has been hidden in Beta 2.  What would be the preferred mechanism to replace this functionality in Beta 2 e.g.  // This compiles in Beta 1, but not in Beta 2.  array<String^> ^stringArray;  ....  if (stringArray->Contains("Test")) { ... } This was a "bug" in Beta1... You can use System::Array<>::IndexOf -- Greetings Jochen Kalmbach ...Show All

• Smart Device Development DG CurrentCell.ColumnNumber - HELP!!

  I have a windows (specifically mobile) datagrid - I am trying to force/set the CurrentCell.ColumnNumber to 0 but when I do, I get the following: "NullReferenceException Was Handled" This is the code that works but not what I need: grid[currentCell.RowNumber, currentCell.ColumnNumber] = txtEdit.Text; This is really what I want but throws the error: grid[currentCell.RowNumber, 0] = txtEdit.Text; Iyla - thanks, I will give that a try - also, I think that I fugured my original post out - I was trying to set the currentcell.column to 0 when I really needed to set it to 1- I thought that cells/col ...Show All

• SQL Server Extracting month, day, year from dates

  I need help in building a Select statement for an ODBC connection to an AS400 DB2 system. I am using this Select statement for SQL Reporting Services. Unfortunately 15 years ago one of the main datatables on the AS400 was set up splitting the transaction date into THREE FIELDS! One for Month, one for Day and then one for Year. I need to take yesterday's date and somehow use this in my WHERE statement to connect the transaction records that are in this AS400 table. This is what I have now that is not working: WHERE QS36F.BRDMST."BREED#" = QS36F.DOGOWNR.BRDCOD AND (QS36F.DOGOWNR.TMONTH = "MONTH"(GETDATE() ) AND ( ...Show All

• SQL Server Variables Window

  Hello All, I am wondering if someone can shed some light on how to display "Variables" window in Integration Services. I am trying to add a new variable by clicking SSIS menu, and choosing Variables. However, the Variables window never showed up. Is there some property settings that I need to set before I could view the Variables window Your help is much appreciated! -Lawrence Thanks Michael! It resolved my issue. Thanks again. -Lawrence ...Show All

• Visual Studio Team System TFS in different AD domain than the users are in

  Hi, I have a Team Foundation Server in domain A. The users that should be able to use the server are in domain B. There's no trust between the domains. The trust would probably solve the issues but it is out of my hands. First I am not able to create new project from the domain B. The creation stops with the error saying: Unable to connect to the specified SQL Server Reporting Services at <server>. From what I understand from the iis logs it seems that the client( ) is not passing the credentials when using reporting services web service. I am able to open existing project from the domain B with Team Foundation Client using th ...Show All

• Visual Basic How do I use dot net controls in visual basic application.

  I have a legacy application that is being installed at various locations. I want to enhance the application and want to use some dot net (2.0) controls. How do I achieve this Would appreciate any suggestion. Thanks You cannot use .NET 2.0 controls in VB6. As was stated previously to use .NET 2.0 controls you need to be rewrite you VB6 application using VB Express/2005 to be using these control. ...Show All

• Visual Studio Team System User Permissions - open and close work Items

  Hi Is there a method where I can restrict some user(s)/group(s) to - add new work items - edit work item status from "active" to "closed (restrict only the "Created by" user and the "testers" to close the work items) Thanks You can restrict write permissions by placing users in the appropriate security groups (on a project level) or by further restricting access within area classifications (right click on the project in Team Explorer, choose Team Project Settings, and then Groups Membership or Areas and Iterations). You can restrict which users can perform work item state transition ...Show All