C#

public DataSet ExecuteQueryProc(string sParameterName, SqlParameter[] ParamArray)
{
    DataSet oDataSet = new DataSet();

    SqlConnection oConn = GetConnection(true);

    if (oConn != null)
    {
        SqlCommand oCommand = new SqlCommand();
        oCommand.Connection = oConn;
        oCommand.CommandText = sParameterName;
        oCommand.CommandType = CommandType.StoredProcedure;

        oCommand.Parameters.AddRange(ParamArray);

        SqlDataAdapter oAdapter = new SqlDataAdapter();
        oAdapter.SelectCommand = oCommand;
        oAdapter.Fill(oDataSet);

    }
    return oDataSet;
}

>

Thread[] threads = new Thread[numthreads];
for (int i = 0; i < this.threads.Length; i++)
{
threads[i] = new Thread(Handler);
threads[i].Start();
}

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";