Paul Burg's Q&A profile

• SQL Server still struggling with flat file into multiple tables

  So here's the issue 16 flat files all fixed width. Some over 350 columns. Open flat file 1 extract id and go see if its in table 1, if true update table 1 with first 30 columns otherwise insert into table 1 first 30 columns. goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails. How can I pass the id as a param into the update command so it updates where x = 'x' also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop . If you can help great, bu ...Show All

• Windows Forms How do you get the whole error icon to be displayed

  I have a datagridview control that uses the cell validating event to validate the contents of the cell. If the value is invalid, I populate the cell.ErrorText property. Only portion of the icon is displayed. I have tried to change the padding property, but still only get portion of the icon. Any assistance would be appreciated. This is the code of the handling event private void dgv_Allocated_CellValidating( object sender, DataGridViewCellValidatingEventArgs e) { if ( this .dgv_Allocated.Columns[e.ColumnIndex].Name == "StaffLength" ) { DataGridViewCell cell = this .dgv_Allocated.Rows[e.RowIndex].Cells[e.ColumnIndex]; if ( decimal .Remainder( decimal .Parse(e.FormattedValue.ToString()), 5) != ...Show All

• SQL Server Moving data to and from SQL Server 2005, with manipulation in C#

  Hi I am wishing to * take a table of data into a C# CLR procedure and store it in an array * take a second table of data into this procedure row by row, and return a row (into a third table) for each row (and this returned row is based on the data in the array and the data in this row). I am new to CLR programming, and pulling my hair out at the moment. I’m sure that what I’m trying to do is simple, but I am not making any progress with the on-line help and error messages L . I have now described what I am trying to do in more detail, firstly in English, and then in a T-SQL implementation that works (for this simple example). I’m looking for the C# CLR code to be returned – containing preferably two parts: ...Show All

• Visual Studio Team System Un-install TFS

  Hi Guys, When we un-install TFS, shouldn't un-install process remove all application pools created by TFS Thx. Yes it should. By any chance did you assign one of the TFS created AppPools to any other virtual directories (non-TFS ones) .An AppPool can be deleted only after deleting all the virtual directories that use the AppPool. Also can you provide details on which TFS AppPool was not removed Thanks ...Show All

• Visual Studio 2008 (Pre-release) Adding new event handler to custom control does not fire event.

  CustomControl cc = new CustomControl(); cc.MouseDoubleClick += new MouseButtonEventHandler(CustomControl_DoubleClick); private void CustomControl_DoubleClick(object sender, MouseButtonEventArgs args) { MessageBox.Show("Event Fired!"); } Can anyone tell me why this wouldn't work Is there something I have to do in my custom control to get this event to fire Yes, It is being added to a canvas. The Canvas is a custom one that allows dragging any UIElements within it. this .TaskCanvas.Children.Add(CustomControl); ...Show All

• Visual Basic VB computing wrong value during execution

  I am receiving the wrong result when I perform the following computation using VB.NET 2005. MM = CDbl (LoCursr - 1) / CDbl (HiCursr) LoCursr and HiCursr are both dimensioned as Integers and have values of 85 and 87 and are passed into this subroutine as ByRef values. MM is a local variable declared as a double. If I execute this statement in the immediate window, I get the correct result of 0.96551724137931039 However, when this statement executes normally, I receive a result of 0.96551722288131714 which I also get if I execute Cdbl(Csng(84/87)) in the immediate Window. I've tried storing the LowCursr and HiCursor values in Doubles prior to doing the computation, but that did not correct the problem. Is there a se ...Show All

• Visual FoxPro Modal form dilemmas

  Thank you (again) for your timely responses David, I'll focus on #4 a bit (if thats OK)... I've written MyAutoTextListForm that works for MyEditControl (class).  MyAutoTextListForm behaves like VFP-9 Intellisense (a non-modal list-form) in most basic ways.  It also behaves similar to the auto-text (non-modal list-form) property of text-controls.   Perhaps the VFP-9 AutoText property for Text-Controls is not modally affected as it probably works seamlessly with modal forms.   But MyAutoTextListForm is limited by my modal forms (namely mouse clicks).   Through much trial and error I’ve managed some fairly tolerable workarounds where MyEditControl (class) within modal forms can respond well enough with MyA ...Show All

• Visual C# why am i getting this error?!!

  I have an application which monitors a database table and it works fine for more than 48hours sometime but then I will get this error on my desktop.. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject ...Show All

• Visual Studio Vss data store

  When Vss will use sql server like data store I very much doubt if Microsoft have any plans to convert Visual SourceSafe over to using SQL. If you want a Source Code Control system that uses SQl as the data store then Team Foundation Server would seem to be the product you want and not Visual SourceSafe. Of course I'm not a Microsoft employee and I have no special knowledge of their plans for VSS. It is possible they might convert Visual SourceSafe to using SQL. It just seems unlikely (to me anyway) given the recent release of Team Foundation Server. ...Show All

• SQL Server Creating database

  I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this Do i use the sql server management to create it Is there any step by step tutorials How do i connect the database to the web developer   takkyangel wrote: I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this Do i use the sql server management to create it Is there any step by step tutorials How do i connect the database to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Embedding Flash movies in XML Apps

  Hey guys, Just curious, but will there be API's for running flash movies through the XNA libraries I remember reading the 'Hexic' XBLA game was an ebbedded SWF file, and it looks like Castle Crashers uses the same technology...but, will WE be able to use the technology Thanks for any info on the matter. ScottT I should be possible to written a flash player using C#. I would not expect that the XNA framework contain such a pieces of software ready for use. ...Show All

• Visual Studio Post event for the entire build process.

  Hello, I wonder if there is a way to trigger an event after the entire build process If I for example build the whole solution I want to trigger a target or build-script after the entire solution has been built, and if I build 5 of the projects in a solution I just want the target or script to be triggerd after the 5:th project has been built. The only way I can figure out to do this is to add a dummy project to the solution then add it as the last project in the build order and then run a target only for this event, but then I got problems if I do not build the entire solution but only a few of my projects in the solution. Any help is appreciated ;) Thank you in advances! //Martin Hej Martin, are you the guy that posted an edit t ...Show All

• SQL Server SQL Database connection set up in Global.asax.vb for multiple users

  We have an application where users log in and set up a ConnectionString based on the login-info. As to now, we have used Application.Contents("conn") = (strConnectionString) in Global.asax.vb (Application_Start section) and then in the in the webforms we use Dim con As New SqlClient.SqlConnection con = New SqlClient.SqlConnection(Application("conn")) con.Open() ...... ...... con.close() (Each user has their own sql database that they connect to using the same scripts.) The question is: When many users are logged on at the same time, will the use of Application.Contents be a safe way to connect to each users own database or is there a possibility that users suddenly will try to establish a connection to a databa ...Show All

• SQL Server cannnot connect to Analysis Service SQL2005

  hi i have a sql2000 and also have MS AS 2000 where work and all be good. then i install a new 2005 sql , first what i do it run Server Managment studio and try to connect to my analysys server as a result error : Cannot connect to InstanceName A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient) now i download a sp2 .but think it will not help :( sorry for pure English(im fromUkraine ,just a student :) ) all installed on one machine ! maybe it because i use Windows XP , non server Os when i start to install sql 2k5 anlysyis and other main for me components and fetures was disabled, and i can change it . (sql2k5 ...Show All

• Connected Services Framework Service Catalog - Installation issue

  Hi, I had installed CSF 3.0 Dev version except Service catalog component (Since i don't have Platform SDK). Now i installed Platform SDK. I can able to see the following entry in the Add Remove Programs Microsoft Platform SDK (R2) (3790.2075) size 951.00MB Even though, I'm getting "Optional Pre-requistes Platform SDK missing" message when i try to install Service Catalog component. I uninstalled all the components and re-installed. But i couldn't make Service Catalog component is running. I already installed UDDI for CSF 2.5 itself. I didn't change anything for CSF 3.0. 1. What are the possible issues 2. How to verify Service Catalog is successfully installed (Will Virtual Directory be created ) Could any one he ...Show All