I have dropped a DevEx MRUEdit control onto a form for the first time.  Cool little control.  I want to fill this thing with a distinct list of part descriptions.  Here is my working code for your review:

private void FillPartDescriptionMRU()
{
    // get the distinct list of part descriptions
    SqlConnection cn = new SqlConnection(MicroFour.StrataFrame.Data.DataLayer.DataSources["Aspire"].ConnectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = cn;
    cmd.CommandType = CommandType.Text;
    ADUserBO mADUser = new ADUserBO();
    SqlParameter pDiv = new SqlParameter("@division", mADUser.LocationIndex);
    cmd.Parameters.Add(pDiv);
    cmd.CommandText = "SELECT DISTINCT partdesc FROM PartsMaster WHERE (divisionindex = @division) AND (inactive = 0) ORDER BY partdesc";
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    sda.Fill(ds);
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        txtPartDesc.Properties.Items.Add((string)dr[0]);
    }
}

Is this the best way to approach a distinct list of strings from my database in order to fill my MRU list?  I do have a PartsBO...is there a way to get these strings from the BO?  Also, the list is filled in descending alphabetical order, even though I have specified an ASC sort in the query.  Is there a reason why my sort is backwards?

Thanks for any help on this!!
Bill