C#

<?xml version="1.0" encoding="utf-8" ?>
<Data>
  <Movie>
    <ChineseName>aa</ChineseName>
    <EnglishName>aa</EnglishName>
    <Year>aa</Year>
    <Area>aa</Area>
    <Type>aa</Type>
    <Language>aa</Language>
    <Subtitle>aa</Subtitle>
    <IMDB>aa</IMDB>
    <Resolution>aa</Resolution>
    <Director>aa</Director>
    <Actors>aa</Actors>
    <Introduction>aa</Introduction>
    <BelongTo>aa</BelongTo>
    <DiscNumber>aa</DiscNumber>
  </Movie>
</Data>

//clsXmlHandler is a class to read the xml data
ClassXMLHandler clsXmlHandler = new ClassXMLHandler();
string strMovieData = "Data";
XmlNode xNodeMovieData = clsXmlHandler.MovieDataDocument.SelectSingleNode(strMovieData);
XmlNodeReader xReader = new XmlNodeReader(xNodeMovieData);

DataTable dtMovieData = new DataTable();
dtMovieData.ReadXml(xReader);

DataSet ds = new DataSet();
ds.ReadXml(xReader);

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