Greg Van Mullem's Q&A profile

• SQL Server Using object variable as data source?

  Hi! These problem does't look like a problem, but i am not able to solve it... I have a stored procedure (in an Execute SQL-Task) what returns a few rows. These rows a written in an object variable. No problem. Now i want to use these result set in a dataflow as source. How can i manage these 1. Use a script task what returns the whole result set from the object variable How 2. Is there any other possibility to use the results of a stored procedure in the data flow All ideas are urgently welcome... Torsten The script tasks need to reference strongly named assemblies. My conjecture, based on that error message, is that your system may have different culture setting on the installed Sys ...Show All

• Visual Studio Express Editions Adding image to project resources crashes IDE and corrupts project

  I have this really annoying problem, and can't find any information on it anywhere. When I add an image to the project resources file, VCE crashes, and after restarting, I can't save any files or even exit the application without it crashing. When I try to exit, it prompts me to save the .sln file, and then crashes. This is what I did to cause the problem: 1. Select BackgroundImage in the properties of a windows form control, and click the '...' button to add an image. 2. Select "Project resource file". 3. Click the Import button. Select a file. Mine was called builder-bg.png and was 1kB in size. 4. Click OK. 5. Then control is returned to the designer, and after a few seconds the application crashes. Restart VCE go to the projec ...Show All

• SQL Server Regular Expressions in SQL 2005 using C#

  Hi all, i wrote a little function that is basically supposed to give me a match of a regular expression in C#. i tested it out in VS05 and it seems to work fine. It hits the fan when i try it on SQL Query analyzer once deployed. Anyone have any idea why here is the C# class that I deploy to a db using VS05. using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using System.Text.RegularExpressions; public partial class RegExTest { [Microsoft.SqlServer.Server. SqlFunction (IsDeterministic = true , IsPrecise = true )] public static string RegExMatch( string pattern, string matchString) { Regex r1 = ...Show All

• Visual Basic Reading formulas from excel using VB

  Hi, i want to read formulas written in cells of excel worksheets using VBscript. i am able to read all the values of each cells, and calculated values of the formulas in the cell but not the formula. can any one help me out in this regard. vikas ...Show All

• Visual Basic Two questions about VB2005...

  I have two questions about VB 2005. I am using the Express version, but I don't think that matters. First, I develop some PHP/Perl stuff with Komodo, and there is a feature where vertical lines help line up blocks ("If...Then", etc). Is there a feature like this in VB 2005 Also, is there a way to customize the webpage that "ClickOnce" creates Thanks in advance. goodrichroad, 1. I don't think there is a feature in VB 2005 Express as you described. Please open the following link and try to download the PHP develop tool for Visual Studio 2005, then you can have a try to code in this extension. http://www.jcxsoftware.com/vs.php 2. If the project is related to the Web application ...Show All

• Windows Forms Referenced Project controls not in Toolbox?

  VS 2005 SP1 C# I have a solution with a few projects. The UserControl project's controls don't appear in the projects that reference it. If I choose "Choose Items" they don't appear in the list. If I drag the UserControl project's DLL into a tab on the toolbar all the UserControl project's controls appear nicely. How do I get a referenced project's controls to appear in the Toolbox Thanks, Ian Further, if I add the controls manually to the form.designer.cs file they work great. I just can't get this referenced project's controls to appear in the toolbox. ...Show All

• Software Development for Windows Vista context.CloseActivity()

  hi all, public void OnEvent(object sender, ActivityExecutionStatusChangedEventArgs e) { Debug.Assert(e.ExecutionStatus == ActivityExecutionStatus.Closed); ActivityExecutionContext context = sender as ActivityExecutionContext; ..... if (e.Activity is InfoFinalActivity) { context.CloseActivity(); return; } } cotext have three child context ,and ExecutionStatus of all child activitys in cotext is Closed, but there is a exception when i run the code 'context.CloseActivity();', CompositeActivity cannot transition to 'Closed' status when there are active child context still exist for child activity. please tell me why, many thanks. ...Show All

• Visual C++ How can I use a Timer without having the .NET framework?

  Hi, I have an app that requires a certain function to be called every X milisseconds. I have searched for timers on MSDN, but the ones I've found are all based on the .NET framework. Is there any other way I would rather use only native Windows API. Thanks in advance, Pedro d'Aquino ...Show All

• Visual Studio Team System Get specific version tells me file is being used by another process

  Sometimes when I select a folder and run the get specific version (I choose latest and check both boxes to force get), TFS will show a message box telling me that some file could not be processed because it was being used by another process. I am assuming this is because another user is either checking a file out or in or is also pulling the latest version. That is, TFS is the "other process". Why doesn't TFS simply retry pulling the file or files instead of waiting until I come back to the office to push the freaking button so the fetch will finish Then to get the file, of course I have to do a get again. Is this a bug or a feature Sometimes I see that the file in the message box has "Latest" marked as "y ...Show All

• Visual C# System.Diagnostic.Process.GetProcesses()

  Hello, I have a quick question about the process array being returned from the GetProcesses(). Specifically, why does the process array contain an entry for explorer.exe but I can not get the title of any of any explorer windows open. For example, I have 3 explorer windows open each viewing a different directory. But, none of them show up when I bind my list of a grid control. So, do I need to ignore what I get from the GetProcesses() call and just enumerate all top-level windows that are visible Is there another technique that would allow me to continue to use the Process[] without having to resort to interop Thanks for your time/help! .jdt. AFAIK ...Show All

• Visual Studio Team System Cannot pass a GCHandle across AppDomains using unit testing.

  Got a manage C++ class in a class library that uses unmanaged C++ lib. The managed C++ class handles callbacks from the unmanage C++ lib by a delegate "gcroot<MessageDelegate^> m_MessageDelegate". To invoke the delegate I use the call "m_MessageDelegate->Invoke(nMsgId);". This works without any problem when running applications using this class library but when testing the class library using unit testing I got the error "Cannot pass a GCHandle across AppDomains" when I invoke the delegate. When running Unit Tests by default we create an App Domain per test assembly. It seems that MC++ has its own app domain for unmanaged code and gcroot does not allow marshaling across app domains. To walk aro ...Show All

• Windows Forms Databind one control to another

  Not sure if I can/should do this, but basically I wanted to bind the "checked" property of a checkbox to the visible property of a text box. I used the following statement txtOilQty.DataBindings.Add( "Visible" , chkOilAdded, "Checked" ) It seems to work just fine as long as I don't have the initial value of visible set to "false" in the visual studio designer. If the initial value is false, then checking/unchecking the checkbox has no effect on the visible property of the checkbox. Is this by design Am I not supposed to be able to do this Thanks I can't see anything wrong with using databinding in this way. I tried your example and noticed the ...Show All

• .NET Development Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

  I'm having issues figuring out how to get my application set up properly so it will authentiate correctly. I need to be able to use windows authentication (all access is internal to the domain) so that the user's credentials will be used to access an external resource. I've looked at the dcomcnfg but am now sure what needs the access updated. The com object that I"m attempting to use isn't listed there so I'm guessing there is something else I need to update. The server is Win2k3. Here's the error from the event viewer and the error from the page: Event code: 4011 Event message: An unhandled access exception has occurred. Event time: 12/19/2006 11:58:15 AM Event time (UTC): 12/19/2006 5:58:15 PM Event ID: fa2e0deea3 ...Show All

• Visual Basic Outlook View Control

  Hi, I am using the Outlook View Control and want to enable the user to select the folder that is being displayed by the control himself. At the moment the inbox folder is displayed by default, but the user must choose whether he wants to display the contents of the subfolders wihtin the inbox or any other folder (ie the Calendar). Any suggestions You can use the Folder property to tell the View Control which folder to display. For example, to see the calendar you can type: Me .AxViewCtl1.Folder = "Calendar" Or to see something under Inbox you could use: Me .AxViewCtl1.Folder = "Inbox\EmailsFromBob" You can use Outlook's Object model to enumerate the folders that are ...Show All

• SQL Server INSERT INTO table From EXEC -

  Hello, How can I insert values from a query directly to a table in my database the query gets values from a linked server and i want to directly insert the results in my local database. This is how i thought would be done: CREATE PROCEDURE dbo.SP_INSERTfromEXEC AS BEGIN INSERT INTO dbo.mytable EXEC dbo.QuerytoLinkedServer END When i execute dboSP_INSERTfromEXEC procedure, then i get this error: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "blahblah" was unable to begin a distributed transaction. Now, when I execute dbo.QuerytoLinkedServer procedure, i do get the values, there is no error. It just doesn't want to insert it I suppose. Any help would be greatly appreciated! ...Show All