Select multiple table
Would someone be so kind to help me to open and work 5 tables from SQl server in vb.net simulatenously.
i.e. first open the first table, secondly open the second table where one of the first table's field matching and so on.
Retrieving data from five tables is just retrieving data from one table five times. If there is something more specific about your situation that makes it different then I'm all ears but basically you just need to create five adapters and populate five DataTables. I'd suggest that you follow the Data Walkthroughs link in my signature and learn the basic concepts of ADO.NET first. You should then be able to apply those concepts to your scenario. If you need more specific help once you've done that then show us what you've done and tell specifically where you're having trouble.