ckacey's Q&A profile

• SQL Server MDQ Query Question: Passing sets into a function

  I've created a stored procedure that calculates the "Kendall's Tau" statistic when given a set as input. The result is a single Double value. I have an MDX query that works to return a single value for the set of data for a single sample site. What I want though is a query that will return the Kendall's Tau statistic for the samples from multiple sites. with set [data] as 'nonempty(crossjoin([Site Hierarchy].[Site Hierarc ...Show All

• Smart Device Development Custom Build Rule "works" but makes project undeployable

  I am trying to use a Custom Build Rule to build assembler files, much as described by Jeff Abraham and I am kind of running into the same problem. The rules files only differ on the extension used and some quoting practicalities. I don't agree with Jeff's analysis of what is going on however: An unfortunate side effect of this build rule is that you end up deploying the .obj produced, because it becomes a project output As far as I can see it ...Show All

• .NET Development FAQ: My database isn't being updated, but no errors occurred in my application

  Problem: You have an ADO.NET application that updates, inserts, or deletes data from your database. No errors occur and the data changes are visible in the application, but do not persist between application runs, or if you view the database file outside of the application. Solution: There are two common reasons why this happens: (1) You are calling AcceptChanges on your DataRow/DataTable/DataSet before you call Update on your ...Show All

• Visual Studio VS.NET modifying my custom .csproj changes

  Hi, As part of my build process, I am copying generated classed into my DataAccess project, then trying to build DataAccess.csproj which should include the newly generated classes. I modified the <ItemGroup> to include all .cs files in the directory as follows: <ItemGroup> <Compile Include=".\**\*.cs" /> </ItemGroup> It seems that Visual Studio overrides this change when I reopen the project. It lists a Compile node for ...Show All

• SQL Server Introductory articles on SSIS / DTS

  Hi, I am looking for one or two online articles/documentations that introduces SSIS / DTS to novice, for VS 2005 / SQL 2005.   What can be accomplished with SSIS, and how to get started... David Try this: http://www.sqlservercentral.com/columnists/jthomson/thenewetlparadigm.asp -Jamie ...Show All

• Windows Search Technologies How to kill a process that is not even listed in task manager?

  Hi, I'm having a problem to kill a process. For your information, the process is not even listed in the task manager. I would like to delete that particular file, but it seems like there's a process of software currently associated with that file. When i try to rename, move or delete that file, an error came out saying: "Cannot delete filename: It being used by another person of program. Close any programs that might be using the file and t ...Show All

• Visual Studio Third-Party Charting Products that work with ReportViewer?

  Hi there, Does anyone know of third-party charting products that work with ReportViewer in local processing mode I've looked at Dundas and ChartFX, and I'm waiting to hear back from their sales & support people, but from all outward appearances those two products only work with reports that are generated on a server. Thanks, Eva Pierce Monsen Dundas, ChartFX, etc. are using the CustomReportItem feat ...Show All

• Visual Studio Team System BisSubscribe examples

  Are there any examples for the eventtypes I can subscribe to in the BisSubscribe PowerToy Thanks! ~slee Hi Jeff, I am not able to browse to the URL you suggested. Can you tell me how to use the BuildStatusChangedEvent so that I can send mail when build fails Or else how to use a filter with BuildCompletionEvent to enable mails only when the build fails and not when it succeeds I appreciate your response. ...Show All

• Windows Forms DateTimePicker problem

  Hallo everybody My problem is DateTimePicker.When I "change value", example: From 10(hour):59(min) and Up i'm getting: 10:00 I want my DateTimePicker to increase "hour" value! Example: From 10(hour):59(min) and Up 11:00 What seems to be a problem Any idea how to "work" around this problem Regerads Gamb Do you change the value by hand or in code If in code, then you may tr ...Show All

• Windows Forms How to change disabled textbox fonts color ?

  When the textbox1.enabled = false, the fonts color changed to gray.  Is it possible to change the fonts color to black color when it is disabled Thanks, Terrence You are correct, combobox does not provide a ReadOnly property...  I believe&n ...Show All

• SQL Server SQL Network Interfaces, error: 26 - Error

  I have SQL 2005 standard edition (64) installed on Win 2003 (x64) as the database server. (dbserver machine) Despite setting up: Remote option under surface configurator, TCP settings under configuration wizard, No firewall, I am still getting the same message when I try to connect from the application server using the SQL manager. I can connect to the server on the dbserver machine but not remotely. I have read through the thr ...Show All

• Visual Studio 2008 (Pre-release) Loading Images from Resource File

  Hi, How do you load an Bitmap object in an Image For example, Images saved as resources are saved as Bitmap objects, I can't find any method of converting the Bitmap to anything that acceptable so that the Image control can load it. Please can anyone help, thanks Jaco System.Windows.Interop.Imaging.CreateBitmapSourceFromHBitmap I think this is what you looking for ...Show All

• Visual Basic Business Inteligence Projects under VS 2005 Professional

  Hi all, I've got VS 2005 Professional on my XP development desktop. I've installed SQL Server 2005 on my development W2003 server. I see I can now create "Business Inteligence" projects in Visual Studio on the SQL Server machine but not on the development XP machine. What do I need to install on the XP development machine to be able to create BI projects also Thanks, ST ...Show All

• Visual Studio Express Editions Is The OOP Microsoft.VisualBasic.IIf Equivalent To the Procedural If Then?

  so I guess the thread was locked due to thinskinned vb'ers, unfortunately bronco has a fantastic question in his last post and it certainly warrants discussion. . . This Particular Microsoft.VisualBasic.IIf Is extremely important to me.... If Microsoft.VisualBasic.IIf is Equivalent to the Procedural "Classic" If then.... If it is Equivalent I can Transist to Pure OOP by using Descision Tables, Boolean Algebra and other CS tec ...Show All

• .NET Development Type.GetMethod is incredibly slower in .Net 2.0

  My application uses scripts that are user provided and generated at run-time. These text scripts and appended into a class, compiled with a code provider and then invoked by reflection. This works great with .Net 1.1 but with .Net 2.0 the Type.GetMethod used to aquire a MethodInfo for invoking a script is performing significantly worse. What takes 0.3 seconds in 1.1 takes 20 seconds in 2.0. This is quite unwanted. Why is this and is there a bett ...Show All