C#

CPallini wrote:

it is Java based

harold aptroot wrote:

It's not that much Java based, it can generate parsers in many languages (including C#)
But you need to have Java installed to run it

Mirko1980 wrote:

Then you can use Activator.CreateInstance to create an object instance from that Type.

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

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;

    }