C#

SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
where b.TransactionDate BETWEEN ({?DATE}) AND ({?DATE2})
GROUP BY a.Category,a.[Transaction];

[Guid("47C976E0-C208-4740-AC42-41212D3C34F0"),
InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface MyCom_Events
{
   // [DispID(1)]
    void OK();
}


[Guid("368C19C3-A726-49b5-A2D8-482680ADDA1D")]
public interface IMyCom
{
    int Add(int a, int b);
    void OnOK();
}
[Guid("498627AF-BCD0-4a1f-95E4-739953847B60"),
ClassInterface(ClassInterfaceType.None),
ProgId("Test.MyCom"),
ComSourceInterfaces(typeof(MyCom_Events))]
public class MyCom : IMyCom
{
    #region IMyCom Members

    public int Add(int a, int b)
    {
        return a + b;
    }

    public void OnOK()
    {
        if (OK != null)
            OK();
    }

    public delegate void OKHander();

    public event OKHander OK;

    #endregion
}

CoInitialize(NULL);//NULL换成0也可以
            cscomtest::IMyComPtr pIMyCom(__uuidof(cscomtest::MyCom));
            cout<<"out:"<<pIMyCom->Add(1,2)<<endl;
                            //How to attach a method？？？？？
pIMyCom->OnOK();
            CoUninitialize();