Hi,

I have a DataGridView and I want to display all testID's on one row that have the same securityID.

In the database the data is...
testID securityID
id1 56666
id2 56666
id3 56666
id4 56788

So want the output to be...

TESTID SECURITYID
id1,id2,id3____56666
id4__________56788

Do I do this using a Loop? How do I go about it?

Thanks.

Basically I think you'll have to write some SQL that returns what you want, or alternatively create dictionary manually from the SQL yourself. I don't believe there is anything in the DataGridView which is going to allow you to do this easily.

/- Sam Judson : Wrox Technical Editor -/