Can 1 dataadapter connection to 2 or more data table

[fung1223]

Thank you for your reply.
But there is still a problem. Where I use your method, it required me to supply a selectcommand(e.g SELECT * FROM .....) but I have mulit table in the data adapter. How to write a selectcommand with multi table? Thank you.