Gary Ho's Q&A profile

• SQL Server Stopping package execution programatically

  Hi, I am p rogrammatically creating a package and for executing the package i say "Package.Execute()". Likewise,is there any method exposed which programatically stops the package execution Thanks in advance, Suganya Yes, there is a programmatic way to halt packages. The API is fundamentally broken if you're running thousands of packages an hour. If the rate is more like 100 or less, it may well work reliably. The method is RunningPackage.Stop(). The flaw is the the attributes of the RunningPackage API do not accurately represent the running package, so if you're running 10s or 100s of duplicate packages simultaneously (with different variable settings only), without the proper information, you don't have ...Show All

• SQL Server ForEachLoop and Object-Variable

  Hi there! I want to use a ForEachLoop. I've an object variable what i fill before going into the ForEachLoop. It contains 4 columns and in my testscenario it has two rows. In the ForEachLoop i want to set the current row values to 4 package variables (within package scope). So i set the Enumerater as "Foreach-ADO-Enumerator", the Ado-source-variable is my objectvariable (what contains the recordset), and the enumerator-configuration i set to "rows in all tables" ("rows in the first table" works with equal result). The variable-mapping looks like that: Mypackvar1        - Index 0 Mypackvar2        - Index 1 Mypackvar3     &nbs ...Show All

• Visual C# Security error while trying to run C# application

  Hi I have a C# windows application which I run by giving the arguments to local files eg:- HelloWorld c:\testdata\hello\ c:\testdata\sign\ It gives me an error The given path's format is not supported. at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.AddExpressions(String[] str, Boolean checkForDuplicates, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Bool ...Show All

• Microsoft ISV Community Center Forums Setting back color in MSComctlLib.TreeCtrl.2 control using VB for MS Access

  Hi there, I would like to set the background color of a treeview control to another default windows color other than the 'white window'. Say I want to use the constant vbActiveBorder . Now the ImageList control allows for the setting of these values via properties, but the Treeview control does not. How do I go about setting the back color of the treeview control For info I have already set up the icons etc with a magenta mask, so that they will be transparent etc. Thanks in advance You can't do that directly via VB. You have to use Win32 API. For more information regarding this issue, please look into the information regarding SendMessageA() function on the web. ...Show All

• Visual Studio Team System Team Build Sources Directory

  Is there any way to make a build type (team build) use a common directory for it's references rather than it get the latest source code on every referenced solution when building one solution It sounds like you have your workspace mappings set at the Team Project level. If you haven't updated your WorkspaceMappings.xml file fromthe default create by the Team Build Wizard, you will always be getting all of the source code in your Team Project on each build. Check out this blog posting to see how to cloak subfolders and cut down onthe files sync'd during each build. - Steve ...Show All

• SQL Server how to create an copy of a certain record except one specific column that must be different & insert the new record in the table

  Hi I have a table with a user column and other columns. User column id the primary key. I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key Thanks. try this: insert into your_table ( user , field2 , field3 , ... ) select 'user2' , field2 , field3 , .... from your_table where user = 'user1' ...Show All

• SQL Server SQL Server 2005 trial - which file to download?

  Hi all, I am extracting SQL server 2005 trial edition to my flash memory hard drive. Hence suppose I should download one of the following three files: " Self-extracting executables: X86 Executable X64 Executable IA64 Executable " But which one should I choose based on what criteria (This point seems clear to everyone but myself, even after I went through all the docs on the download site) Thanks, Jack (an absolute beginner) Hi, X86 is for 32bit Systems, X64 for 64bit systems, IA64 for Itanium Systems. Choose the one that is the appropiate according to your platform you want to install it on. HTH , Jens Suessmeyer . --- http :// www ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Best Draw method for game level (Quake 1 in XNA)

  Does anyone can point me to right place for information on rendering my game when multiple textures are involve. I'm currently rewriting Quake 1 in XNA and I got he levels to load fine but its deadly slow. I do not use the vis yet so I render everything but its still should be pretty fast. If i render the level using only a single texture2d its pretty damn fast but for using multiple texture what I did is take all the triangles using the same textures and collecting them on startup. When im done loading and start to draw I loop in each of those triangles list, set the texture in my effect, fill the vertexbuffer and draw the primitives. thx for (i = 0; i < r_bsp.polygoneCollections.Length; i++) { if (r_bsp.polygoneCol ...Show All

• Visual Basic incrementing rows after the one inserted in a DataGridview

  Given the creation of a DataGridView contents With Me.DataGridView1.Rows For i = 1 To nRows .Add(i) .Item(i - 1).Cells.Item(0).Value = i .Item(i - 1).Cells.Item(1).Value = sChannelName.ToString next i End with I am trying to insert a row at any point in the grid and move any subsequent rows up by one. Sub InsertRow(ByVal iRowPosition As Int16) With Me.DataGridView1.Rows .Insert(iRowPosition) strName = "FX1" .Item(iRowPosition).Cells.Item(0).Value = iRowPosition .Item(iRowPosition).Cells.Item(1).Value = strName End With End Sub Although this does insert a row with a FX1 in the correct row, how do I increment all the other rows after the one inserted Do I have to do a resort or a r ...Show All

• Visual Studio Express Editions Has anybody run Visual C# Project for lesson2 and lesson3?

  hi, when i try to run the project for lesson2, i have some errors; If a method in a class library has been removed or renamed, recompile any assemblies that reference that method. the method is; Application .EnableRTLMirroring(); but i don't know how to recompile the assembly.... and here are the other warnings and errors; Warning 1 The designer cannot process the code at line 224: this.statusStrip1.Raft = System.Windows.Forms.RaftingSides.Bottom; The code within the method 'InitializeComponent' is generated by the designer and should not be manually modified. Please remove any changes and try opening the designer again. D:\Documents and Settings\Emre\My Documents\MSDN\Absolute Beginner-Lesson02CS\Lesson02\Form1.Des ...Show All

• SQL Server Displaying the dates in a column.

  Can someone help me with this. I've been trying to produce it this way but still unsuccessful. I'd like my table to look like this: Month: January Day wkDay ------------- 1     Mon 2     Tues 3     Wed 4     Thurs 5     Fri 6     Sat .     . .     . 31    Wed I want to display the whole month.. Please help.. Thanks.. select datepart ( d , getdate ()) ' Day ' , case datepart ( dw , getdate ()) when 1 then 'Sun' when 2 then 'Mon' when 3 then 'Tue' when 4 then 'Wed' when 5 then 'Thu' when 6 th ...Show All

• Software Development for Windows Vista rule hierarchies

  I'm still feeling my way round wwf and want to represent something like the following: if a < 10 if b < 5 c = 1 else c = 2 else if a >= 10 and a < 20 if b < 5 c = 3 else c = 4 else throw exception i think i need the policy activity for this, but how does one rule lead to another or have i got hold of the wrong end of the stick. also, to get the value of c i must use the CallExternalMethod activity. is this right many thanks, mike. ok, so as i understand it you can sort of fake it through a flat ruleset, or have a more activity based flow. i think using the IfElse activity, and possible CAG activities, make it easier to see where i'm going. am i right ...Show All

• Visual Basic controls PLEASE HELP

  is there a way to make it so that a may program can interact with oter programs like changing songs in windows media player or internet explore How would i do this Often applications will expose and Object Model - which enables you to write code which will control the application.   An example of this may be the Office products which are often used by applications to produce output/documents An example of this may be something like (for excel) http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp   In order to access this functionality you will add a reference to a DLL, which is often COM based - although not always.   COM is merely a technology used to encapsulate function ...Show All

• SQL Server How to block access during peer-to-peer transaction recovery?

  Is there a clean way to block access to a peer which has been offline, during peer-to-peer transaction recovery (while the outstanding transactions are being applied) Thanks, Liston Hi Liston. You could set the db into priviledged user mode, which would only allow dbo's to connect to the given database. Of course, this assumes that standard users/application users aren't dbo's as well. Aside from this, you'd have to write custom code to handle the scenario... HTH, Chad ...Show All

• Visual Basic Configuration.Add() throws exception...

  Having a pretty annoying problem. I figure it has to be something obvious, but I have tried everything, and I am getting nowhere fast. Here is the main code I am using to save a config section to a file: Dim MC As System.Configuration.Configuration Dim filemap As New ExeConfigurationFileMap filemap.ExeConfigFilename = configObject.GetConfigurationFileLocation MC = ConfigurationManager.OpenMappedExeConfiguration(filemap, ConfigurationUserLevel.None) MC.Sections.Remove(configObject.GetSectionName) MC.Sections.Add(configObject.GetSectionName, configObject.ConfigurationSection) MC.Save(ConfigurationSaveMode.Full, True) This will work on a simple config section save. However, I ...Show All