How to execute gp.execute ArcSDE tool in C#

Question

So I created an ArcGIS 10 toolbox in ArcSDE and added a tool to it. There are enough examples out there on how to execute a tool.tbx that resides outside SDE or GeoDB. But in C#, how do you use gp.execute on a tool that resides within ArcSDE? thanks!

Answer 1

Try using the IToolboxWorkspace interface. Code below works for a file gdb workspace, I'd imagine it would work for arcsde too.

private static void ListToolboxes(IWorkspace ws)
{
    var tbxWkspc = ws as ESRI.ArcGIS.Geoprocessing.IToolboxWorkspace;
    if (tbxWkspc == null)
    {
        Console.WriteLine("not a toolbox workspace");
        return;
    }
    var toolboxes  = tbxWkspc.Toolboxes;
    toolboxes.Reset();
    IGPToolbox tbx;
    while ((tbx = toolboxes.Next()) != null)
    {
        var tools = tbx.Tools;
        tools.Reset();
        IGPTool tool;
        while ((tool = tools.Next()) != null)
        {
            // you could execute here ...
            //tool.Execute
            Console.WriteLine("{0}: {1}", tbx.PathName, tool.Name);
        }
    }            
}