How To Display Two Row of Database in single row in Gridview

Feb 26 2013 1:09 AM

how to show two rows data (sqlserver) with some matching column fields in gridview single row . but show only matching row with 2-2 group if 1 record left then not show