Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Data access questions

Hi Guys,

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
[1342 byte] By [ahassan99] at [2007-11-11 11:59:11]
# 1 Re: Data access questions
An update for question number 2. I am doing the Insert,Update,Delete operations using SQL commands.
ahassan99 at 2007-11-11 20:42:22 >
# 2 Re: Data access questions
How do you refresh the dataset?
Hack at 2007-11-11 20:43:28 >