Select ONE record with details from that record...

Hello,

I am trying to select an order from the database and then get that order's details. I have a table with all the orders (order #) in it and there is one row/record per order. THen I have another table I am joining to, bu order #, with the order's details. I want to use that with a CollapsablePanel extender, by showing the details when you click on that record. The problem is: when I do the join, I obviously get a bunch of records that come back, but the I only want to use the order number, first name, last name et cetera to show up ONCE in the "HeaderPanel" of the collapsable extender. HOw would I go about doing something like this?

Re: Select ONE record with details from that record...

For the fields that you only want to appear once, use the data from the first row of your query results.

Re: Select ONE record with details from that record...

use "Distinct" word in your sql query and see if that helps...

select distinct OrderNumber, FirstName, LastName...

Re: Select ONE record with details from that record...

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 distinctyou 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");
}