Mickey Haynes's Q&A profile

• SQL Server query on sysprocesses...

  I was trying to findout processes which are running for long time and came across few entries in sysprocess where Last_Batch column shows '01/01/1900' It is a usual practice for SQL coders to put a default date like this if they don't have a valid date, does sysprocesses table does the same thing No, this is not the way I would have done it. This is a token date, which more or less means the engine is sa ...Show All

• Windows Forms Docking Windows in .NET

  I would like the Visual Studio .NET like docking windows in my application. These docking windows has their own title bar, close button and also can be docked. Please help me to find out how to create these. Is there any controls out there  ...Show All

• Visual C# Typedef-equivalent in C#?

  I pass integer IDs to a variety of functions. I want to create a type for each ID so the compiler can check I am passing the right type. In C I would do this with typedefs. E.g.: typedef int personID; typedef int addressID; void DoSomething(personID p, addressID a) { ... } How can I do this in C# Creating an entire class seems like a lot of overhead. Truthfully, wrapping primitive types just to reimp ...Show All

• Windows Forms OpenFileDialog "hangs" on Windows 2000

  I have a WinForms remoted application using a simple OpenFileDialog control.  When I instantiate the dialog, the program hangs and never responds.  This only happens on Windows 2000.  The program functions perfectly on Win XP & Win 98.  The ...Show All

• Software Development for Windows Vista Add Graphic User Interface to custom Activities

  Is possible to create a custom activity and include some GUI, so when that custom activity is used in a workflow the user would be able to double click the custom activity and set properties If so, where can I read some documentation about it. I think that, maybe, I need to override some method but I can't figure it out what method. Thanks in advance. Can this custom activity designer also be set up to be a drop ...Show All

• Visual Studio VSS 6 & VS 2005 Standard

  Can I integrate Visual SourceSafe 6 with VS 2005 standard If so, how Thanks Answering my own question: All I had to do was upgrade my existing VSS 6 to VSS 6.0d (by running the Visual Studio 6 Service Pack) And now Source Control is re-enabled. ...Show All

• SQL Server Returning objects from CLR Stored Procedure

  Hello All I have a few questions about how to return a DataSet object from a CLR Stored Procedure as an output parameter: Can this be done  I am having problems at execution time with declaring an output parameter of the type "DataSet". "Cannot find type DataSet" message, compiler/build does not complain, error occurs at execution time. This seems like one of the most obvious ways to create a more object-oriented approach using the tec ...Show All

• SQL Server Message Queue Task

  Ok, im making some progress. So what i have is a Message Queue Task which is bound to a message queue connection manager (which 'tests' ok). The Message Queue Task is set to recieve, variable from string message (declared a variable of type string) and to remove the message from the queue. The output of that task is piped into the data flow task. The data flow task expands into a XML Source which is configured to get its input from the string i ...Show All

• Visual C# simple question in windows hooks

  ok i`m confused on the following thing.. they say you cant make hooks other then mouse and keyboard hook.. in .NET Framework.. and only works ina native dll now if i create a library class in c# and the hook procedure goes there.. and i create a app that will use that managed dll.. will it work to hook other hooks then mouse and keyboard .. like CBT Hooks CBT hooks are possible in C#- Check out this- http://www.codeproject.com/cs/mi ...Show All

• .NET Development SSL server throws WebException for a protocol violation.

  Hi, I'm currently working on connecting to an HTTP server on a local network to grab log files, push configurations, and modify access rights to the server. This product could be deployed to sites where said server has SSL enabled. As such, I am doing testing on a server with SSL enabled. I already have it set up to accept server certificates, but I'm having an issue when I try to get the response of the server. The code snippet is: Sys ...Show All

• Visual Studio Team System What about Database Design?

  I keep searching the MSF Agile Process for a "Design Database" work item, activity or task. But I cannot find it. Isn't it considered as part of the process Thanks. That's a specific task that would not be applicable for all projects. The default work items are not intended to be all-encompassing, but representative of the tasks you need to perform. ...Show All

• Visual Studio Tools for Office How to use set_subTotals in VSTO with C#?

  Hi, I am trying to suppress subtotals for multiple row fields on a pivot table generated on a VSTO worksheet. In VBA the method to use was to set the Subtotals property of the pivot table to an array of 12 false values (go figure!). Now, I am trying to do the same with C# on a VSTO project. C#'s IntelliSense offers the option for get_Subtotals(object index, object __p2) When I hit F1 over the line of code nothing shows up. object [] n ...Show All

• Visual Basic System.Runtime.InteropServices.COMException (0x800A03EC): Cannot access xls file

  Hello I am trying to retrieve the Worksheet name from an Excel spreadshet so I can load into a dataset for conversion to a .csv file. I am aware that Excel has that facility built in, but the users that use Excel are not familiar enough with Excel to use that feature, it is up to me to write an application that will do this for them. (Automate as much as possible, if you will.) Nevertheless, when I try to retrive the worksheet name, ...Show All

• Visual Studio Tools for Office Upgrade record

  How can i upgrade record from excel to db table (msaccess), when i use vsto dataset merged into excel spreadsheet Have you a sample please Thank you Carlo Cantoni Hi Carlo, Yes, you should be able to use the same code within a Microsoft Word VSTO project to update the underlying data source. You would obviously need to change the code slightly such as: Globals.ThisDocument.CustomersTableAdapter.Update(G ...Show All

• Visual C++ problem reading registry

  Hi all I have a problem reading a registry key value : ret = RegQueryValueEx(hkey, L"SchemeName ", NULL, &type, (LPBYTE)data, &len); this code returns ERROR_SUCCESS; however data always contains only the first letter of the value ... len = 512, data is declared as char[512]; I suspect the problem comes from a mismatch between UNICODE and ASCII but I don't know how to work this out. Can anyone help Thanks Emmanuel ...Show All