Click here to Skip to main content
15,917,321 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to make a complex type visible to the client in .NET remoting and WCF? Pin
Farawin16-Apr-09 21:45
Farawin16-Apr-09 21:45 
NewsInteresting Article for C# and Navision Developers Pin
abhishek pareek200915-Apr-09 23:05
abhishek pareek200915-Apr-09 23:05 
QuestionHow do you implement the auto reload process from database data in windows form for display? Pin
calendarw15-Apr-09 22:26
calendarw15-Apr-09 22:26 
AnswerRe: How do you implement the auto reload process from database data in windows form for display? Pin
Mycroft Holmes15-Apr-09 23:20
professionalMycroft Holmes15-Apr-09 23:20 
GeneralRe: How do you implement the auto reload process from database data in windows form for display? Pin
calendarw15-Apr-09 23:41
calendarw15-Apr-09 23:41 
AnswerRe: How do you implement the auto reload process from database data in windows form for display? Pin
SeMartens15-Apr-09 23:21
SeMartens15-Apr-09 23:21 
GeneralRe: How do you implement the auto reload process from database data in windows form for display? Pin
calendarw15-Apr-09 23:47
calendarw15-Apr-09 23:47 
AnswerRe: How do you implement the auto reload process from database data in windows form for display? Pin
dojohansen16-Apr-09 1:15
dojohansen16-Apr-09 1:15 
FYI, I've read on and noticed you need this to work with MSSQL Server 2000.

You've said little about your scenario so it's a bit tricky to give any advice. So this is just some general info instead.

The database does not provide anything that makes it directly easy to provide an event in your application. It is possible though. One way is to write an extended stored procedure in C++ that notifies your application (for example using a message queue) that the update has taken place, and then call this from a trigger in the database.

Another option is available if the database is (supposed to be) accessed only via your client app and you can update all installed clients before the feature becomes (fully) functional. In this case you could use remoting or message queues or web services or even sockets (if you like to needlessly complicate things and reinvent the wheel Smile | :) ) to notify all clients when any client has just modified the data in question.

To be honest, I think polling is a better option. Just remember that if you've got loads of clients and poll frequently it will generate considerable load on the database and it may be smart to put a caching server in the middle. 500 clients polling every 5 seconds is 100 requests per second. If you've got such a case, consider making an app that polls the db every 5 seconds and updates a cached value (such as a timestamp). Then clients can poll this app (which of course responds based on the cached information) without having to acquire shared locks in the database and the rest of the overhead of executing some query a hundred times per second.
QuestionDraw text along points Pin
baranils15-Apr-09 22:22
baranils15-Apr-09 22:22 
AnswerRe: Draw text along points Pin
Henry Minute15-Apr-09 23:26
Henry Minute15-Apr-09 23:26 
GeneralRe: Draw text along points Pin
baranils16-Apr-09 0:25
baranils16-Apr-09 0:25 
GeneralRe: Draw text along points [modified] Pin
Henry Minute16-Apr-09 0:41
Henry Minute16-Apr-09 0:41 
GeneralRe: Draw text along points Pin
baranils16-Apr-09 0:56
baranils16-Apr-09 0:56 
GeneralRe: Draw text along points Pin
Henry Minute16-Apr-09 0:57
Henry Minute16-Apr-09 0:57 
GeneralRe: Draw text along points Pin
Henry Minute16-Apr-09 3:50
Henry Minute16-Apr-09 3:50 
GeneralRe: Draw text along points Pin
baranils16-Apr-09 4:04
baranils16-Apr-09 4:04 
GeneralRe: Draw text along points Pin
Henry Minute16-Apr-09 9:22
Henry Minute16-Apr-09 9:22 
GeneralRe: Draw text along points Pin
baranils16-Apr-09 10:22
baranils16-Apr-09 10:22 
QuestionGenerate Sound Pin
Reelix15-Apr-09 22:21
Reelix15-Apr-09 22:21 
AnswerRe: Generate Sound Pin
OriginalGriff15-Apr-09 22:59
mveOriginalGriff15-Apr-09 22:59 
GeneralRe: Generate Sound Pin
Reelix16-Apr-09 0:01
Reelix16-Apr-09 0:01 
GeneralRe: Generate Sound Pin
OriginalGriff16-Apr-09 0:21
mveOriginalGriff16-Apr-09 0:21 
GeneralRe: Generate Sound Pin
Reelix16-Apr-09 0:26
Reelix16-Apr-09 0:26 
AnswerRe: Generate Sound Pin
DaveyM6916-Apr-09 0:16
professionalDaveyM6916-Apr-09 0:16 
AnswerRe: Generate Sound Pin
Ravi Bhavnani16-Apr-09 2:20
professionalRavi Bhavnani16-Apr-09 2:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.