Nigel Horne's Q&A profile

• SQL Server Issue when exporting to excel...

  Hi i am using Reporting Services 2000 in my application, and am getting an error when i attempt to export to excel. the error that i recieve in the popup window is the following, "Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set to an instance of an object. " i have discovered that this occurs when rendering the two textboxes used in the footer of my report, as when i remove them, the report renders fine. note all other export functions (pdf, csv etc etc) work fine. any help on how to fix this problem ...Show All

• SQL Server can I use * to specify 'Output Column' for OLD DB Source Editor?

  I am working on a situation similar to 'Get all from Table A that isn't in Table B' http://www.sqlis.com/default.aspx 311 I noticed that if one column's name of source table changes,(say Year to Year2) I have to modify all 'data flow transformations' in the task. I am new to SSIS. thanks! -ZZ It seems that MS has solution for 'Dynamic Metadata', although SSIS pipeline requires static metadata. "Advacned ETL: Embedding Integration Services" from PDC05 mentioned this issue. SMO is needed. I am still searching for the samples. -ZZhang ...Show All

• Software Development for Windows Vista XPS Copies filter

  I have implemented a copies filter as part of XpsDrv. I have implemented by replicating the *.fpage and refering to it in the *.fdoc. But i feel this approach is not efficient,because the the size of the document goes on increasing with the number of copies. Is there any other method to refer to the same page in *.fdoc document. Thanx Tobin ...Show All

• Visual Studio 2008 (Pre-release) Schema aware XLinq

  I managed to get some time to read the Linq project overview and play around a bit more. I had some thoughts on how Xml Schema and Xlinq could work well together based on one or two examples i found in the document. I've no idea whether this could happen, but in the word of deferred query evaluation anything is possible :) Consider this example within the document : IEnumerable<Person> persons = from e in x.Descendants("Person") select new Person { Name = e.Value, Age = (int )e.Attribute("Age") 21 }; It would be nicer for me to have previously done this: < xml version="1.0" encoding="utf-8" > <xs:schema id="XMLSchema1" elementFormDefault="qua ...Show All

• Visual Studio 2008 (Pre-release) Interoperability, SOA & WCF

  Hello, I'm a newbe to SOA and WCF. I've done a bunch of prototypes. But now I'm facing a challenging situation. Lets say that I have a class: Order, and a Service: OrderService. Through the magic of WCF I can serialize an order from the server to the consumer (Order OrderSerivce.GetOrderById(int orderID)) and access all of order's properties and order's behavior (through its exposed methods). Kind of like remoting. But now if I want to share this with a consumer on another platform what happens That consumer will just get a soap envelop in response to its request. It may even create an order object out of the response. But it won't have access to any of the order's behavior (because thier object let's say a java order object) ...Show All

• Visual C# LinkedList of class object

  I am trying to create a LinkedList of class objects. Partial code is: public class Game1 : Microsoft.Xna.Framework.Game { private Object3D my3DNode; LinkedList<Object3D> myPrimitives = new LinkedList<Object3D>(); public Game1() { my3DNode = new LinkedListNode<Object3D> (new Object3D(Vector3.One,0.0f,0.0f,"Media\\chamferedcube")); etc... } Object3D is a class definied in another file, but the constructor does take the 4 parameters I am trying to use above. I get this error msg on the last line of code above Error 1 Cannot implicitly convert type 'System.Collections.Generic.LinkedListNode<Tetris3D.Object3D>' to 'Tetris3D.Object3D' C:\Data\Personal\GameProgramming\Tetris3D\Tetris3D ...Show All

• Visual Basic Detecting WMI Core 1.5

  I need to detect the existance of WMI Core 1.5, ideally by detecting if a specific registry key or a specific file exists. RyanB88, How is your problem going Have you tried using WMI scripting I think it can be done by the WMI scripting. In general, WMI scripts: 1. Connect to the WMI service. 2. Retrieve a WMI object or collection of objects. 3. Perform some sort of task on the object or objects. Until now, this task has largely been confined to reporting property values. However, you can also do such things as run methods, configure property values, and create or delete instances. To become proficient in writing WMI scripts, you need to understand the nuances of ...Show All

• Visual C# How to use ActiveX in a Windows Service

  I developed a Windows Service, which will create instance of ActiveX, but I got an error: System.Threading.ThreadStateException: Could not instantiate ActiveX control 'b0b25446-7656-456c-8d3c-60a0ac6eac49' because the current thread is not in a single-threaded apartment. at System.Windows.Forms.AxHost..ctor(String clsid, Int32 flags) at System.Windows.Forms.AxHost..ctor(String clsid) at AxJDSMSCtrl.AxJindiSMSControl..ctor() at SMSPlatForm.MainService.start() [Code] AxJDSMSCtrl.AxJindiSMSControl ocx = new AxJDSMSCtrl.AxJindiSMSControl(); This service log on as Local System, and "Allow service to interact with Desktop". This service communicates with serial port, the functionality is provided by a third party OCX ...Show All

• Visual C# How to use a C++ function(int ** ptr) through DllImport in C#

  I have a C++ function that takes int** as one of it's parameters - say HResult Func(int** x) I use the [DllImport("<dll name>")] and declare in the C# code as : public static extern int func( ref int x ) I problem with above is that I doubt if this declararion is is sufficient to represent the "pointer to pointer" aspect of native signature. Do you know what signature is required in the C# world thanks, ~S i'm guessing here, as I haven't done this before.  but have you tried: public static extern int func( ref IntPtr x )   ...Show All

• Software Development for Windows Vista Changing the workflow's controls properties at runtime

  Hello, I'll explain my situation: I have a document validation workflow, where 3 different ranks of users can post documents and their superior rank has to validate them. I use an sql role provider with the 3 roles defined. When a user wants to submit a document he has to fire an event ("start workflow"). My idea is that after receiving that event I would like to insert a code activity where I check the username of the person that fired the event and check wich is his role. And then based on that role, I would change the "Roles" property of the other event handlers to set it to the role of the superior that has to validate. So for example, a person with the role "Technician" submits a document. Then afte ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A couple questions (may be slightly off topic)

  1. I've been wanting to put up some code onto a webpage, but I want some syntax highlighting. Does anybody know of some good scripts to achieve this 2. Is there any way to take an enum (i.e. public enum Maps{MapA, MapB, MapC};) and iterate through them without typing out every term thanks for the tip about the enums; that'll make my code much simpler. However, for the syntax highlighting, I was wondering if there were any good php/javascript scripts to do it for me. That way, i can upload plain-text code without html. ...Show All

• SQL Server Reusability & SSIS - issues they do not write in books about

  I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version Jon Limjap wrote: I think for what you want to do you have to save your script in a legitimate VB 2005 class library and register that class library with the CLR so you can referenc ...Show All

• SQL Server SQLCMD to execute all script files in directory?

  I'm wondering if there is a way to integrate SQLCMD into something like a cmd or batch file (or even if there is a way to do this in SQLCMD that I've missed) to execute every file in a directory. For example, if I script all jobs, logins and operators on a server to their own script files and then want to execute all of these script files on another server, without having to execute each script file individually. I developed a .NET app that loops through a specified directory and generates a SQLCMD script with the -i option preceding each filename (and writes this to a text file, from which I can paste it into the command prompt window), but I'm sure this isn't normally how it's done. For example, if I wanted to add this process (of execut ...Show All

• .NET Development RegEx with Text File

  Hi All, I have to read a text file that's follow bellow: int#string#string int#string#string int#string#string ... I would like me read this using RegEx and StreamReader classes. I want to use RegEx to create a format validator. ,and StreamReader in order to do my code clearer. Thanks for all in advance. --JORDI-- I'm guessing you are asking for a Regular Expression to validate this how about something like this. with grouping: ^(\d )#([^#])#([^#])$ without grouping: ^\d #[^#]#[^#]$ This will help you understand what this regex means. http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpgenref/html/cpconRegularExpressionsLanguageElements.asp ...Show All

• Visual C# Completely Invisible/Hidden Application

  I wanna create such an small application/exe which will be completely hidden/invisible to the user when it is run. Even it will not be displayed in the taskbar, system tray, task manager(application tab). I've no problem if it is: a) a console application or any other types of application (but i don't wanna see the splash screen of MS-DOS screen when I'll click on my .exe file) b) only showed in the task manager (processes tab). Anybody can help me providing snippet of code/idea or anything else. By adding Hide() on the Activate event makes your application not accessible by pressing ALT-TAB. Hope it helps. Fernando ...Show All