Share Data Tables For All Applications (only One Instance)?
Feb 25, 2012
I have 5 websites running on same server and I have some sql tables that I access frequently. that was time consuming and by defining them shared I pumped them in memory. So my application is accessing those static data tables from memory quite efficiently.
But I realized I did a mistake and I occupied my memory unnecessarily while I keep same tables 5 times for each web application. Now I need to find the best way to share that table only 1 time. my options are;
1) using a local database - sql CE. my original sql database is on other server. so it makes the access slower but I can add a sql CE database(to be honest I never used it and dont know if it gives me anything) to access only these tables while they have static rows.
2) I read over forums that making a WCF using tcp binding. not sure if it will give me any advantage.
3) windows service: is it faster than wcf? programming is defiantly faster as i have experience with winservice but nor sure about performance.
View 2 Replies
ADVERTISEMENT
Feb 14, 2011
I have two VB projects in one VS2010 solution. The first program brings in about 60 integers every few seconds from my PC's serial port. The second program, published via Click-Once and running on my customer's PC, needs to see that new data every two to five seconds.
Is there a simple and reliable way to accomplish this, staying with VB?
View 3 Replies
Jun 25, 2011
I would like to know if it was possible to share data between several assemblies using the same DLL.
I'm not looking for a workaround using memory or disk files of some kind of pipes to do the job I just want to know if and how:
1 - I can run an App. referring to a DLL which contains a given shared data structure.
2 - Run another App. referring to the same DLL that will use the already loaded DLL and data instead of creating a new base instance.
View 3 Replies
Sep 16, 2011
I want to build a main application that make the autentication process and store the loged user... Then use X and Y applications to ask the current user and depends of the user will have full access partial or none access to the app. In future a Z application could be created and will ask for the current user also. XYZ apps are lauched from Main app, when Main app is closed the others are closed and User ID data is cleared. Of course the main app will handle the log on/log off process.
- Store User ID in a Database is toooooo much for just do this
- Save the User ID in a local file like XML is a security problem
I tried to do a WCF Service but i think its not possible to send data and store in it.The other point is who to handle the instantation issue... each program will access to the same static data not create independent.
View 4 Replies
Dec 17, 2009
I have three different web applications that I made in VS08 vb.net. Each application uses a class that i continue to update (MyClass.vb), other than using Vault to propogate changes, is it possible to create a class or dll and put it out on the webserver and have each web app call that class or dll?
View 3 Replies
Oct 19, 2010
just wanted to ask if it is possible to have different applications sharing the same session (i.e. database session)... i'm planning on creating a web-based application and a form-based application using asp.net for web and vb.net for forms but i need to have them share sessions since some global variables will be session based and also authentication to one application should also authenticate on the other.
View 2 Replies
Dec 19, 2009
I'm asking about the best way to get data from SQL Database with less than 1 sec. Really I need to know if iIused LINQ is the faster way or ADO.Net? How can I start with application like CITRIX that will be helpful to share this application after I got data. I mean any example to start create an application to share applications like citrix to share applications?
View 6 Replies
Feb 8, 2012
I am creating a Windows application using VS 2008. This has a MDI Parent form that hosts multiple MDI children forms. I have a login form that authenticates the user and creates an instance of a user class. This has information such as UserID, Name etc. I would like this instance available to other windows. How would I implement this functionality?
View 2 Replies
Jun 8, 2011
Using any version of .NET how do you find out which zone a particular share is classified under. I am having a problem identifying if a share where my referenced dlls reside is in the "intranet zone" or "internet" zone relative to some user machine that is running my .NET application. I suspect this is a problem because I am having a problem accessing referenced dlls from a share on some machines but not others. How can I tell which zone .NET is classifying that share in so I can adjust permissions accordingly?
View 1 Replies
Mar 18, 2010
I am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
View 7 Replies
Jul 25, 2012
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
View 4 Replies
Aug 15, 2011
how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 Replies
Sep 1, 2011
I have no problem doing a select statement from a database and displaying it.An I have no problem inserting data into a sql database table. However with this issue I have to grab the data an insert it into a totally different SQL 2005 instance.
View 8 Replies
Feb 11, 2012
i have a sample code written in VB6 that allows communicating between different application windows and passes data. The link is below:[URL] I wonder how we can do the similar work inside VB.net. I simply claim a method between different applications communicating each other and transmits data. Lately i was using the old code and after my researchs on internet i also found different methods using System.Runtime.Remoting libraries
View 2 Replies
Feb 3, 2009
We are about to have a situation where our application needs to accept/give data to another application. Both applications are residing on the same machine.Two approaches being talked about are using a local web service that will do this or using files that will be used to share all of this data.
View 3 Replies
Jun 15, 2010
I've used mutiple threads in a VB.NET program but I don't know if I did it right.I would like to start about 3 threads.Can they all use the same methods?Will a separate instance of each method automatically be created for each thread?If not, how do you make sure that the data within the method that is used by one thread is not used by another thread?I would like some data to be shared by all threads.How is data shared among threads?What is the protocol for changing the data and checking for changed data?Is there a good tutorial / website that explains how to handle methods and data when using multiple threads?
View 3 Replies
Nov 1, 2010
I have several Visual Studio Extensions (VSX) that I need to communicate with each other. (For instance activate features, share saved files, access project items from one to another.) I could utilize the registry but I have a very bad feeling about that. I was thinking of a commonly placed XML file but I'm afraid of not having the proper permissions to access it. sharing data between (live) extensions?
View 2 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
View 1 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it
View 5 Replies
Nov 26, 2011
Quite a few threads on passing data from one form to another, but I'm struggling to work out how to share data between the two - back and forth.
For example:
Class1 is a class with 10 string properties
Form1 has 10 labels ("Label1", "Label2" etc) and a [Configure] button.
Form2 has 10 textboxes and a [Apply] button.
I want to load with Form1, and create an instance of Class1. Click the Configure button and load Form2, passing Class1. On Form2 I want to manually fill in the 10 textboxes and hit Apply. The Apply should update the Class1 instance and close the form.
Form1's Label controls should then be updated with the data from the Class1 instance.
I'm fine creating the forms and classes, as well as passing the class into Form2 with a custom Sub New(EmptyClass as Class1) constructor. This gets the empty class into Form2, but how can I get the populated class back to Form1?
As Form1 already exists I don't want to create a new instance with another custom Sub New(PopulatedClass as Class1)
It's also key to be able to use the Form2 multiple times, basically ending up with a Data class being displayed as part of Form1 but updated using Form2? (For example if the Class has already been created and populated with data when it's passed back to Form2 for the second time I would pre-load the Textboxes with the values already in the class).
View 3 Replies
Jul 27, 2009
I have two data tables within my data set that are loaded onto my form on form_load using statements written in code (not the designer. When I change a value for the first table via a text box the change is made to the data set. But when I try the same for the second table, the change doesn't remain in the data set when I switch to a different company and come back. I query the second table using the primary key of the first table but no code is needed when I change the values for the first table so I don't understand why the same doesn't work for the second when I change a value via a data-bound text box....
Here is my code that initially binds the data:
'This is used to read our data from the data base
Public Sub Read_Data_SQL()
Call Clear_Bindings()
[CODE]...
Here is the code I call when the selected index of my company combo box changes to have the second table reflect that of the first:
'This sub populates any information contained in the Contact2 table
Private Sub Update_Contact_2()
Dim Company As String = cmbCompany.Text.Replace("'", "''")
[CODE]...
View 1 Replies
Dec 5, 2011
i am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
View 1 Replies
Jan 25, 2011
if it affects the run time of a program if I were to have multiple data tables as opposed to one data table with all my data in it? I am trying to minimize datagrids and just use code to access table data, in hopes that it will speed up my program. But I am ignorant if multiple tables vs 1 main table will make a difference because there will still be the same amount of overall data present in my program one way or the other....?
View 3 Replies
May 25, 2012
I have been trying to find and/or think up a way for data to automatically update a data table.I have a log that shows all the customers that came in today with various information. There could be twenty or thirty employees adding to this log or updating or doing things with that customer. This information is in a Data Table on a ASPX page in Visual Studio 2010 that the code is binded in the aspx.vb page that is calling a page in my APP_CODE database file that calls a query in my Database to get the information.My question is could someones actions on a different computer make my computer refresh or to re-bind that data.I have thought of some kind of timer/counter maybe that looks to see if the count of the log is different.
View 2 Replies
Aug 4, 2009
I have 2 applications which we can call for example Client/Server.
I would like to exchange data between these applications but basically don't know which is the best route.
I have managed to speak to both applications using text files, but there must be a better way of doing this.
View 2 Replies
Sep 12, 2011
I am working on a project that is used for key broadcasting. Don't worry nothing illegal, I'm making a multibox application for world of warcraft. However I am having trouble when it comes to launching and manipulating other applications from another.
[Code]...
View 2 Replies
Feb 19, 2009
Which is the best way (fast and robust) that .net framework (3.0/3.5) provide for interchange information (for example: dataset packages) between two independent vb.net applications?
View 2 Replies
Oct 1, 2009
I am doing a project on inserting of data through window applications. I am using the MS Access 2003 for the database. I have this form1 and in this form1, it consists of 6 textbox which is custName,Address,position,companyName,Email,Telephone and 1 combobox which consists of the lists of industry.My problem is that I want to insert the data when running this application.
View 3 Replies
May 7, 2010
I have below codes on how to notify forms of data change.
If I were to convert it to exe, how do i then notify the multiple instances of this application of a data change?
Public Class Form1
' use the WithEvents keyword in that the events of frm2 can be handled using the Handles keyword
[Code]....
View 1 Replies
Feb 14, 2011
I have two VB projects in one VS2010 solution. The first program brings in about 60 integers every few seconds from my PC's serial port. The second program, published via Click-Once and running on my customer's PC, needs to see that new data every two to five seconds.
Is there a simple and reliable way to accomplish this, staying with VB? WCF is way over my head.
View 11 Replies
