dt.Select() with numerous variables added

assigning to an array of data row

arr_dtrow = dt_InvoiceSearch.Select(“Invoice Item=”+InvoiceItem+“AND Date=”+InvoiceDate)

keep getting error : assign: syntax error: missing operand after ‘item’ operator.
please help

Hi @Nrenaud1

Arr_dtrow=dt_InvoiceSeArch.Select(“Invoice Item=’”+invoiceitem’"+ And dAte=’"+invoiceDAte+’")

ThAnks

Ashwin S

That is not working still getting compiler errors

Hi @Nrenaud1,

Try like this

arr_dtrow = dt_InvoiceSearch.Select(“[Invoice Item]=’”+InvoiceItem+“’ AND Date=’”+InvoiceDate+"’")

1 Like