Jim Kansela's Q&A profile

• Visual Studio Team System TFS - periodic automatic builds if a check in has been made

  Hi, Yesterday I set up my TFS system so that it does periodic 15 minute builds of all the team projects contained within TFSource Control. However it seems a waste of resources to be building all my files every 15 minutes and sending out alerts to the appropriate people when theres a good chance that nothing has been changed within the past 15 minutes. I'm wondering if anyone knows of a way to build at the automatic 15 minute stage only if a change has been made to the source repository Cheers, smudie Hi, I'm now taking a new approach. Instead of Windows Task Scheduler pointing to a batch file it will point to a C# program. This C# program will contain code that can create and run batch files. ...Show All

• Microsoft ISV Community Center Forums Save Workbook code works fine in Win2000, however given an error in XP

  Wrote a script in VBA (Excel) that builds a workbook based on a list of names. When the script arives at a new name then it saves a copy of a template file using the name in the column. When I run it on Win2000 it works just fine, however when I run it on XP then it produces an error when it reaches this code . newWB.SaveAs ("G:\NSS Bus Ops\Patrick S\Daily Report Dump\" & sName & "_" & Right(Workbooks(abName).Sheets(1).Cells(i, 3), 4) & Left(Workbooks(abName).Sheets(1).Cells(i, 3), 2) & Mid(Workbooks(abName).Sheets(1).Cells(i, 3), 4, 2) & ".xls") Any thoughts as to why this might have happened. The Win2000 & XP machines are running Office 2003 service pack 2. Thanks f ...Show All

• .NET Development String encoding issues for a web service

  Hi, I am consuming a web service that needs text to be in the exact format below. When I try and hardcode a string to test the service C# .NET 1.1 escapes the " to look like this \". The webservice does not like this. SHOULD BE: <ROOT FunctionName="GetMapByAddress" ><PARMS Address="123 DALTON DR NW"/></ROOT> IS: <ROOT FunctionName=\"GetMapByAddress\" ><PARMS Address=\"123 DALTON DR NW\"/></ROOT> The Code: string s = @"<ROOT FunctionName=""GetMapByAddress"" ><PARMS Address=""5828 DALTON DR NW""/></ROOT>"; Is there an ...Show All

• Visual Basic Switching Keyboard Keys

  Hello, Using Visual Basic 2005 EE I am looking to globally switch keyboard keys when the user clicks a button, what I mean is changing the A to an E. Can this be done And in VB05EE Thanks for any replies. Dim ChangeKeys As Boolean = False Private Sub Form1_KeyPress ( ByVal sender As Object , ByVal e As System . Windows . Forms . KeyPressEventArgs ) Handles Me . KeyPress If ChangeKeys Then If e . KeyChar = "A" Then e . KeyChar = CChar ( "E" ) End If End If End Sub Private Sub Form1_Load ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Me . Load Me . KeyPrev ...Show All

• .NET Development Save SQL dataset to Access database

  I have a dataset populated with data I've queried from a SQL Server database. I have an access database file with exactly the same tables as the SQL Server database. I know how to connect to the access DB, and create a data adapter, etc., but am unsure as to how to add the data from the dataset generated from SQL Server and save it into the access database. Do I have to loop through all of the rows from the SQL dataset and add the data to the access db one row at a time Actually no. I want to be able to invoke this from an ASP.NET web page. I've figured out how to pass the dataset to the OLEDB provider, but am having problems saving the data to the access file. I have an mdb file with the proper tables, b ...Show All

• Windows Forms How To: Implement Single click navigation to a DataGridView Combo Box Cell

  I have a data grid view bound to a data view, with a combo box bound to another data view. The user's are complaining that they have to click twice on the combo box drop down arrow to get the drop down list to appear -- what's happening as near as I can tell is that the first click selects the row, and the second click is delivered to the combo box. Is it possible to modify this behavior so that a single click both selects the row and drops down the combo box I suspect this is not as simple as overriding WndProc in the DataGridView and passing the WM_CLICK message to the combo box :-) Thanks in Advance Alan The first thing that came up to me is: Private Sub DataGridView_CellEnter( ... ) Handles DataGridView. ...Show All

• SQL Server stuck from the start on custom component

  Imports System Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace SSISComp <DtsPipelineComponent()> _ Public Class UpperCase Inherits PipelineComponent End Class End Namespace The above is fine, i.e. at least i get no IDE complaints. But, as soon as i try to make the attribute even remotely useful, i get Mr Squiggly and he no wanna go away. (and most of this is pulled from samples so I must be missing someyhing embarrasingly obvious: This one will get you DisplayName is not declared Namespace SSISComp <DtsPipelineComponent( DisplayName = "Hello")> _ Public Class UpperCa ...Show All

• .NET Development ArrayList problem/question!

  Hi! I have a problem with the ArrayList because it only supports one string at a time. For example, I have to put a title and link in an arraylist, but cant do it cause then ill need two arraylists - one with the titles and one with the links. I would like the two strings in one arraylist. So then I just get the title and link using a foreach statement instead of going into two arraylists (which wont be accurate) Matt Just create a new object that will contain all that you need and place it into the arraylist. For example I will use the typesafe generic list, the cousin of ArrayList, but the concepts are the same. I will create a struct to hold the info: using System.Collections.Generic; ... p ...Show All

• SQL Server Quick SQL Question?

  Hi Everyone: I am trying to create the following SP, but get an Error stating "Must Declare the scalar variable "@LoanApplicationID" eventhough I think I am declaring it. I am not sure what am I doing incorrect here, but a prompt solution would be appreciated. Thanks. Here is the code: CREATE PROCEDURE [LAFProcess] . [uspUpdateProcessList] AS DECLARE @LoanApplicationID int SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ COMMITTED SET @LoanApplicationID = ( SELECT TOP 1 LoanApplicationID FROM LAFPRocess . WorkList WHERE Status = 2 ) INSERT INTO LAFProcess . ProcessList ( WorkListID , CreatedOn , ProcessStartedOn , Status ) SELECT TOP 1 WorkListID ...Show All

• Visual C# Little Help

  I have figured out how to open webpages, but, if on the button click you open a webpage, say www.google.com. But, if you have a textbot on the program, and on the button click you want www.google.com/i-typed-this-in-the-textbot, how would you go about coding that Thanks I get errors with that. Error    1    'Thottbot.Form1' does not contain a definition for 'theTextBox'    C:\Documents and Settings\Justin\My Documents\Visual Studio 2005\Projects\Thottbot\Thottbot\Form1.cs    40    22    Thottbot Error    2    'Thottbot.Form1' does not contain a definition for 'theButton'    ...Show All

• Software Development for Windows Vista UnloadOnIdle Memory Leak???

  In the ASP.NET WF application we've written, we're utilizing the SqlWorfklowPersistenceService, SharedConnectionWorkflowCommitBatchService and a custom ExternalDataExchangeService. Our persistence service is configured as follows: < add type="System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" EnableRetries="true" UnloadOnIdle="true" LoadIntervalSeconds="10" /> Our problem is that over the span of a day or so, the application consumes more and more memory until eventually (once it's reached several hundred MB) it causes performance issues on our servers (excessive paging, etc.). As I began to investigate the issue ...Show All

• Visual Studio Express Editions font install

  hi I use a special font in my app with textbox and drawstring methods. How can I install this font with the apllication i tried to copy the fontfile to windows\fonts folder but even on restart the font does not show up until I manually open the fonts folder and click on the font (Edited Reply) Experts, is there a way to shorten this code Imports System.Drawing Imports System.Runtime.InteropServices Public Class Form1 Public privateFontCollection As New Drawing.Text.PrivateFontCollection Public FamilyName As String Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load ' Name embedded resource fo ...Show All

• Windows Forms Designer Generated Code: SizeF

  What does the 'F' accomplish or stand for in designer generated code for form ' AutoScaleDimensions' this .AutoScaleDimensions = new System.Drawing. SizeF (6F, 13F); Immediately following this code in designer generated code: this .AutoScaleMode = System.Windows.Forms. AutoScaleMode .Font; this .ClientSize = new System.Drawing. Size (292, 262); Why have 'SizeF(6F, 13F)' when the size is explicitly declared as 'Size(292, 262)' The Designer then adds the hidden methods: this .ResumeLayout( false ); this .PerformLayout(); ... attempting to create a new library class. SizeF is based on floating-point width and height parameters. ClientSize and AutoScaleDimensions are two completely different prope ...Show All

• Visual Studio Express Editions Cant compile directx or win32

  Hello, i am posting this because i have been reading a directxtutorial at riemers.net, and i cant proceed because i cant get code to compile. I followed the instructions on how to setup the windows sdk, and everything worked fine. I even got the code from the win32 template to work (when u select new project, win32 console, windows form application) But however, when it comes to compiling my own basic win32 api code, like showing a messagebox, i get annoying errors. This is the project code. #include <windows.h> #include <d3d9.h> #include <d3dx9.h> int int_AppRunning = 1; LRESULT CALLBACK OurWindowProcedure(HWND han_Wind,UINT uint_Message,WPARAM parameter1,LPARAM parameter2) { swit ...Show All

• Software Development for Windows Vista vista blocks application at startup

  Hi, I'm a software developer and I have a question about Vista. Our application (a .NET 1.1 app) requires Administrator access and we have the "requiresAdministrator" access level defined in the application manifest. That part is working fine. However, our application needs to startup when the computer boots so we have it in the "startup" folder. For some reason (I can't imagine why) Vista puts it in the "blocked startup programs" list and the user needs to manually launch it. This is not acceptable for us. Is there any way to circumvent this problem And by the way, why is there no way for the user to say "I want this app to run every time I reboot so stop blocking it!" On a side note, I not ...Show All