steveareno's Q&A profile

• SQL Server Quick Question Importing

  Two Quick Question's, Are you better off importing data through Excel or through Text files in terms of ease of use \ Speed \ Efficency etc or does it make a differance Also if I am loading data into a SQL database should I always use the "SQL Server Destination" rather than the "OLE DB Destination" Hope Q's aren't too basic, both seem to work for me, but I just want to make sure im using the right one. Thank you ...Show All

• Windows Forms raise events for control collection

  This might be disturbingly simple, I have 225 buttons on a windows form application that all need to run the same code, I can put them all in a Panel or group them in a ControlCollection Object, I just need to know how to Raise Click Events for this 'group' of controls, VB studio 2005, using Visual Basic. I found an example in help, for .Net 2003, but it doesn't work. Any help or links would be appreciated. Ben thanks much ...Show All

• Visual Basic save own class in my.settings

  Hello, I have the problem that I have written an class that inherits from the basic class System.Windows.Forms.Form and I added some properties. I try now to save an instance of such a Form in the my.settings object. But that doesn't work because some of the child controls are not XML serializeable. (I tried to serialize my own class with an XML Serializer class). But that is not so bad because there are only 3 Values that need to be saved ...Show All

• .NET Development Encryption

  In order to encrypt information saved by a user to a textfile, I found a nice example using tripleDES and it works fine. The only problem I see is that the numbers I used for the byte array that makes up the key and IV are easily viewable by using a disassembler like ILDASM. I used the community edition of dotfuscator, which does scramble up the classes and stuff, but those values are still readily seen, even if it is now harder to actually find ...Show All

• SQL Server Assembly Clash between June and July CTP in VS.NET/SQL Express

  Hi!  How do I upgrade the assemblies in a databases between the Framework that came in VS.NET June CTP and VS.NET July CTP.  I've created a fairly extensive database in the former which I'd like to use in the later.  All of the non-CLR stuff seems to be accessible just fine.  Unfortunately I no longer have the June CTP installed and the assemblies are running into versioning problems.  I'd be happy to delete the offendin ...Show All

• SQL Server Detect whether executiontime or designtime in custom component

  In my custom component in the validate() method I want to determine whether this method is called during runtime or during designtime. I Can't find a property for this on PipelineComponent or ComponentMetaData. Is it possible Regards, Henk Ok, I lied I don't use variables in Validate, but I do in AcquireConnections, so still in a component, and that is called during design and execution times. if (Variable ...Show All

• Visual Basic Mixed data type in a Mulicolumn listbox

  How do I store an object and the object.text in two separate columns in the same row of a listbox I want to make one listbox column visible and one hidden. Why do you need two columns then if you making one invisible. The following simply adds objects to a listbox. As long as you override the tostring property this is what will show in the listbox but underlying the item is the object which you can cast to and then use the properties ...Show All

• SQL Server Transfer SQL Server Objects Task - Warning: Stored procedure already exists at destination.

  I am trying to use a Transfer SQL Server Objects Task to copy a portions of tables from one db to a second db. the connection is using Windows Authentication. I am logged in as the Administrator That user has sysadmin rights on the Sql Server in Question. DropObjectsFirst = True But when I execute the task I get the follwing warning [Transfer SQL Server Objects Task] Warning: Stored procedure "{0}" already exists at d ...Show All

• Visual C# Executing a method of a class as soon as the class is reffered!

  Hi, It would be great if someone could provide me a solution to my problem. I am creating a class ( say the class is named as Checkconnection.cs) that would check if my system is connected to the internet. I need to continously check for an internet connection and if there is a connection I need to carry out the required operation. Now imagine a third party is using my class, Checkconnection.cs in another application (say HisApplication),and ...Show All

• Visual Studio Tools for Office My Word COM add-in stops working - I do not think it is a memory leak

  Hi, I have created a COM add-in for Word. When I start word the plugin works fine, but at the moment that I click "New Document" and Document2 is opened then the plugin no longer fires the click event. My code is as follows: namespace MyAddin2 { using System; using Extensibility; using System.Runtime.InteropServices; using System.Windows.Forms; using Word = Microsoft.Office.Interop.Word; using ...Show All

• .NET Development Framework 2.0 redist beta v2.0.50215 / Framework 2.0 runtime v2.050727

  hello. i am live with a portal which uses version v2.0.50215 .... Is it possible to install on a the live server also the current fullversion of .Net framework v2.050727 without to uninstall temporary v2.0.50215 thanks No. You can only install one copy of .NET 2.0. You will need to remove .NET 2.0.50215 before installing the RTM (2.0.50727). ...Show All

• Visual Studio Team System Move PInvokes to native methods Class

  Hi Guys I'm getting the above warning in FXCop (1.35), any examples on what I need to do to correct. Thanks FX Cop reports the following CriticalWarning, Certainty 95, for MovePInvokesToNativeMethodsClass { Target : GetKeyState(System.Int32):System.Int32 (IntrospectionTargetMethodBase) Resolution : "Because it is a DllImport method, FrmLogin.GetKeyState( Int32):Int32 should be defined in a class named NativeMethods, SafeNative ...Show All

• Visual Studio Team System Team Suite or Professional?

  Would anyone be able to tell me what makes Team Suite any better than having Professional plus another free unit testing model. I have had a look at the comparitive table, but I'm only fairly new to this and to be honest I ended up not knowing anymore after reading it. So if someone could tell me in practical terms why paying all that money for Team Suite over Professional is a good idea it would be appriciated. The integration with Team F ...Show All

• Smart Device Development how to generate Setup and deployment project for PPC

  HI , I've developed an application for PPC. It's working fine . Now i want to create a setup project. But i don't have any idea abt that. my application utilizes XML lookup tables.Can i add it into setup how to add icon Kindly suggest me to acheive this!. If u know links related to it kindly post it!. Thank You! Hi Senthil, I'm happy to inform u that i successfully load the pgm b ...Show All

• SQL Server Copy member data to another member

  Hi, I need to copy all data from one member to another member from the same dimension. To be more specific, I have a scenario dimension with these members: ->Budget ->Forecast And I want to start my Forecast with the Budget data from last year * 1.05. Because I will change the values from forecast I can't just put a formula (forecast = budget *1.05, if I do that the cube will always show the formula values and not some new values that I wa ...Show All