C#

DaveKerr wrote:

so as I understand it, I can use Activator.CreateInstance to get the COM object, but I cannot use reflection

using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices;
using System.Runtime.InteropServices.CustomMarshalers;
using System.Reflection;

namespace ComMarshaller
{
  [
  ComImport,
  Guid("00020400-0000-0000-C000-000000000046"),
  InterfaceType(ComInterfaceType.InterfaceIsIUnknown)
  ]
  public interface IDispatch
  {
    void Reserved();
    [PreserveSig]
    int GetTypeInfo(uint nInfo, int lcid,
    [MarshalAs(
    UnmanagedType.CustomMarshaler, MarshalTypeRef = typeof(TypeToTypeInfoMarshaler))]
    out Type typeInfo);
  }

  class Program
  {
    static void Main(string[] args)
    {
      Type type = Type.GetTypeFromProgID("DirControl.DirList.8.0");
      object o = Activator.CreateInstance(type);
      IDispatch disp = o as IDispatch;
      if (disp != null)
      {
        Type tp = null;
        disp.GetTypeInfo(0, 0, out tp);
        MemberInfo[] mi = tp.GetMembers();

        foreach (MemberInfo minfo in mi)
        {
          Console.WriteLine(minfo.Name);
        }
      }

      Console.WriteLine("Done");
      Console.ReadKey();
    }
  }
}

public static DataSet getDataSet(string strFilename)
    {
        
string connstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\excels\" + strFilename + ";";
         connstr += @"Extended Properties=""Excel 12.0;HDR=YES;""";
        OleDbConnection conn = new OleDbConnection(connstr);
        OleDbCommand cmd = new OleDbCommand("sheet1", conn);
        DataSet ds = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        da.Fill(ds);
        da.Dispose();
        conn.Dispose();
        cmd.Dispose();
        return ds;

    }

highton wrote:

I copy an image from Window Explorer, or Desktop

[ 0]=Shell IDList Array
[ 1] DataObjectAttributes
[ 2] FileDrop
[ 3] FileName
[ 4] FileNameW
[ 5] Shell Object Offsets
[ 6] Preferred DropEffect

[ 0]=Embed Source
[ 1] Object Descriptor
[ 2] MetaFilePict
[ 3] DeviceIndependentBitmap