Escape characters for SQLLoader

9. February 2010 18:49 by Mrojas in General  //  Tags: , , , ,   //   Comments (0)


The LINC/EAE migration tool can automatically generate reports that can be used to extract your data from DMSII to your target database, for example Oracle.
In this scenarios the Oracle SQL Loader tool is used. However you might problems loading the data because the string values can contain the same characters you are using to enclose them.

Let’s see an example, taken from an oracle forum:

C:\ora>type buyer.ctl
truncate into table BUYER
FIELDS TERMINATED BY ',' optionally enclosed by '"' TRAILING NULLCOLS

And suppose you have data like:

4,"Your "offspring""

How can you “escape” the enclosing characters. Well I found the answer in another forum:

If two delimiter characters are encountered next to each other, a single occurrence of the delimiter character is used in the data value. For example, 'DON''T' is stored as DON'T. However, if the field consists of just two delimiter characters, its value is null.

So just use something like:


4,"Your ""offspring"""

Easy way to see the Explain Plan in Oracle

3. February 2010 13:07 by Mrojas in   //  Tags: , , , ,   //   Comments (0)


Linc\EAE used profiles for their queries. Well the profile information is used by our migration tool to generate indexes.
In Java is easy to intercept all SQL statements used by the translated application and analyze them.

To analyse how a query is executed you have to study its explain plan. For go here an excellent guide on EXPLAIN PLAN.

After you read that page, you will find useful the following function, that will shorten the lines that you have to type to see the explain plan:

create OR REPLACE function  ShowPlan return sys_refcursor
      c_test sys_refcursor;
  open c_test for select 
  substr (lpad(' ', level-1) || operation || ' (' || options || ')',1,30 ) "Operation", 
  object_name "Object"
  sys.plan_table$ start with id = 0 connect by prior id=parent_id;
  return c_test;
explain plan for select * from MY_TABLE
SQL> variable rc refcursor
SQL> exec :rc := testfunc()

PL/SQL procedure successfully completed.

SQL> print rc
Operation                      Object
------------------------------ ------------------------------

Get Table Owner in Oracle

3. February 2010 12:40 by Mrojas in General  //  Tags: , , , , ,   //   Comments (0)


When we migrate from LINC/EAE to Oracle, the migration tool generates an schema an tables form the original ISPECS.
I came across with the problem that I had been playing around with a test database and I didn’t know who was the owner of the table.

Well just as a reminder this is what is needed:

select owner, table_name, tablespace_name   from dba_tables   where table_name='YOUR_TABLE';
This will return something as:

------------------------------ ------------------------ ------------------------------
THE_OWNER               MY_TABLE       USERS

Get Java Version for Oracle Stored Procedures

1. February 2010 06:17 by Mrojas in General  //  Tags: , , ,   //   Comments (0)

If you have to write stored procedures for oracle is important
to notice which Java version is supported by your Oracle Database,

A common technique is create a JAVA stored procedure for that:

1. Create a function with an ORACLE SQL statement like:

name ‘java.lang.System.getProperty(java.lang.String) return java.lang.String’;


2. Once you created the function you can use it to get the version:

SELECT getJavaProperty(‘java.version’) from dual;

You can see in the attached version that for my Oracle Database the Java version is 1.4.2_04 :)


File Previewers for Outlook

26. January 2010 09:56 by Mrojas in General  //  Tags:   //   Comments (0)

As I developer I usually receive emails with .zip attachments and .xml attachments. When I’m looking for an old email I hate that I have to open the attachment just to see if it has the files I’m looking.


Why isn’t there a built-in preview functionality for .xml and .ZIP files?

So I thought, I’m a developer I can build one. And I found an excellent article about the File Previewers in Outlook 2007 and Windows 7 by Stephen Toub.

I just updated the project files to VS 2008 and removed the dependencies to VJ# replacing them by the SharpZipLib library.


And it works well and does not require you to install anything else!


Below you can see an example of Zip File preview


And and example of XML File Preview


I think is an excellent article and I can know write my own previewers every time I need them.


Download the code from CODE HERE

Download the installer from INSTALLER HERE

Get Exact Text Width C#

15. December 2009 08:13 by Mrojas in   //  Tags: , , , , , , , , ,   //   Comments (0)

 I was recently trying to get the exact width of a string. And I found that the Graphics.MeasureString does not give an exact result.

I finally found Pierre Arnaud

post in Code Project, which gave me a good explaination and solution of what was happening.

You can see in the image Pierre put in his post:

 That Graphics.measurestring will return a size that might be bigger that the actual drawn size, this is due some GDI+ details that he explains in that post.

I really like the second proposed solution:

static public int MeasureDisplayStringWidth(Graphics graphics, string text,Font font)
    System.Drawing.StringFormat format  = new System.Drawing.StringFormat ();
    System.Drawing.RectangleF   rect    = new System.Drawing.RectangleF(0, 0,1000, 1000);
    System.Drawing.CharacterRange[] ranges  = { new System.Drawing.CharacterRange(0, text.Length) };
    System.Drawing.Region[]         regions = new System.Drawing.Region[1];

    format.SetMeasurableCharacterRanges (ranges);
    regions = graphics.MeasureCharacterRanges (text, font, rect, format);
    rect    = regions[0].GetBounds (graphics);

    return (int)(rect.Right + 1.0f);



ActiveX Server Migration to .NET

14. December 2009 08:01 by Mrojas in General  //  Tags: , , , , , , , , , ,   //   Comments (0)

 In VB6 ActiveX-EXEs or ActiveX OLE Server where used for several reasons. Sometimes it was performance (because it allowed you to run your code in another process) and sometimes as way to share resources between several applications, like connection information, database connections, mainframe info, etc.

During migration some of this ActiveX-Exes can be migrated as simple Assembly DLLs, but other require more attention. Specially if they have global variables that hold state shared by several programs.

In that is your case what are your options then?

1. Convert those ActiveX-Exes to Windows Services.

This option is simple. You modify your migrated assembly to work as a Windows Service. The easier way to do that is:

a) Start Microsoft Visual Studio 2005\2008

b) Go to File\New…\Project… and Select Windows Service

That will generated code like:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.ServiceProcess;
using System.Text;
namespace WindowsService1
   public partial class Service1 : ServiceBase
      public Service1()    InitializeComponent();    }
protected override void OnStart(string[] args)    {   }
protected override void OnStop()    {   }

c) Add a reference to the Remoting Assemblies: System.Runtime.Remoting;

d) Modify the previous code:

Add two using statements like:

using System.Runtime.Remoting.Channels.Http;
using System.Runtime.Remoting.Channels;
using System.Runtime.Remoting;

Add a simple event log for tracing:


private static EventLog evt = new EventLog(“Application”);
private static string SVC_NAME = “ActiveX Server Example Svc”;

 And modify the OnStart and OnStop methods to look like:

  protected override void OnStart(string[] args)
    HttpChannel chnl = new HttpChannel(1234);
ChannelServices.RegisterChannel(chnl,true );
RemotingConfiguration.RegisterWellKnownServiceType(typeof(MyClass), “MyClass.soap”, WellKnownObjectMode.Singleton);
   evt.WriteEntry(SVC_NAME + ” Started”);


protected override void OnStop() { evt.WriteEntry(SVC_NAME +” Stoppped”); }

Also make sure that MyClass extends MarshalByRefClass

2. Convert those ActiveX-Exes using the Artinsoft ActiveX migration helpers.

 Sometimes, you need your migrated application to replicate some of the original ActiveX EXE \OLE DLL VB6 characteristics. For example you need your ActiveX-EXE to start just when the first instance is created and to resemble the VB6 logic for Process creation\destruction.

For that purpose Artinsoft has created some helpers that our migration tool is able to automatically use in the generated code if it detects that this functionality is needed.

The code will then be changed from:

Dim myInstance As New MyProject.MyClass

To the following Helper method:

myInstance = MyProjectFactory.Create< MyProject.MyClass>(myInstance);

 And destroy calls can be changed to the following Helper method:

 myInstance= MyProjectFactory.Dispose<MyProject.MyClass >( myInstance); 

The migration tool will modify your ActiveX-EXEs or OLE Servers to be Windows EXE and the helper will then locate the assembly that contains the desired Class, create an instance and initilize a Remoting channel to the desired classes. Settings as SingleUse and MultiUse are also taken care by the helpers.

3. Other possible alternatives are using WFC and COM+ that I will comment in another post.





Return argument has an invalid type

10. December 2009 07:39 by Mrojas in General  //  Tags: , , , , ,   //   Comments (0)

When you develop applications with remoting, or in some COM + Remoting scenarios, you could start founding very interesting exceptions.

We had a very unconfortable one. We had an ActiveX that is used in an intranet Web Page, that uses remoting to instanciate some classes in the local network.

When we runned outside of the IE, everything seem to work, but running in IE it produced an exception like:

Error : Return argument has an invalid type.
Type  : System.InvalidCastException
Source: mscorlib
Source: at System.Runtime.Remoting.Proxies.RealProxy.ValidateReturnArg(Object arg, Type paramType)
at System.Runtime.Remoting.Proxies.RealProxy.PropagateOutParameters(IMessage msg, Object[] outArgs, Object returnValue)
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

Why??? Well what happens is simple, it is having an assembly resolution problem, it is not being able to resolve the type.

We solve the problem adding something like:

1. Find a place in your code to add an event like this (it could be in the Main of your program for example):

AppDomain.CurrentDomain.AssemblyResolve += new ResolveEventHandler(CurrentDomain_AssemblyResolve);
2. Add a handler like this: 

static System.Reflection.Assembly CurrentDomain_AssemblyResolve(object sender, ResolveEventArgs args)
System.Reflection.Assembly assembly = null; 
assembly = System.Reflection.Assembly.Load(new System.Reflection.AssemblyName(args.Name));
   catch (Exception ex)
            string.Format(“Problem with resolution of {0} : {1} {2}”, args.Name, ex.Message, ex.StackTrace));
   return assembly;

Well, this worked for us, and I hope that helps you out.


Code compiles but System.IO.FileNotFound Exception is thrown

2. October 2009 10:04 by Mrojas in General  //  Tags: , , , , , , ,   //   Comments (0)

We have seen a situation that can be a little annoying.
I usually find that situation in ASP.NET projects, but it can also happen in Winforms.

The issue is like this:

  • You have a VStudio Solution
  • You have added all the needed references
  • All your code compiles



When you run the application it terminates at a certain point with a
FileNotFound exception indicating that the assembly blablabla  or one of its
dependencies could not be loaded.


Whats hapenning!!!

Do this:

1) Look at the bin\debug or bin\release and make sure that the assembly is in those directories.

2) If the assembly is not there, then go to the project references in the solution explorer, right click and select properties and set the Copy Local Setting



Mapping VBRUN.RasterOpConstants

1. October 2009 05:44 by Mrojas in General  //  Tags: , , , , ,   //   Comments (0)


vb Constant Decimal Value Hex Value .NET
vbDstInvert 5570569 H550009
vbMergeCopy 12583114 HC000CA
vbMergePaint 12255782 HBB0226
vbNotSrcCopy 3342344 H330008
vbNotSrcErase 1114278 H1100A6
vbPatCopy 15728673 HF00021
vbPatInvert 5898313 H5A0049
vbPatPaint 16452105 HFB0A09
vbSrcAnd 8913094 H8800C6
vbSrcCopy 13369376 HCC0020
vbSrcErase 4457256 H440328
vbSrcInvert 6684742 H660046
vbSrcPaint 15597702 HEE0086

IE Explorer and Favorites folder or Special Folders in general

29. September 2009 04:05 by Mrojas in General  //  Tags: , , , , , ,   //   Comments (0)

I found this email in my inbox today:

Hi Mauricio,I came across a reference to your blog at :

I have been studying your writings on extending the WebBrowser control, and verified that the extended web code you wrote for C# compiles and works fine in VS 2010 beta, against FrameWork 4.0.

Many thanks for the valuble code and writing !

I am "stuck" on how to read the contents of an IE browser page when the page is displaying a local file, like the contents of the Favorites folder.

All my attempts to get at the Document or DomDocument by casting it to the usual mshtml.dll interfaces fail.

I am NOT asking you to answer my question, or respond, but if you ever get interested in blogging about this aspect of use of IE, I think many people would be interested.

I have done a lot of research on the net, and posted my own question on StackOverFlow : so far not one real pointer, and, possibly, this is not "doable" (?) : maybe what you are seeing when IE shows a file contents is a kind of "virtual explorer" view that is not parseable.

best, Bill xxxxxx”

And I decided to take at look at it to see if I could be of any help and I found out that it is easy and doable.

So I find an useful link by Andreas M. if you want to look at it.

In general My Favorites, Desktop, etc are special folder. So they need a trick to be able to access them.



Take the code from my ExtendedWebBrowser sample published in

and and

1. Add a reference to %windir%\system32\shell32.dll

2. Add a new property to the ExtendedWebBrowser like:

    /// <summary>
    /// Returns the shell folderview object displayed in the webbrowser control.
    /// </summary>
    public Shell32.IShellFolderViewDual2 FolderView
            return ((SHDocVw.WebBrowser)base.ActiveXInstance).Document
                     as Shell32.IShellFolderViewDual2;

And now you can access the special folder from your code. As Bill mentioned, that “page” or “special page” is not real HTML and not parseable but you can examine its contents for example you can do something like:

        /// <summary>
        /// Button 1_ click
        /// </summary>
        private void button1_Click(object sender, EventArgs e)
            Shell32.IShellFolderViewDual2 specialFolder = this.extendedWebBrowser1.FolderView;
            string folderName = specialFolder.Folder.Title;
            string parentFolder = specialFolder.Folder.ParentFolder.Title;
            foreach (Shell32.ShellFolderItem f in specialFolder.Folder.Items())
                if (f.IsFolder)
                    System.Diagnostics.Debug.WriteLine("Folder:" + f.Name);
                    System.Diagnostics.Debug.WriteLine("File:" + f.Name);
            } // foreach
        } // button1_Click(sender, e)

Using Custom Maps in the VBUC to change class names

28. September 2009 10:28 by Mrojas in General  //  Tags:   //   Comments (0)

The VBUC has a now a nice feature called CustomMaps.This feature allow the users to perform basic customizations in the way the target code is generated.

During migration the VBUC can perform some name changes due to the Keyword restrictions in .NET.

For example  VB.NET the some of the following keywords that cannot be used as class or variable names:

Interface, Alias, And, Class, Error, Friend, Loop, MyBase, MyClass, Shared, Property

See here for a list of all VB.Net keywords.

1. Open the Artinsoft VBUC


2.  Go to the Tools Menu\Custom Maps Editor


The Custom Maps Editor dialog will show up.


3.  In the Custom Maps Editor select New...



4.  Type a name and description for your custom map.


5. Create some Custom Maps lines.

Follow these steps:

a. First type a new SourceName. The source name is used by the VBUC to identify the element that you want to map.
NOTE: If you are migrating just one Project, you just enter one custom maps line with the the source name of the class you want to rename. If your are migrating several project you must enter an additional line like <ProjectName>.<ClassName> for example Project1.Interface that is because for other projects that have Project1 as a Reference they see that class as Project1.Interface and not just Interface.



b. Set the Map Type. For classes we call it a Type Map. For Functions, Subs or Properties we call it a member map.



c. We now change the New Reference Name. For a class we call a “Reference Name” to every time a the class is used to define a variable. For example each Dim x as Class1, or every appearance as a parameter, like Sub Foo(x as Class1).


d. We set the Reference Action to Modify.



e. And we set the NewDeclarationName to InterfaceClass and the DeclarationAction to Modify



f.  To make sure that Keyword renamed declarations are mapped with your custom maps configuration, you have to add a line just the same as the one you had just entered but type Interface_Renamed in the SourceName



6. Now you have to activate it in your profile. Click on the Edit button for profiles in the main VBUC window



7. If you don’t have a Profile now, In the Profile Maintenance Dialog click New, and type a name for your Profile.



8. In your profile Select the custom maps configuration you just created:


9. Now Upgrade all your code.

VB6 Declarations like:


will be migrated as:

Option Strict Off
Option Explicit On
Imports System
Friend Partial Class Form1
    Inherits System.Windows.Forms.Form
    'UPGRADE_WARNING: (2080) Form_Load event was upgraded to Form_Load event and has a new behavior. More Information:
    Private Sub Form1_Load(ByVal eventSender As Object, ByVal eventArgs As EventArgs) Handles MyBase.Load
        Dim y As InterfaceClass
    End Sub
    Sub Foo(ByRef x As InterfaceClass) 

    End Sub
End Class

And the class definition to:

Option Strict Off 
Option Explicit On 
Imports System 
Friend Class InterfaceClass 
End Class

Extended WebBrowser Control Series: WPF WebBrowser and the NewWindow2

To be able to catch popup windows and open them in your own window you
have to manage WebBrowser events like NewWindow2.

But how do you do that in WPF?

Well it isn’t really that difficult. These are the steps that you have to follow:

1. Add a COM reference to a reference to %windir%\system32\shdocvw.dll

2. Add a new CodeFile to your project. Lets say CodeFile1.cs And put this code:

using System;
using System.Runtime.InteropServices;
[ComImport, InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
internal interface IServiceProvider

[return: MarshalAs(UnmanagedType.IUnknown)] 

object QueryService(ref Guid guidService, ref Guid riid);


3. To make an easy example. Lets assume we have a very simple window like:


And in that form we need some code like this:

        private void button1_Click(object sender, RoutedEventArgs e)
            Guid SID_SWebBrowserApp = 
new Guid("0002DF05-0000-0000-C000-000000000046"); IServiceProvider serviceProvider =
(IServiceProvider)myWebBrowser.Document; //<—It seams that you need to
// navigate first to initialize this Guid serviceGuid = SID_SWebBrowserApp; Guid iid = typeof(SHDocVw.IWebBrowser2).GUID; //Here we will get a reference to the IWebBrowser2 interface SHDocVw.IWebBrowser2 myWebBrowser2 =
serviceProvider.QueryService(ref serviceGuid, ref iid);
            //To hook events we just need to do these casts
            SHDocVw.DWebBrowserEvents_Event wbEvents = 
(SHDocVw.DWebBrowserEvents_Event)myWebBrowser2; SHDocVw.DWebBrowserEvents2_Event wbEvents2 =
            //Adding event handlers is now very simple
            wbEvents.NewWindow += 
new SHDocVw.DWebBrowserEvents_NewWindowEventHandler(wbEvents_NewWindow);
            wbEvents2.NewWindow2 += 
new SHDocVw.DWebBrowserEvents2_NewWindow2EventHandler(wbEvents2_NewWindow2); } void wbEvents2_NewWindow2(ref object ppDisp, ref bool Cancel) { //If you want make popup windows to open in your own window
// you need to assign the ppDisp to the .Application of
// the WebBrowser in your window
            Window1 wnd = new Window1();
//Just navigate to make sure .Document is initilialized wnd.myWebBrowser.Navigate(new Uri("about:blank"));
Guid SID_SWebBrowserApp = new Guid("0002DF05-0000-0000-C000-000000000046"); IServiceProvider serviceProvider = (IServiceProvider)wnd.myWebBrowser.Document; Guid serviceGuid = SID_SWebBrowserApp; Guid iid = typeof(SHDocVw.IWebBrowser2).GUID; SHDocVw.IWebBrowser2 myWebBrowser2 = (SHDocVw.IWebBrowser2)serviceProvider.QueryService(ref serviceGuid, ref iid); ppDisp = myWebBrowser2.Application; } void wbEvents_NewWindow(string URL, int Flags, string TargetFrameName, ref object PostData, string Headers, ref bool Processed) { MessageBox.Show(URL); } private void button2_Click(object sender, RoutedEventArgs e) { myWebBrowser.Navigate(new Uri("file://D:/MyProjects/ExtendedBrowserExample_v2/test0.htm")); }

Now you can manage your popupwindows:


You can download the test application from HERE

Continuous Migration with VBUC and MS Team System 2005

22. September 2009 09:59 by Mrojas in General  //  Tags:   //   Comments (0)



Performing Continuous Migration with the Artinsoft VBUC and MS Team System 2005 is simple.

The 4 main tasks are:

1. Configure The Microsoft Visual Studio 2005 to use your desired Team System Project.
          For details…

2. Upload an initial version of your VB6 code to the Source Control system. For details…

          Perform an initial migration an establish a baseline. For details…

3. After that you are all set and you can start doing incremental migration.
          For details and an example of continuos migration…

Continuous Migration VBUC-MS Team System 2005: Start up

22. September 2009 09:45 by Mrojas in General  //  Tags:   //   Comments (0)

Make an initial migration of the VB6 source code

1. Open the VBUC


2. Create a Migration Solution for your code (for example C:\MergeExample\Sample1)


3.  Upgrade your code

4. Open the Explorer and navigate to the location of your VB6 code (For example C:\MergeExample\Sample1)

5. Under the directory where your code is located, create a new directory called GreenCode (For our example this directory will be C:\MergeExample\Sample1\GreenCode )

6. Copy your migrated code to GreenCode (for our example it means copying the contents of C:\MergeExample\Sample1\VB6_UpgradedCode to the C:\MergeExample\Sample1\GreenCode).
All this is important to helps us stablish a base line for comparison and merge

7. Open Microsoft Visual Studio 2005

8. On the Team Explorer locate your project (for example MergeExample) and double click on SourceControl

9. On the Source Control Explorer toolbar click the Add Files button


10. Click the Add Folder… button and select the GreenCode folder we had just created


11. Check in the GreenCode. IMPORTANT. Add a descriptive Comment. We recommed at least setting this information:

  • Green Code Date
  • VB6 Source Code Date/ version
  • VBUC version used to generate the Green Code


    12. Create a brach of the Green Code


    Create a Branch of the GreenCode directory and call it MigratedCode.
    For example in the target field type: $/MergeExample/Sample1/MigratedCode


    After branching you will node a MigratedCode folder under Sample1 in the Source Control Explorer


    >Performing Manual Changes in your migrated code







    Now you are ready to perform manual changes in your branch.

  • Check out for Edit the MigratedCode folder

  • Modify code

        Private Sub Command1_Click(ByVal eventSender As Object, ByVal eventArgs As EventArgs) Handles Command1.Click
            MessageBox.Show("Command1 was clicked", Application.ProductName)
        End Sub 


        Private Sub Command1_Click(ByVal eventSender As Object, ByVal eventArgs As EventArgs) Handles Command1.Click
            //mrojas simple change for message box
            MessageBox.Show("Command1 was clicked", Application.ProductName,MessageBoxButtons.YesNo)
        End Sub 



    Check In of your changes

    Changing the VB6 Source Code

    If you have changes in your VB6 source code and you want to feed those changes to the ongoing migration, follow these steps.

    1. Check out the VB6 source code


    2. Overwrite your all sources with the new VB6 source code, or your modify the current version.

    For these example we will modify the current version, by adding a new button


    and adding some comments to our previous code. So now the VB6 code will be:

    Private Sub Command1_Click()
        'This is a sample comment for command1 code
        MsgBox "Command1 was clicked"
    End Sub
    Private Sub Command2_Click()
        'This is a sample comment for command1 code
        MsgBox "Command2 was clicked"
    End Sub
    Private Sub Command3_Click()
        MsgBox "The newly added Command3 was clicked"
    End Sub

    And after the changes we check in it back.


    Adding a new comment to identify this version



    Performing the Continuous Migration Process

    1. Check out the green code


    2. Open the VBUC and migrated again the VB6 Code. In our example the code is in C:\MergeExample\Sample1\VB6

    3. Copy the new contents of the Upgraded folder and overwrite the contents of folder GreenCode (in this case copy contents from C:\MergeExample\Sample1\VB6_UpgradedCode\Upgraded to C:\MergeExample\Sample1\GreenCode).

    4. Check in the Green Code


  • Add a descriptive comment like:
    Green Code 22-09-2009 12:34pm
    VB6 Source Code 22-09-2009 12:00pm / version 2
    VBUC version 3.0

    Now merge with current manual changes

    After migrating the modified VB6 source code and checked in it in the Source Control we now have to merge the changes between the new GreenCode and our MigratedCode.

    1. Right click on the GreenCode folder and select merge. Put attention to chech that you want to merge the “Selected ChangeSets” and that the target branch is the MigratedCode


    Click Next

    2. Select the Change sets that you will apply. The comment you use provide a guide to identify which changeset you need.


    Click Next

    3. Click Finish to perform the Merge


    4. During merge conflict might arrise. A resolve conflicts dialog will appear. Clicking the resolve conflicts button will provide different options…


    5. In our example we know that we modified the Form1.vb file so we select the “Merge changes in merge tool” option

    TIP: Typically you will just keep changes in target branch because you have already worked on those files. Specially for resource files, project files, bitmaps, etc you will leave the file in the target branch.


    6. The merge tool will appear showing the different changes and providing you a simple way to select what version to take or to manually edit the result


    7. When you are done with the Merge tool click close a dialog indicating that all conflicts have been solved will appear. Click Yes


    8. Click close in the Resolve Conflict dialog and if asked to accept the merge result click yes


    The Source Control Explorer might show marks in the modified files.


    9. Right click on the migrated code and select check in changes


    10. Type an appropiate comment indicating which versions where merged and press Check In



    And that’s all



  • Continuous Migration VBUC-MS Team System 2005:Upload an initial version of your VB6 code

    22. September 2009 09:34 by Mrojas in   //  Tags: , , , , ,   //   Comments (0)

    Now all we need to do is setup the VB6 code that we will use for migration. To do that follow these steps:

    1. On the Source Code Explorer toolback click on the Add Files button:




    2. Click the Add Folder button and select the folder with your VB6 files


    3. After you select the folder, a list of files found will be shown. Just remove any unneccesary files. For example files like MSSCCPRJ.SCC should be removed. And press OK


    Now you have to commit your code the Source Code Repository

    4. On the Source code Explorer Right click on Source Control Folder (for this example is MergeExample) and select Check In Pending Changes..


    5. Write an apropiate comment and press Check In

    Creating a new Team System Project in Visual Studio 2005

    22. September 2009 09:31 by Mrojas in General  //  Tags: , , , , , ,   //   Comments (0)


    To create a new Team System Project in Visual Studio 2005, follow these steps:

    1. Go to the File Menu. Select New…, and in the New… submenu select Team Project… to start a wizard.


    2. The “Specify the Team Project Settings” of the New Team Project wizard appears. Type the Team Project name. For example type MergeExample and click Next


    3. In the following page, select the Process Template for the Team Project. We recommend using the Artinsoft Migration Methodology – v0.8 or later. Click Next.


    4.  In the following page, type the Title for the Team Project Portal. Type MergeExample. The Team Project Portal provides useful information about your project. Click Next


    5. In the following page you select your source control settings.
    Select the first option “Create an empty source control folder”. Click Next


    6. In the following page a summary of your Team Project settings is presented. Click Finish


    7. In the following page the a process bar appears while the project is created. Just wait until the process is done. It normally takes between 3 and 5 minutes.


    Continuous Migration VBUC-MS Team System 2005: Configure MS Visual Studio 2005 to use Team System

    22. September 2009 08:57 by Mrojas in General  //  Tags: , , , , , , ,   //   Comments (0)

    This post will show you the necessary steps to configure Microsoft Visual Studio 2005 to use a Team System Project. In this example we will use a Team Project created to illustrate Continuous Migration with VBUC and MS Team System 2005, called MergeExample.

    1. Start Microsoft Visual Studio 2005

    2.  Go to the File Menu\Open\Team Project…


    3. Dialog is presented, where you can choose your Team Foundation Server, and the Team Project to use. For these Continuous Migration example we’ll assume a project called MergeExample.


    4. The Team Explorer is shown, with your selected project.
    Expand the elements for the Team Project you previously selected.


    5.  We now have to map our local directories to bind them to the
    source control system. On the expanded tree, double click on the
    Source Control Node


    6. The Source Code Explorer is shown:


    7.  Go to the Workspaces dropdown box and select Workspaces…


    8.  The Manage workspace dialog is shown.
    Select the appropiate workspace and click Edit…


    9. On the Edit Workspace dialog type a description for your source control and select the source control Folder we had created (for this example it is $/MergeExample) and the directory for your code (for this example it is C:\MergeExample).







    NOTE: if a message box about a pending update is shown, just click ok.


    Now you have successfully mapped your directories, and you can start setting up your VB6 code for continuous migration

    Getting the Screen Coordinates of a Cell in a DataGridView

    16. September 2009 05:23 by Mrojas in General  //  Tags:   //   Comments (0)

    Well, this is actually quite easy.

    To get the X and Y of a Cell you just need to do something like:


    or for the selected cell use:



    And to convert that to screen coordinates do:



    mmm Well I found that

    grid.GetCellDisplayRectangle(columnIndex, rowIndex, false) is a better alternative, because it will give you the Rectangle for the whole Cell

    Where is my DXCore

    19. August 2009 05:06 by Mrojas in General  //  Tags: , , , ,   //   Comments (0)

    I’m an enthusiastic user of DXCore and I have been working on some extensions of my own. But I could not find the DXCore or DevExpress menu.

    Well there is a hack for that.

    Please invoke the Registry editor, add the "HideMenu" DWORD value to the following Registry key, and set its Value to 0:
    HKEY_LOCAL_MACHINE\SOFTWARE\Developer Express\CodeRush for VS\9.1
    This should make the "DevExpress" menu visible.

    Look at the post for more details and keep enjoying DXCore.