cycles to read lines in sql and c#

Question

hello all

 

I have a search button where I have the following query

 

select A.BELNR_ID,A.BELPOS_ID,A.ItemCode,A.ItemName,A.MENGE,B.SalPackUn,B.PicturName from BEAS_FTPOS A
Inner Join OITM B on A.ItemCode = B.ItemCode
where A.BELNR_ID = '@ORDENDEPRODUCCION'

 

which requires loading a label with information from my office.

but sometimes my production order me back several lines of data

 

BELNR_ID	BELPOS_ID	ItemCode	ItemName	MENGE
10290	10	809133SA3B-A	LH POCKET BACK COVER FR PG05	100
10290	20	809123SA3B-A	RH POCKET BACK COVER FR PG05	100
10290	30	829123SA3B-A	RH POCKET BACK COVER RR PG05	100
10290	40	829133SA3B-A	LH POCKET BACK COVER RR PG05	100

 

I have 4 rows of labels, my question is how I can do or take to cycle when pressing seek me send this information to the labels that I have separately

EXAMPLE:

label 1	809133SA3B-A	LH POCKET BACK COVER FR PG05	100
label 2	809123SA3B-A	RH POCKET BACK COVER FR PG05	100
label 3	829123SA3B-A	RH POCKET BACK COVER RR PG05	100
label 4	829133SA3B-A	LH POCKET BACK COVER RR PG05	100