Tom Helm's Q&A profile

• SQL Server Problem running SQL CLR MSDN example

  Hello, Using VS 2005 SP1 beta and SQL Server 2005. I am trying to learn how SQL CLR works by using this example: http://msdn2.microsoft.com/en-us/library/5czye81z.aspx When I press F5, I get this error: A .NET Framework error occurred during execution of user defined routine or aggregate 'InsertCurrency': System.Data.SqlClient.SqlException: Must declare the scalar variable "@CurrencyCode". Do I need to declare @CurrencyCode in the Test.sql script Thanks for any suggestions, Tom NNTP User is correct, the parameters need to be added to the command's parameters collection. I also added the current date (GetDate()) to the INSERT values. Here's the updated method that ...Show All

• SQL Server components Design state or Running state

  Hi, I am doing a custom destination transformation, How would I know wether the Destination component is in Design state (getting edited by BIDS) or wether the component is getting executed(by BIDS or DTEXEC) Is there any property or ENUM by name DesignState. Thanks Dharmbir ...Show All

• Visual C++ What #include<file> is necessary for using namespace System;?

  The Visual Studio 2005 MSDN Help Search doesn't explain the prerequisite #include<file> needed before the System namespace can be called, for example, in the case it were needed to execute the following statements: using namespace System; Console::Clear(); Does anyone know this necessarily perchance Thanks. Need #include<file> for Console::Clear(); function using namespace System. Does anyone know this information Thanks. ...Show All

• SQL Server footer not shown for subreports

  hi, i am showing a subreport from a main reports. i have set header and footer for the subreprt. But it is not shown. Thanks in advance, Vinu You can add a textbox inside the body but out of table or add e rectagle and add all inside it, depend wich type of information you need.. ...Show All

• Visual Studio Express Editions Visual C++ Runtime Error

  ok--I know I am really out of my league here because I have no clue what Visual C++ is, much less that had it! It must be a disease because it won't let me open my genealogy files in family treemaker. I don't know what I did but I get a message that reads : Family TreeMaker did not shut down properly the last time you used the program. Your files may be damaged---etc. Click OK to continue-- THEN Microsoft Visual C++ Runtime Library Program:C:\FTW\FTW.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. Well, guys, I don't even know what support team they are referring to. Obviously it isn't FamilyTreeMaker because I have ...Show All

• Software Development for Windows Vista workflows interacting with multiple users

  Can anyone suggest a solution for the following scenario: Several clients perform an online auction, an administrator starts the auction. So, which are the mechanisms of synchronization and data transmission These might be separate workflows interacting one with another or the clients might interact with a workflow instance in some way (raising events for the workflow, sending data etc.) Thanks You'll need to add a cookiecontainer to the proxy in your client application and make sure to set the cookie value to the workflow instance id. THis is used by the HTTPModule on the server to route your request to the right workflow. See this article for more information, and the sample code that comes along wi ...Show All

• Visual Studio Express Editions ActiveX problems in .net

  Few active X that used to work properly, means we can easily add them to our forms , throws error when we try them to place on our forms. Even few makes the visual studio crash. I was really shocked to see even the MS studio crashing. Is there any specific reason for the same, even some errors show that since they are working with unmanaged code for controlling ActiveX addition to forms , they are crashing. One example of such a active X control is MSVSA Button Class. Please provide some input on the way to get out of the problem. Even do we have some way by which we can check if the current activeX control is licensed or not. Hi, ActiveX Licensing solely depends on the author of the Acti ...Show All

• Visual Studio 2008 (Pre-release) ServiceHost for big class

  Hi, I know that the 'ServiceHost' only instance one class, so I have two options : 1)Create one 'ServiceHost' for each class; 2)Create a big class for one 'ServiceHost'; My problem is that I need to add 'services' at run-time like I did with .net remoting. Does anybody know a workaround for it or...What I need to turn it possible just for curiosity, why this limitation Thanks, Alexnaldo Santos I know, but using multiple servicehost I need to know from client any new endpoint.Ok! Isn't problem change my client app. Now, when I create a new servicehost the 'PerSession' ins't more usable, because from client I must connect to any new 'servicehost', so isn't good create a list of `Proxy` fo ...Show All

• Internet Explorer Development IE7 HP Director Problem

  I can't use HP Directors or Solution Center after install IE7. I installed fresh HP software and updates. But problem persist. When reinstall IE6 back, problem solved. who knows anyway or have ideas Please help me. Thank you, Hi there. I read your post and tried the workaround that you mentioned but on my system nothing happened at all. It doesn't work for me. I can't even use the HP Sotware update function to check for software updates. However I did notice that if I reboot the computer and try the software update function before trying to load the HP Director application that it did work. However HP comes back saying that there are no new updates available. I then called HP's tech support and they are aware of the issue ...Show All

• .NET Development How to set registry key permission in .NET Framework 1.1

  Hi, all I noticed that http://msdn2.microsoft.com/en-us/library/microsoft.win32.registrykey.setaccesscontrol.aspx was only supported .NET 2.0 So, how do I set registry key permission using .NET Framework 1.1 Thanks in advance! Ming. I think you are looking for the RegistryPermissions class ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How hard could it be?

  I mean how hard could it be to make a First person Shooter similar to battlefield 2 What is involved Im sorry Im new at this and still have alot to learn obviously. Well, online MP would be out of the question (Edit: Only for the 360, though), maybe 64 split-screen :P. Either way, it would take one person (if you were to take it on single-handedly) about a year to create such a thing, including assetts, etc. However, if you were to scale it down to, say, a 4-player close-quater kind of environment, then I don't see why you couldn't create it in maybe 4 months (given that you would use free models, sounds, textures, etc.). Anyway, that's my two pence. t_p ...Show All

• Visual C# .NET Framework and compatibility

  Goodday, lately I've been programming an MMORPG in another programming language. Anyway, I'd like to learn a new and more adult programming language right now, and it seems Visual C# fits perfectly for this. But there's one question that still stops me from completely getting into C# learning; the .NET Framework. The disadvantage is that a person who wants to run my program will need to have the framework installed, and this is quite irritating for an MMORPG. I've been trying some out and untill now I didn't find anybody having .NET Framework 2.x on their PC yet (except me of course). It seems they don't receive it automatically using the automatic Windows update. It would be quite irritating to ask all my clients to download another 20mb ...Show All

• Windows Forms Control for data lookup (high data volume)

  Can someone recommend a windows forms control for displaying bound data thats quick and efficent. I'm looking on retrieveing around 100,000+ rows and displaying one column. Any helpful links would be greatefully receieved. Thx. I've done some testing and found that it takes 8secs to populate a DataGrid and 13mins to populate a TreeView. I'm sure that there are some documented recomendations regarding this topic... just can't seem to find them on the web. ...Show All

• Visual C# Couple of C# newbie questions

  I am very new to C#, so please bear with me if these questions are rather elementary. 1) I wanted to get the system time, so I searched the forums for it, and found this example: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=424660&SiteID=1 while this is all good and well, are there no easier ways to format a date Maybe something similar to Java's DateFormat classes 2) I tried to apply generics to an ArrayList class, as such: ArrayList<MyObject> myList = new ArrayList<MyObject>(); but I got the exception that I cant use ArrayList with type arguements. Am i doing something wrong Or are there other lists reserved for Generics use 3) I cant seem to figure out how to add a Titled border to ...Show All

• Windows Forms Open Directory Dialog

  I am looking for a way to have an open directory dialog, I was hoping to use the standard FileDialog and make a few changes but that is not a viable option. I was hoping not to have to create my own. Any ideas theTroll From the MSDN about FileDialog: " FileDialog is an abstract class that contains common behavior for the OpenFileDialog and SaveFileDialog classes. It is not intended to be used directly but contains common behavior for those two classes. You cannot create an instance of FileDialog . Although the class is declared public, you cannot inherit from it, as it contains internal abstract methods. To create a dialog box to select or save a file, use OpenFileDialog or SaveFileDialog ." So ...Show All