donato1026

but the I only want to use the order number, first name, last name et cetera to show up ONCE in the "HeaderPanel"

Besides using distinct，you can also use DataView.ToTable's 3rd function with a string[]，this will filter duplicated issues……

using(SqlDataAdapter adapter = new SqlDataAdapter("select * ……","conn str"))
{
    DataTable dt = new DataTable();
    adapter.Fill(dt);
    DataView dv = new DataView(dt);
    dt = dv.ToTable(true,"field1","field2",……,"fieldN");
}