Well what you said is actually correct.
I should use more than one instance of it then.
There is only one thing, I'm connecting to the database in each instance so as more instances as lower the performance will be.
Also, more than one instance managing the same table may cause some problems...
I'm implementing in a class, methods to manage a simple database.
This class will perform all the tasks related with database and will return results in simple structures to the other classes.
Remark: My Class was designed to deal with a single Table at once, so it is using internal variables to...
Hmm seems good..
But now I want to add a serial port handler inside this class and an event.
I will create a New serial port and then I will put inside this class the event handler for incoming data.
This event handler will rise another event like DataReceived() that will be declared inside...
How to share an instance of a class to all the application in VB.NET ?
Probably you are going to answer: "Use Shared members"
Ok, but I have one particular problem:
I have an application that has multiple forms.
The application is connected through the serial port to a hardware.
Well, it seems that the best approach is to use date and time in records and maybe also a Timer to check them and eventually inform user about changes.
Of course that this is my opinion for my application...
But it seems that we have not too much options also so the Date and Time in record...
ok, my bad... I understood now.
Just two more questions... before looking at internet examples...
Imagine that I hired you to develop a very simple database with one table but a lot of users, what strategy you would take to treat the collisions or avoid them, and also keep the system updated...
Thanks jmcilhinney for your clear explanation.
I just have one doubt.
The "Pessimistic concurrency" is the default according to your explanation, but I can't see it happening in my code.
When I update my local dataset it should be locked for other users right ?
I understood that when I start...
I'm a beginner in databases, and I'm developing a simple application.
I'm using SQL Server in my shared server to hold all the database.
Database is accessed by client app using an internet connection.
My client application is for Windows Forms developed in VB.NET using ADO.NET.
Yes, that should work.
But I also would like to know if there is another way to avoid this code.
Since every form is a class it should be possible to pass the class name as a parameter of function.
The enum makes you need to add every form.
But I'm thinking in a "smarter" way than enum...
In .NET CF there is no MDI form.
Tabs are not ideal for that kind of application.
Some forms have no relation with others so arranging in tabs would be weird...
Also they are already designed.
Must have some way to manage them with a sub in Main.vb.
I'm just with some problems to pass the right...
Well, my idea is not showDialog and return to the same form.
Think this way:
I have 40 forms in my application.
For example, I will start application then load a form called frmMenu.
This form can call frmSettings, frmHelp or frmNew.
All of those other forms can create another forms too.
I'm using .NET compact framework and I want to do a function or sub to manage the forms of my application.
The idea is to replace, for example, the code below:
FormA.Enabled = False
frmWait.TopMost = True
Dim f as new FormB
f.TopMost = True...