Extract first occurence Select

Help
1

Hello friends,
@rkelchuri, @Ninett_Panfir, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, @Palaniyappan, @loginerror, @MAHESH1

How is it possible to extract the first occurence of this query
Tabella_Richieste_da_aggiornare.Rows.IndexOf(Tabella_Richieste_da_aggiornare.Select(“[Fornitore]='”+Codice_JDE+“'”)(0)).ToString
in case of multiple occurences?
Thank you,
Cami

2

Use like this in a loop.

Tabella_Richieste_da_aggiornare.Rows.IndexOf(Tabella_Richieste_da_aggiornare.Select(“[Fornitore]=’”+Codice_JDE+“’”)(i)).ToString

Assign i =i+1 inside loop.

3

Hmm
I hope this would work
Were we facing any issue in this expression
Cheers @CamiCat

4

@CamiCat

Try below query

ListA=(From p In dta.Select
         Group p By ID=String.Join(",",p.ItemArray) Into GroupA= Group
         Select Convert.ToString(dta.Rows.IndexOf(GroupA(0)))).ToList

ListA will Contain the Index of First Occurence of all the row Rows.

Regards,
Mahesh

5

Thank you so much @MAHESH1,

i’ll try and let you know as soon as possible.
Cami :slight_smile: