Harald Mejlholm's Q&A profile

• SQL Server Using SELECT...INTO

  Is there a way to maintain all of the indices and constraints when copying the structure of one table to another I used this command to copy the table, but it does not bring over all of the indexes and constraints... SELECT TOP 0 * INTO rft_CPT4_DES FROM rft_CPT4_bak So, if I were to import (or export) the data from one location to another, it would maintain all of the index info, etc Thanks! J ...Show All

• .NET Development aspnet_regiis error when encrypting connectionStrings

  I have a website whose domain is www.myWebsite.com and on my server it is located in a directory on my c: drive at the following physical path: c:\dirVirtual\myWebsite I have a connection string defined in my web.config in the connectionString section. <connectionStrings> <add name="myConnectionString" connectionString="Data Source = 1.2.3.4; Initial Catalog = XYZ; UserID=user;Passowrd=xyz" providername="System.Data.SqlClient" /> </connectionStrings> I go to the c:\Windows\Microsoft.Net\FrameWork\2.050727 directory and there run the following command to try to encrypt this section: aspnet_regiis -pe "connectionStrings" -app "/myWebsite" -prov Dat ...Show All

• SQL Server Error Handling SQL 2000

  Hello, Could it be possible to catch into a variable any type of sql server error I have an stored procedured that executes as a part of a cycle one stored procedured many times (one for each branch). I need to make the stored procedured to continue even when I have an error in one of the executions (one of the procedures of a branch). For example, I execute this as a part of a While Statement Exec @return_status = @sp_name @Link, @Historia, @begindate, @enddate If @return_status <> 0 Begin Print ' /* Exito */' ..... update End Else Begin Print '/* Error */' .... EXEC master.dbo.xp_sendmail @recipients = @mail_recipient, @subject = @mail_subject, @message = @mail_query ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Programming is very Hard

  I've been reading DirectX sdk tutorials and MDX tutorials and things like that, and it seems VERY VERY VERY hard. Will this new XNA studio and the documentation simplify this All these vectors and whatnot is very complicated and I'm having trouble understanding seemingly basic concepts in game programming in 3d. When you get into collision detection and reaction with high velocity objects, that's when my brain explodes and leaves a black hole. Game developers are probably some of the most talented individuals when it comes to understanding problems and solving them efficiently. There is still a lot of hacking (performance vs. maintainable code) going on though; that is why they might not be the best fit for enterprise level so ...Show All

• Visual Studio Express Editions Form1 'unhandled exception' with PictureBox

  I am making a simple Windows Form in C# in which each button event creates a PictureBox, referring to an image on my d:/ drive. Every successive click creates another below the previous PicBox until it goes off the form. I set the form AutoSrcoll to true. The problem is that when a PictureBox is created beyond the form boundaries, the exe crashes and VSC#2005 points to the line: Application .Run( new Form1 ()); saying: Argument exception was unhandled and that 'parameter is not valid' Would anyone have a clue how to solve this Sorry, I'm quite new at this. Cheers - Gj Your program is crashing inside the framework, most likely in the PictureBox' Paint event handler. That's why you don't get a good source code ...Show All

• .NET Development custom plugin questions!

  Hi there. I have no idea but had a sudden urge to ask about things like this, I guess its good for the knowledge! I have an app created in .NET 1.1 I *may* wish to implement plugin's with the application, so developers can create their own plugin's for the application. Question 1) If a plugin was created in .NET 2.0, will it still work with the .NET 1.1 application (obviously assuming they have both frameworks installed) Question 2) How would one go about creating plugin's for their application Question 3) Is it possible for this plugin to implement/"subscribe" to public events exposed by my application, so when I raise an event, any of the plugin's who have a subscription to the event, is notified Th ...Show All

• Software Development for Windows Vista HandleExternalEvent activity in Parallel

  I have a few activities in parallel that listen for the same event. With the event arguments I will see which one of the parallel activities to execute. It seems though that the event is only fired in the first activity and not in all the activities waiting for this event to fire. I would say, this is the 99.9% bug. When you define an event, you are forced to use "event" keyword (ExternalDataExchangeService) which is actually a MulticastDelegate. What means - several subscribers for the same event... I see no reason, why your workflow does not react properly... Otherwise it must be "delegate" keyword... Second, I have never ever heard that in .NET the source of the event HAS TO ...Show All

• Internet Explorer Development How to cmplement GetResourceInstance() in CAtlDllModuleT

  Hi, I'm porting one of the dll from vc6 to vc8. In doing so I have created a complete framework to create a dll and subseqently add atl objects. By default the framewaork adds the follwoing code in the main app file class MyClassModule : public CAtlDllModuleT< MyClassModule> { public : DECLARE_LIBID(LIBID_MyClassLib) DECLARE_REGISTRY_APPID_RESOURCEID(IDR_MYCLASS, "{7C00C752-3DA7-4CB9-B721-7F39F9FEDD2E}" ) }; In previous versions of ATL CComModule _Module was used which has been replaced by CAtlBaseModule. Problem: In the current application there is an extern CComModule _Module in stdafx.h and definition in main app file as CComModule _Module . 1 )My previous application uses ...Show All

• Visual Studio Express Editions Using winsock

  How would i go about using a winsock i would like to be able to click a buttton on one pc and sometink else to happen on the other Any help would be great thank WinSock is not supported in the .NET Framework but instead the TCPClient, NetworkStream, TCPListener and Socket classes are available. There are many examples on the forums and on the internet you could follow :-) Take a look at these: http://msdn2.microsoft.com/en-us/library/system.net.sockets.tcpclient.aspx http://msdn2.microsoft.com/en-us/library/system.net.sockets.tcplistener.aspx http://msdn2.microsoft.com/en-us/library/system.net.sockets.socket.aspx http://msdn2.microsoft.com/en-us/library/system.net.sockets.networkstream.aspx ...Show All

• SQL Server CLR .Net Framework 3.0

  Hi Is there any way to get the Sql 2005 to load the .Net 3.0 Framework instead of 2.0, when running a Stored Proc Thanks You wouldn’t ask if you used SQLServer 2005 since beta :-) No, you can’t. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms TreeView fails to display icons, why?

  **also posted to VSTO form...no replies ** My VSTO Outlook add-in shows a form with a TreeView control. The tree works properly, showing the data I expect it to, but not the icon images. When I add a default root node in VS Designer and assign it an image from my ImageList, it appears correctly in the designer. When I run the add-in, the default node appears, but without icon. There was a related thread MSDN Forums Windows Forms Windows Forms General Icons not showing up on Treview on VSTO beta, but no real answer posted. Anyone have any ideas The debugger shows that the TreeView object does have the ImageList, and that the ImageList has the right number of images, and that the nodes have ImageIndex values in the prop ...Show All

• .NET Development ....current thread is not in a single-threaded apartment

  Hello, Background: Recently I converted a VB.Net 2002 application to VB.Net 2005. The application was simply to big to rewrite. One of my purchased activeX controls failed with a Stack Error. The vendor informed me that the work-around with VS2005 is to call the controls methods in a second thread. Now I am getting the error: "ActiveX control> '6262d3a0-531b-11cf-91f6-c2863c385e30' cannot be instantiated because the current thread is not in a single-threaded apartment." I am new to "threading" and have read a few posts talking about a STATHREAD which I think sets your app to be a single threaded apartment but I do not know where it would go or the syntax for it. Does anyone know how to I set my VB ...Show All

• Visual Basic Is it legal to redistribute fonts?

  Please correct me if I'm posting in the wrong forum. On my computer I have the font Myriad, and I would like to use it in my software. The only problem is, most people don't have the font installed, and it is not a free component. Would it be legal if I installed the font on the end user's computer so that they can use my software properly, or do I need to use system fonts instead If you say the component is not free then redistributing the component will of course be illegal. You would have to stick with the system fonts or find a freeware font that you can redistribute along with your application. ...Show All

• Visual Studio Express Editions How to get file info from drag and drop operation

  Hi, I want to be able to get the file info (path and file name) of any file (just one at a time) when it is being dragged onto a windows form in VB 2005. Is that possible, I have been searching and get various stuff back but I am confused. Has any one got a simple piece of advise or code for this Thanks in advance. Kim Private Sub Form1_DragOver( ByVal sender As System.Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles MyBase .DragOver e.Effect = DragDropEffects.Link Dim objData As Object Dim eFile as String objData = e.Data.GetData(DataFormats.FileDrop) eFile = CStr (objData(0)) End Sub The filename will be placed in eFile variable. Dustin ...Show All

• Internet Explorer Development Where are my cookies/temp files

  I just d/l the new IE7 today. On the older version I was able to go into my cookies and temp internet files folder and view/delete them at will. Tonight i tried to go and do that and they are not there. Where are they Has the location been moved or am I just missing something. Thanx If you're sure you're looking in the right folder, it's possible there aren't any temporary files. Perhaps you've configured IE to clean-up after itself or perhaps there is a utility on your system that cleans things up. In addition, don't forget that certain settings in Windows Explorer will hide certain files from view; this helps prevent novice users from accindetally deleting something important. Hope this helps.. ...Show All