Click here to Skip to main content
15,887,886 members
Home / Discussions / C#
   

C#

 
GeneralRe: Removing the cross from a form Pin
Stefan Troschuetz22-Sep-04 4:35
Stefan Troschuetz22-Sep-04 4:35 
GeneralRe: Removing the cross from a form Pin
exhaulted22-Sep-04 4:48
exhaulted22-Sep-04 4:48 
GeneralRe: Removing the cross from a form Pin
Stefan Troschuetz22-Sep-04 4:59
Stefan Troschuetz22-Sep-04 4:59 
AnswerRe: Removing the cross from a form Pin
walterhuang29-May-06 20:42
walterhuang29-May-06 20:42 
QuestionBest Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 3:32
KoalaCowboy21-Sep-04 3:32 
AnswerRe: Best Practice - Webservice, Stored Procedure, both? Pin
Heath Stewart21-Sep-04 6:52
protectorHeath Stewart21-Sep-04 6:52 
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 8:29
KoalaCowboy21-Sep-04 8:29 
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
Heath Stewart21-Sep-04 10:52
protectorHeath Stewart21-Sep-04 10:52 
While this has extended well beyond a C# question, I will answer this once.

I personally would use MSMQ (Microsoft Message Queue) where each DC posts a message containing the data you need to a queue asynchronously. Why go to the overhead of a request/response mechanism when it's not needed (HTTP is, by protocol, a client request/server response protocol).

The listener on the queue takes this information and posts it in SQL Server using a simple SqlCommand. Use a stored procedure to separate logic and abstract your implementation so that you can change a small piece without recompiling and testing the whole solution (modularize).

The .NET Framework supports MSMQ in the System.Messaging[^] namespace, which you can read about in the .NET Framework SDK. The documentations includes many examples.

Note that the MSMQ server can be installed on Windows 2000 (Workstation and Server), XP (Professional), and 2003. It is not typically installed by default.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 10:56
KoalaCowboy21-Sep-04 10:56 
GeneralInsert a frequency time delay into a ThreadPool Pin
Fahad sarwar21-Sep-04 2:50
Fahad sarwar21-Sep-04 2:50 
Generalcatching control.name change Pin
ShakerWD20-Sep-04 23:55
ShakerWD20-Sep-04 23:55 
GeneralRe: catching control.name change Pin
sreejith ss nair21-Sep-04 0:20
sreejith ss nair21-Sep-04 0:20 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 1:26
ShakerWD21-Sep-04 1:26 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 9:11
ShakerWD21-Sep-04 9:11 
GeneralRe: catching control.name change Pin
Dave Kreskowiak21-Sep-04 9:44
mveDave Kreskowiak21-Sep-04 9:44 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 9:55
ShakerWD21-Sep-04 9:55 
Generalchanging RowState of DataRow Pin
TehMedic20-Sep-04 23:31
TehMedic20-Sep-04 23:31 
GeneralRe: changing RowState of DataRow Pin
Sendilkumar.M21-Sep-04 0:24
Sendilkumar.M21-Sep-04 0:24 
GeneralRe: changing RowState of DataRow Pin
sreejith ss nair21-Sep-04 0:27
sreejith ss nair21-Sep-04 0:27 
QuestionHELP ME!!! How to design a new control? Pin
bekun20-Sep-04 23:31
sussbekun20-Sep-04 23:31 
AnswerRe: HELP ME!!! How to design a new control? Pin
Kodanda Pani20-Sep-04 23:49
Kodanda Pani20-Sep-04 23:49 
GeneralRe: HELP ME!!! How to design a new control? Pin
bekunkun21-Sep-04 0:17
bekunkun21-Sep-04 0:17 
GeneralRe: HELP ME!!! How to design a new control? Pin
sreejith ss nair21-Sep-04 0:22
sreejith ss nair21-Sep-04 0:22 
QuestionWhy does this exception rarely throw? Pin
mkomasi20-Sep-04 21:40
mkomasi20-Sep-04 21:40 
AnswerRe: Column C does not belong to the table T Pin
sreejith ss nair20-Sep-04 22:24
sreejith ss nair20-Sep-04 22:24 

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.