Data access questions
I have another couple of questions:
1. I have got a dataset,dbconnection and a data adapter which I set manually during design. Those connect to an access db at the back-end.
I am accessing the database in 2 different forms. How can I access the same dataadapter,dbconnection and the dataset from both forms, so that when I change something in one form, it gets reflected in the other immediately ?!
2. With the current setup of those connection,data adapter and dataset, whenever I do any change to the database i.e. Add,Update,Delete. I can see the reflected changes unless I close and open the software. I tried to fill the dataset after every one of those operations, but it didn't work :confused:
2. In fact, the software I am doing is about shipping containers. Another big problem I am facing is that I need to maintain different set of recrods for different containers. How do you think I can do that ?!! :confused: I was thinking of creating different tables in the same database for individual containers ?!! and access them through the same front-end forms. But I still don't know how to go about it !!! :(
I am sorry if I had put a lot of questions, but I am a beginner in VB.Net. I really expect and will appreciate your help guys.
Thanks and Regards

