i want to give this excel sheet as a input to the purchase order but it has multiple vendors and items so i want to give the value when same vendor id match regarding the action. please share your thoughts. Thanks in advance.
Read this Excel, pass the datatable as argument loop through each row(for each row) check the value if(VendorID==‘Your variable/Constant’) then continue the process else part will be empty.
thanks for your reply. I want to group the data with respectively vendorID and action because i need to give this grouped data to the various Purchase order input like creating, updating.
Use select statement or use filterdata table and pass the result as a argument
(DataTableName).Select(“convert([VendorID], ‘System.String’) = '” + (Variable.ToString/Constant.ToString) +"’