C#

public class CustomerIDPair: IComparer<CustomerIDPair>, IComparable<CustomerIDPair>
{
    private string _company_Code = string.Empty;
    private string _customer_Code = string.Empty;

    public CustomerIDPair()
    {
        //
    }

    public CustomerIDPair(string Company_Code, string Customer_Code)
    {
        _company_Code = Company_Code;
        _customer_Code = Customer_Code;
    }

    public string Company_Code
    {
        get { return _company_Code; }
        set { _company_Code = value; }
    }

    public string Customer_Code
    {
        get { return _customer_Code; }
        set { _customer_Code = value; }
    }

    public override string ToString()
    {
        return _company_Code.Trim() + ", " + _customer_Code.Trim();
    }

    #region IComparer<CustomerIDPair> Members

    public int Compare(CustomerIDPair x, CustomerIDPair y)
    {
        string strX = x.Company_Code.Trim().PadLeft(3) + x.Customer_Code.Trim().PadLeft(10);
        string strY = y.Company_Code.Trim().PadLeft(3) + y.Customer_Code.Trim().PadLeft(10);
        return string.Compare(strX, strY, true);
    }

    #endregion

    #region IComparable<CustomerIDPair> Members

    public int CompareTo(CustomerIDPair other)
    {
        string strX = this.Company_Code.Trim().PadLeft(3) + this.Customer_Code.Trim().PadLeft(10);
        string strY = other.Company_Code.Trim().PadLeft(3) + other.Customer_Code.Trim().PadLeft(10);
        return string.Compare(strX, strY, true);
    }

    #endregion
}

CustomerIDPair custID = new CustomerIDPair("EZE","TLC");
int test = BtoA[custId];

var conn = new SqlConnection("Data Source =(local)\\Openhouse;" + ";Initial Catalog=" + _sqlDBName + ";Integrated Security=SSPI");
           conn.Open();
           var dataAdapter = new SqlDataAdapter();
            var command = new SqlCommand(select, conn);
            dataAdapter.SelectCommand= command;

            var conDS = new ContactDs();

            //dataAdapter.Fill(conDS, "Contact");
            SqlCommand sqlcmd = conn.CreateCommand();
            sqlcmd.CommandText = "DELETE FROM Contact WHERE IDNumber != '156' AND Quality = '40'";
            dataAdapter.Fill(conDS, "Contact");
            dataAdapter.DeleteCommand = sqlcmd;
           dataAdapter.Update(conDS, "Contact");

private string select = "SELECT * FROM Contact";