Architecture :: How To Synchronize The Data With Server
Jun 23, 2010
I have the following scenario:
A server with a number of different clients on different networks. Clients will have to synchronize data with the server.
Just imagine we have a simple data table on the server. The client has the same table schema and works locally but at a certain time of the day it must upload and synchronize with the server.
Was thinking maybe in doing the following. On the client have two extra columns:
Ej:
- synchronized (Boolean, default to false)
- Time it was synchronized (date time).
- Have a wcf service on the server.
Whenever it needs to synchronize it calls the service. The service then updates data on the server. The client will wait for a response which will inform whether the synchronization took place or not. If it did it updates its local table, setting synchronized to true and the time.
View 4 Replies
Similar Messages:
Feb 3, 2011
I want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
[code]....
but when i feed data in offline database, online database automatically updated.
View 5 Replies
Jan 6, 2010
I need to synchronize data between 2 tables. i need to update records on table2 corresponding to table1. I also need to add new records in table2 by getting new records from table1.
View 2 Replies
Jan 31, 2010
I have a Gridview that is populated with and ObjectDataSource set up to allow anonymous users to populate it. After logging in, the database is filled with the Gridview's data using the following:
[Code]....
The database's primary Key is filled by the "lblItemID" string at the beginning of the loop.
deleting the item from the database keying on this primary key. The gridview deletes the proper row using it's DeleteMethod, but obviously I don't have it set up properly to delete the same PK row from the database.
I really don't want to mess with the DataSource's DeleteMethod (and I'm not sure if this would help at all anyway), so is there a way to look for these deleted ItemId's and remove them from the database while executing this Loop statement?
View 1 Replies
Jun 7, 2010
I have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 Replies
Mar 22, 2010
The Dumps data are in the Excel file. Now I want o upload the data to sql server 2005(which are in web server) from client pc (from browser). What will be the best way to do so?
I can know how to upload data from excel to sql server 2005 if both are in the same computer.
View 5 Replies
Mar 15, 2010
I need to synchronize the count down time for all users.So it will display identical remaining time to all in asp.net.
View 1 Replies
Mar 30, 2011
Possible Duplicate: C# version of java's synchronized keyword?
I know that when working with a session in Java, you were always supposed to surround use of the session with a synchronized block incase the user would load your page with two browsers at the same time.
View 1 Replies
Jun 22, 2010
I found a good website to show presentation with video and slides at the same time. The video is nicely synchronized with the slides. I would like to know whether it can be done in ASP.NET web form. If yes, how to do it? What is the logic to implement this feature?
View 3 Replies
Jan 13, 2010
how can I synchronize sessionID over multiple second-domain servers? For example, I've got servers(you can log-in into server swarm at any of these), [URL], [URL], [URL] and if you log in at one of them, the login information (+anything else) should persist along them. How can I provide SessionID to other domains? (session itself is stored on sql server shared across the services).
View 2 Replies
Jan 17, 2010
I used the Database Publishing Wizard to create a copy of my live SQL Server database for testing purposes. Both the live and test databases are hosted by my ISP.
What is the easiest way to transfer design changes from one database to the other without altering the data (assuming that the design changes are compatible with the existing data in the target database)?
Any proposed solution would have to be available via Visual Web Developer 2008 Express or SQL Server 2008 Development Edition.
View 11 Replies
Feb 6, 2011
I have what I consider a pretty complex situation that I am not sure if it can even be accomplished via an ASP.NET web application. (I am using aps.net 4.0) But what I want to do is design a "online auction site" that can handle many autions running at the same time. So I can only imagine eBay and all the other millions of auction sites out there are all doing this someway or another. My biggest concern is that I want to make sure the design here to make the site as effiecent as possible. Here is specifically what I am trying to figure out.
I think I need to create an object (per active auction) that stays in memory for the life of the auction. This object would have at least the following information:
Aution ID, time remaining, highest bidder id, bid price, Thread Control Variable, etc...
Now here is the tricky part that I think is vital for auction sites. Lets say you have 500 users on my website that are all watching the same auction and it is getting down to the last second of the auction and they all click to place a bid at the same time. Keep in mind this may also be at the same time hundreds of other users are placing bids for other auctions going on all at the same time.
How do I get all these requests (bids), for a single auction, lined up so that they are processed "one at a time"? But some how I need to be able to make all requests wait in a queue until it is their "turn" then I would need to be able to update the in memory object, write a record into a SQL database and then begin returning information back to each user.
Based on other development languages I have used in the past I know their were objects that I could create that could be used to get multiple threads to run in order (in other words syncronized). Usually it would be a case where I would be listening on a server socket and could do something like ThreadVariable.Lock, <process the request>, thenThreadVariable.Unlock. What that would do, is force all threads that tried to call ThreadVariable.Lock to wait until no other threads had the variable locked then it could proceed. Obviously the code it processes between the lock and unlock should be as quick and effecient as possible so it does not create a major traffic jam.
Because my thinking is this "object" I am referring to as being in memory, most likely will play a big role in answering the question about getting the requests in a "one at a time" situation it may be the focus of the question is more like how would I create "an object" and store it in memory to be quickly and easily accessed?
And even more generically does this even sound like I am on the right track
I think the topic of "communication to and from users" will need to be a completly different thread.
View 5 Replies
Jun 8, 2010
I'm using Content Management System, DotNetNuke for my dynamic website. DNN itself they have one database, I named it dnnDB. Inside the dnnDB they have the users table which have the list of users. I need to be able to pull this set of information or synchronize to my own database, myDatabase for development purposes. I do not want to incorporate my database into dnnDB, afraid that I may corrupt the system.
View 4 Replies
Mar 11, 2010
So this interface allows one server to request data from another server. The catch is that all xml for the interface is transmitted entirely over http posts followed by an empty status code 200 response. No data is sent in a response. So if my application wants to requests data, we send an http post with the xml request and receive a blank 200. Then, shortly after our request, we'll receive an http post to a predetermined URL with the xml data which we then send a blank 200. This data will then be stored in a SQL database. This interface cannot be altered.
The reason this is problematic is because our server is handling requests from clients that need that data in the response. If a user requests for data that isn't available in our database, it needs to be requested from the interface and then returned in the response. I'm just not sure how to get this to work out. I've thought about polling the database, but I'm worried about thread pool issues. I've also looked into using ManualResetEvent.WaitOne to halt the processing of the client request and then calling Set when the interface sends the data (as a request). I've read that wait threads are shared, but just don't know if this will scale well. Does anyone have any insight or I'm pretty much stumped on this one...
View 4 Replies
Apr 23, 2010
We are storing the WAV file into a database table as VARBINARY(MAX). We want to play the WAV file directly in a web page. We want to use PLAY, PAUSE and STOP for these WAV files.
We want the user to have a Control on the page to play the WAV file.
Here we DO NOT want to store the FILE in the Web Server's file structure. It is againt the SECURITY policy.
We tried different ways. Nothing is working. We used SoundPlayer class. Using this, we can only PLAY and STOP but can not PAUSE the WAV file.
View 2 Replies
Sep 17, 2010
I am using stored procedure in my Web application. I am creating SQL Command binding this command with Stored procedure name and parameters and executing.
The problem is for each Stored procedure i need to create separate function for each stored procedure defined.
Is there any way that I can define a single function for n number of stored procedure.
View 4 Replies
Oct 26, 2010
If i want to create a web site that take your picture and share it for your friends, what the best way to save the picture files on server? What the way is safer for the picture files? What the way has the best performance?
View 9 Replies
Sep 13, 2010
I have a site that sends a good bit of emails, some one at a time, and some larger groups of admin emails. I'm running on a shared hosting service. The mailserver is horribly slow, so any script that sends a single email can take as much as 15 seconds to execute (and I can't seem to set Response.BufferOutput to false, so the whole page has to wait the entire duration). On the bulk emailings, it can take minutes for that to run.
I want to create a "mail queue" of my own... I want any script that sends an email to, instead, write a row to a db table containing the necessary email info, which will let the script get on with its business quickly. Then, I want to create a script that runs on the server only, and have it check the table for emails, send them, and remove them from the table.
I know I can have the "mailsender" script run as a scheduled task, and it would thereby run on the server only. But I would prefer to have the initial script somehow "trigger" the mailsender script.
Is there a way in asp.net to create a script that will execute solely on the server, and call that script from another page, so that the calling page doesn't wait for the server script to execute?
View 2 Replies
Dec 2, 2010
I have this scenario. I have an application running in a webserver (in DMZ). End users upload documents to the webserver. right now all the documents get stored in the webserver itself. I would like to store all the docs in the database server.
What is the best way to store the documents, move it from webserver to db server after they uplocaded or directly upload to the db server ?.
And, if I have to upload directly to the db server could someone help me how to mangae the connection to the db server and credentials..?
View 3 Replies
Jun 30, 2010
I am using multiple threads in my .net web application. Certain functions may need to execute at any arbitrary time. However, I do not need these (and the entire application) to be fully asynchronous, as there is an acceptable tolerance in this execution time. Here is a rough example of what I need to do:
main()
{
loop
{
if (flagA) then doTaskA();
if (flagB) then doTaskB();
}
}
...where flagA and flagB are set via asynchronous timers in critical section. The actual execution of the requested tasks would thereafter run in series.
This is very easy to do in C/C++, etc. But I cannot find any access to such control in .NET, specifically in the web server/application architecture. It may be that it doesn't exist; however, I am assuming that the server must do something of this sort as it manages applications. I would like to hook into that somehow; even if via some application function that is called regularly during this loop.
View 18 Replies
Nov 1, 2010
I want to develop a three tier architecture app.I have no idea when weplace our BLL and DLL code in different server how to connecct this BLL and DLL code to our Website(UI).
View 4 Replies
Apr 11, 2010
Coming to my task, I have to schedule a process which will delete all the files in the paticular table with particular key.I have the stored procedure for the deletion. What all I need is, How to schedule this process in the application server.?
View 5 Replies
Feb 4, 2010
where they have used SQL server state management on a 3 tiered architectuere ?How should one implement (SQL server state management) without bypassing the middlelayer.
View 1 Replies
Oct 4, 2010
I am looking details on the internal working of asp.net architecture. The topics need to include the following:
Asp.Net Thread/Application Pools HttpRuntime HttpApplication - When and how it is set up How HttpContext is set up How objects can passed along the pipeline using HttpContext.Current.Items Why does modification of static variables requires locks in ASP.NET (advanced)IIS 7 Integration Mode
View 1 Replies
Mar 30, 2010
I need to run the HttpContext.Current.Server.Execute method in my ASP.NET application. This application has a WCF operation that does some processing. Currently, I am running a Server.Execute call from within my WCF operation and getting the results I would expect. However, I would like to do this asynchronously.This is where my problem comes in. In an error to run Server.Execute asynchronously, I tried running Server.Execute in the DoWork event handler of a BackgroundWorker. Unfortunately, this throws an error that says
"object reference not set to an instance of an object"
The HttpContext element is not null. I checked that. It is some property nested in the HttpContext object that appears to be null. However, I have not been able to identify why this won't work. It happens as soon as I move the processing to the BackgroundWorker thread. My question is, how can I asynchronously execute the Server.Execute method? Are there options beyond BackgroundWorker that will work?
View 2 Replies
