I have a datatable that looks like the screenshot below, Now there is a column called SerialNumber which might have a blank cell.
What I am supposed to do is update this blank cell with its actual data by searching for ID from a table on a database.
I know I can open a connection ,start a for each and run a query to "select SerialNumber Where ID = ". But then the problem is this records might be a lot in the future and would slow down the process .
Please is there a faster way