C#

OleDbCommand cmd = new OleDbCommand(string.Format("Select * from [Sheet1$]");
cmd.Connection = oleDbConnection;
OleDbDataAdapter adpt = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adpt.Fill(ds, "[Sheet1$]");
if (ds.Tables.Count == 1)
{
	dgView.DataSource = ds.Tables[0];
}

BobJanova wrote:

I really don't think it should do that, but that's a separate discussion

public class MyString
{
    private string value;

    public MyString(string value)
    {
        this.value = value;
    }

    public static implicit operator string(MyString myString)
    {
        return myString.value;
    }
    public static implicit operator MyString(string value)
    {
        return new MyString(value);
    }

    public override string ToString()
    {
        return value;
    }
}

MyString one = " ";
MyString two = "2";
MyString three = " ";

listBox.Items.Add(one);
listBox.Items.Add(two);
listBox.Items.Add(three);

using System;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        // listBox added in designer
        // buttonRemove added in designer
        // buttonRemove Click handler added in designer
        public Form1()
        {
            InitializeComponent();
            listBox.Items.Add(new MyString(" "));
            listBox.Items.Add(new MyString("2"));
            listBox.Items.Add(new MyString(" "));
        }

        private void buttonRemove_Click(object sender, EventArgs e)
        {
            if (listBox.SelectedItem != null)
                listBox.Items.Remove(listBox.SelectedItem);
        }
    }
}

public class MyString : IEquatable<MyString>
{
    private string value;

    public MyString(string value)
    {
        this.value = value;
    }

    public static implicit operator MyString(string value)
    {
        return new MyString(value);
    }
    public static implicit operator string(MyString myString)
    {
        return myString.value;
    }
    public static bool operator ==(MyString first, MyString other)
    {
        if (object.ReferenceEquals(first, other))
            return true;
        if (object.ReferenceEquals(null, first) || object.ReferenceEquals(null, other))
            return false;
        return first.value == other.value;
    }
    public static bool operator !=(MyString first, MyString other)
    {
        return !(first == other);
    }

    public override bool Equals(object obj)
    {
        return Equals(obj as MyString);
    }
    public bool Equals(MyString other)
    {
        if (object.ReferenceEquals(null, other))
            return false;
        return value.Equals(other.value);
    }
    public override int GetHashCode()
    {
        return value.GetHashCode();
    }
    public override string ToString()
    {
        return value;
    }
}

public class BaseClass
{
   public BaseClass(string something)
   {
   }
}


public class DerivedClass : BaseClass
{
    public DerivedClass(string something, int other)
            : base(something)
    {
    }
}