Asp.net - Updating Data Of A Distributed Windows Application?
Apr 22, 2012
I'm wondering, is there a way to update databases of a windows application that is distributed on several computers all at the same time? is it done by using sql server? because I'm developing an examination system that will be distributed on several computers for students to take exams and I'm just wondering if an admin updates a questions database will the changes be applied to all other computers as well or should it be done manually? sorry if I sound stupid but I can't seem to understand this part of my work, I was thinking about switching to a web app since it seems easier, but again this data updating issue is giving me hard time. by the way I might link the application to an internal network, will this have anything to do with updating the databases?
View 1 Replies
ADVERTISEMENT
Nov 9, 2011
how to work with distributed application in vb.net that automatically stored data into server? How to configure to ensure the consistency of data being stored.
View 6 Replies
Sep 28, 2011
I have an excel file that I would like to load into my form and display there.
View 1 Replies
Aug 26, 2009
I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
View 6 Replies
Nov 29, 2011
I'm trying to access Windows XP's Application Data - but I'm having a slight issue, I am using the following code:Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)This is working correctly in any other opperating system - but Windows XP - On Windows XP it directs them to: C:Documents and SettingsAdministratorApplication Data - this is not the folder I want.I want to access: C:Documents and SettingsAdministratorLocal SettingsApplication DataI have tried to do:
View 4 Replies
Oct 16, 2010
I am using SQL EXPRESS EDITION 2005 and Created mdf data file using vb.net 2008. now i want to use this datafile in lan. i modified connection string "Data Source=.SQLEXPRESS;AttachDbFilename=ServerDataData1.mdf;Integrated Security=True;User Instance=True;Connect Timeout=60"it is showing security info error i want to use single database file for my application please help me with connection string. thank you
View 1 Replies
Jan 24, 2011
i made this thread and faraz zone made a guide for me, I keep doing the guide but i keep getting this error: url...untill now, now i end up reformatting my notebook and i try to do again Faraz Zone guide and i still keep getting that error, now I decided to make this new Question/ Thread.I already made my vb.net project using Microsoft Visual Studio 2010 that has database and multiple forms, and I already installed SQL Server 2008 R2. I want my project to be remote/network using lan environment, in what way i can do this?
View 1 Replies
Jan 23, 2010
An application data file, created by my own VB program, is visible to read and save from that application, but is not visible from Windows Explorer or Notepad. The icon, visible from my VB program, shows a lock. How can I remove the lock and see the program with Windows Explorer. (I need to copy to a another computer to use in a workshop next week.)
View 2 Replies
Aug 2, 2011
I have created an application with 3 terminal windows for capturing data from 3 serial ports and outputting the data to a file. It seems to work well with one serial port, but when I fire all 3 serial ports at once, the application hangs. Here is the portion of the code that I believe is the problem. The code below is for Serial Port A. I have the same code for Serial Port B and Serial Port C
Private Sub ASerialPort_OnComm() Handles ASerialPort.OnComm
ReceiveBufferA.Append(ASerialPort.InputString)
Me.BeginInvoke(New EventHandler(AddressOf ReceivedTextA))
[code].....
View 3 Replies
Apr 15, 2010
how to export data to word document in windows application?
View 5 Replies
May 20, 2009
What is the syntax for the windows XP/Vista Application Data folder When i use
[Code]...
View 1 Replies
Nov 10, 2009
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use GetDtcTransaction on the ambient transaction (created by transactionscope) to get a DTC transaction to link to the third party SDK. Things work nicely for about 10 minutes, but after 10 minutes, the transaction disappears and an error occurs. How do I determine why the transaction is disappearing. I suspect it's a timeout because it regularly occurs after 10 minutes even though slightly varying degrees of work have been done at that point. But I'm at a loss about how to determine what terminated the transaction, why, and how to extend its life.
[Code]...
View 3 Replies
Jun 13, 2011
I just created my first VB.net project using Microsoft Visual Studio 2010 that has database(.mdf) and some forms?I want my project to be remote/network using lan environment, in what way i can do this?i keep goggling i can't find the answer so i end up in your site, I already install SQL Server 2008 R2 in my PC, and i already set up 2 computer here in my house 1 act as a server and the other is client using Lan.
View 16 Replies
Jun 6, 2010
I am upgrading my application from vb6 to vb.net.I used to populate my data in datalist control in vb6 forms. I am not finding it in vb.net windows form application. Which one control is the equivalent to it?
How can i list my data in that control?
just like: I had a table with data like id, name
I want the name should be the displayed column and id the bound column? how can i do that
View 1 Replies
Jun 1, 2011
I want to fill the textboxes with datagrid value ie the row that is selected. i am working on vb.net windows application
View 1 Replies
Jan 8, 2009
I am using Datagridview and ListView Controls in my windows desktop application using vb.net.I want to Import data directly to Excell sheet and CSV file directly from form.
View 3 Replies
Jul 14, 2009
Can I Post a Windows Application that uses Excel for live data calculations? Basically from the Windows app, a user makes a menu selection and which in turn opens an excel file in memory using it for calculations. These files are put together by different groups and formatted for the Windows app to build interfaces based on each file.I also accompany an .mdf file as well. Is all this possible for customers to access and run this with Windows Azure.
View 2 Replies
Sep 1, 2009
I have a form program that runs long, and for kicks I was wondering if I could out put some data to a "real console" -not the Console useing the Output debugger.
View 8 Replies
Feb 16, 2009
I need to write a program that can be distributed over a network of 400 computers and that can be updated if necessary. How do i do that with VB if i can at all? What should i learn?
View 2 Replies
Sep 24, 2009
My local machine is using windows application for an appointment fixing .I want to retreive data from webserver DB which also does appointment fixing by online for the same organisation.So I want both these to work in co-ordination.As my first step I want to import data.
View 2 Replies
Apr 26, 2009
I have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
View 2 Replies
Nov 13, 2009
We've recently moved to Team System and now a remote team needs access to our source. However, they use a different IP address to access the Team System server, and whenever they try to open a project, they are prompted to check out and change the project. It seems to be the 'SccAuxPath' property which is the problem.
View 2 Replies
Jun 4, 2009
I am working on a windows application in vb.net 2005 and it needs to connect to the SQL Server database. In this example I testing if the connection is able to open properly:
[Code]...
Is it something dealing with the permissions set with the database server or something? I am new at .NET programming and I have been spinning my wheels on this for the past couple of days and I am at a loss. From what I research, this error should only occur if I was creating a web program, but I am not. It is a windows application.
View 7 Replies
Jun 27, 2012
I'd like to give a homework assignment to a person learning VB.NET. I'd like it to use basic inheritance and a variety of data structures including queues, lists, arrays, or stacks in a windows forms application. I was thinking of a pizza-ordering application. This would allow them to utilize some basic inheritance and practice using .NET UI elements.
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
Apr 18, 2011
I am creating a form in VB to enter customer sales invoices and need to update two tables i.e. InvoiceHeader and InoviceDetails. The Invoice details can have more than one line for one Invoice header. I was wondering if there is any thing like Access subforms or how can I update both tables through an SQL statement.
View 1 Replies
Sep 14, 2009
I have a windows application developed in VB.net 2005. The application is installed in several machines.Is there anyway when I do any modifications and publish the code it updates in all the machines.
PS: All the machines are connected to internet.
View 2 Replies
Feb 1, 2011
I'm using Access 2010 for 2 small databases for a windows forms desktop application.on Form 1, my datagridview updates Paccounts.mdb correctly as follows:
end_OK:
Try
Me
.PaccountsTableAdapter.Update(PaccountsDataSet.Paccounts)
[code]....
View 3 Replies
Jan 24, 2012
If I have some resources added to a project, such as images or sounds, they are placed in Resources folder. Say I created a new image file with the same name and want to replace the one I added earlier.
Do I have to do this via Projects Properties Resources tab by removing the old one and adding the new one? Or can I simply copy and paste the new file in Windows Explorer into the Resources folder (replacing the old one)? Would it break the project? Does it matter if the project is currently open in Visual Studio?
View 3 Replies
