how to show one row where there is 2 row with same id

Question

hi

pls give idea that i selected some field from db i have few rows with same stockcode and i have to show only one in grid

 

my code is

 

string qry = "SELECT T1.SRCode,T1.SRDate,T1.Status,T2.Quantity,T2.Price,T2.NetAmount,T3.ProductCode,T3.ProductName FROM Tbl_ReceiveStock T1 INNER JOIN Tbl_ReceiveStockProducts T2 ON T1.SRId = T2.SRId INNER JOIN Tbl_Product T3 ON T2.ProductId = T3.ProductId ";