Cla82's Q&A profile

• SQL Server What is the best most efficient performant way to do a Control break in SSIS?

  I have an EDI file with Different Transaction types. I would like to read for a Header, capture some specific info on the header, and read for another specific tran type that comes after and capture additional info. I have a couple of ideas like tagging the records with a key and loading into two temp tables for matching later but that means I would have to do double processing. Maybe a conditional split for the two transaction types and then unioning them downstream, but not sure if the right records would be associated. Possibly tagging sequential key and writng to raw files and matching on the raw file keys downstream. I have a lot of ideas but I am looking for the best proven practice here so i don't spin my wheels or have to g ...Show All

• Visual Basic populating an Access database using visual basic 2005

  I am trying to create a new employee application that gets input from a user in text boxes and then take that information and populate a database in Access that will later be pulled to the Track IT! database on SQLserver2005. How do i do it Thank you. IGiberson wrote: Also, it is a 3 form application... with different information on all forms... would it be easier to populate the database each time they go through the form or should i just have it get all the info at the end and populate it then it depends entirely on the database and how you want the application to run/how it should run. If the forms are for 3 different tables then I would do the operations on the table on each form, ...Show All

• .NET Development How can i change ConnectionString at runtime in Data Access Application Block?

  Hello, I used Enterprise Library 2.0 in my application. i want to know that is it possible to change ConnectionString at runtime if we are used Data Access Application Block. Well i have company list in my application and on that based i have to change database name in ConnectinString on selected company name. If these are all different databases within the same SQL Server instance, consider using: DbConnection.ChangeDatabase( string databaseName ) Look up this link in your local MSDN installation: ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref4/html/M_System_Data_Common_DbConnection_ChangeDatabase_1_16219e3a.htm ...Show All

• Visual C# Environment settings sharing between users ?

  Hi, Sometimes I need to run vs 2005 in different user accounts (admin and limited), but I want to have 'single' ide. So I pointed the same settings file for both users. When I run ide, after it was run as different user, it tells me that is configuring settings for the first time, but actually it loads right settings not default ones.( if I add some button runing as user1 and open vs as user2 after that - the button is visible, so my gues is that everythig  works ok  ) Can I use this config Won't break in future How about settings file compatibility for example between vs 2005 C++ express and vs 2005 pro thanks Vilius Well, this wasn't a designed feature, but after thi ...Show All

• Visual Studio Com Add-in Stops firing my custom events after displaying a C# Winform

  I'm using VB 2005 to develop a Visual Studio add-in for Office 2003 I have looped through all the menu items and toll bacr buttons and added my own event to each of the commandbarbutton types using the standard C# += methodology. My routine simply displays a new winform as a dialog asking for a password, and if the user enters an invalid password, then the CancelDefault value is set to true, and the underlying default event isn't fired. This works great to begin with. After 10 times, my custom event is no longer being fired. Also, if I set CancelDefault = false, and let the underlying event fire, and again, after (6 times this time), my custom event stop firing. Any ideas Hi, ...Show All

• Software Development for Windows Vista HandleExternalEventActivity - XAML only

  Hi, I am writing a xaml only workflow. xaml file looks like this: <ns0:SampleWorkflow x:Name="SampleWorkflow1" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/workflow " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xmlns:ns0="clr-namespace:CustomActivityBinding;Assembly=CustomActivity, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"> <ns0:CustomActivity1 x:Name="print1" NameToPrint="{ActivityBind Name=SampleWorkflow1, Path=NameToPrint}" /> <ns0:CustomActivity2 x:Name="print2" NameToPrint="{ActivityBind Name=print1, Path=NameToPrint}" /> <HandleExternalEventActivity x:Name= "ChildWFCompleted" EventN ...Show All

• Visual Basic How Can i Make my Own web borswer

  Hey i Need heplp so far i've got a window with back, forward, refresh, stop and a url box and go with a webbroswer below i would like ot be able to get this to work heres the code below so far. [code] Public Class H2FWebBrowser Private Sub cmdGo_Click() wb.Navigate(txtURL.Text) 'make the webbrowser navigate to whatever is in txtURL End Sub Private Sub WebBrowser1_DocumentCompleted( ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles wb.DocumentCompleted End Sub Private Sub cmdGo_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdGo.Click End Sub Private Sub cmdStop_Click() w ...Show All

• Visual Basic Is this just a minor bug with VB.Net 2005 IDE and nothing to be concerned about?

  or is this something to be concerned about If I open a form in design view and place a button on the form and then double-click on the button, the IDE will generate a subroutine for a click event. It looks like: Private Sub cmbDelete_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbDelete.Click End Sub If I put a button on a form and then go into view code, select the button from the pull down on the left - the objects - and then in the right drop down I select the event method "CLICK" the IDE will generate Private Sub cmbDelete_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles cmbDelete.Click End Sub The difference is the ...Show All

• Visual Studio Express Editions Cant display forms 2..3..4..

  I Got a problem.. i got a program that needs 3 or even 4 forms ..but the problem is i cannot display higher then form2 enve if i try in form1 Form3 NewForm3 = New Form3(); NewForm3.Show(); or any other ..even the aboutbox...nothing..but if i try do that in the 2nd form..i can display form3 from from there..but not from form1...how come and how i fix this.. ShadowRayz well it was hard seeing how you declared it in the original screenshot but the compiler said that "form3" does not exist but if you did " F orm3" then it would work. So if you go back to say...Form2 as in your original screen shot and typed in: Form3 theOtherForm = new Form3(); th ...Show All

• SQL Server insert into a table by openXml and variable

  I have a table that should be filled by a stored procedure. Some of its columns are filled by xml data file and a column (ExGroup ) by a value. I’ve used OpenXml method for it but I don’t know how to define data of Exgroup by @exgroup value. My query is this:     set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go         ALTER   PROCEDURE [dbo] . [sp0] (             @strXML ntext , @exgroup int ) AS Declare @intPointer int exec sp_xml_preparedocument @intPointer output , @strXML Insert into Symbols_Stage ( symbol , longname , shortname , Exchange , ExGroup ) Select * from OpenXml ...Show All

• SQL Server Replicating partial database

  Replicating partial database Hi there, actually I have a set of tables from my database model on SQL SERVER 2005 that I want to replicate (using merge replication) to a different server with SQL SERVER 2005 EXPRESS, Everything seems to be ok until I try so replicate just a portion of my model. I’ve got some parent tables to replicate but I’m not going to replicate some of their children, when I try to move them (just the parents and SOME children) to the other server using subscription, I have to erase some foreign keys (the children’s foreign keys I wasn’t supposed to migrate) in the target server to get my database migrated. What Can I do to solve this problem ...Show All

• Windows Forms datagrid troubles with stored procedure (vs 2003)

  I have the following code: Dim daGrid1 As New SqlDataAdapter(Me.SqlCommand1) (a stored proc) Dim dsGrid1 As New DataSet dsGrid1.Clear() daGrid1.Fill(dsGrid1, "top") DataGrid1.DataSource = dsGrid1.Tables("top").DefaultView I set the command to a stored proce and fill a dataset, then set the datagrid1 to the dataset table. I can then see the data grid on the form filled out. I need to change the column headings, hide some columns, then click on a row, and get the hidden field and pass it on to another form. I thought I would need a table style for that. But when I try to add one, I get: "The data grid table styles collection already contains a table style with the same mapping name." ...Show All

• Visual Studio I need help with installing SQL Server 2005 Express

  Dear MSDN, I'm having a problem with installing SQL Server 2005 Express. In the past, I installed Visual Studio 2005 Beta (with SQL Server 2005 on it) and it runs fine. But I made a mistake uninstalling the beta version. I used the Control Panel and uninstalled the components in random order. When I installed the Express Edition, SQL Server 2005 Express failed to install, but Visual Studio 2005 Express is running fine w/o SQL Server on it. I need to install SQL Server 2005. Please help me how to fix this. Thanks. Hi, sory for the late reply. I uninstalled the VS 2005 express edition then i used the clean-up tool to remove the remaining beta components, but the tool also failed to clean ...Show All

• Visual C# vjslib and other unwanted assembly references in web.config

  Hi all, I apologize if this is not the proper forum. I have a big solution containing a couple of class libraries and a web site (project type: file system based asp.net web site). Every time I build the web site, the following assemblies are added to the web.config: <add assembly="vjslib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03 ...Show All

• Software Development for Windows Vista 16-bit DLLs and Vista

  Everytime I see information on what doesn't work in Vista, the 16-bit support issue always comes up w/ respect to the 64-bit version of Vista. However, earlier tech issues never mentioned 64-bit Vista and 16-bit apps/dlls in the same breath and 32 bit Vista was unheard of... So...are 16 bit apps/dlls compatible w/ 32 bit Vista If not, where can I find that info If so, do I have to change settings in Vista to make them work Are there side-effects that I need to know about 32 bit Windows Vista still contains the 16 bit emulator. Your 16 bit applications should work as it did in earlier releases of Windows. 64 bit Windows Anything does not support 16 bit emulation. ...Show All