The following query meets your requirement
UPDATE t1
SET t1.Column1 = t2.Column2, t2.Column3 = t1.Column4
FROM Table1 AS t1
INNER JOIN Table2 AS t2
ON t1.CommonField = t2.[Common Field]
WHERE t1.BatchNo = '110';
You can use the above query in vb.net and update the two tables with a single query.
Hope this helps.
Submit an article or tip