Click here to Skip to main content
15,914,452 members
Home / Discussions / C#
   

C#

 
AnswerRe: generate numbers Pin
J4amieC30-Jul-06 23:39
J4amieC30-Jul-06 23:39 
GeneralRe: generate numbers Pin
skyeddie30-Jul-06 23:52
skyeddie30-Jul-06 23:52 
GeneralRe: generate numbers Pin
LongRange.Shooter31-Jul-06 5:47
LongRange.Shooter31-Jul-06 5:47 
GeneralRe: generate numbers Pin
Vipin Venugopal30-Jul-06 23:56
Vipin Venugopal30-Jul-06 23:56 
Questionlinking up project Pin
skyeddie30-Jul-06 18:50
skyeddie30-Jul-06 18:50 
AnswerRe: linking up project Pin
LongRange.Shooter31-Jul-06 5:51
LongRange.Shooter31-Jul-06 5:51 
GeneralRe: linking up project Pin
skyeddie31-Jul-06 16:59
skyeddie31-Jul-06 16:59 
QuestionConnect to a central db server Pin
GizmoC30-Jul-06 18:34
GizmoC30-Jul-06 18:34 
Hello. I am teaching myself more .NET, really love the technology.

I've created a simple desktop application. Basically, its a database frontend for an inventory management system.

The databse is simply an Access file (.mbd) which is in the same directory as the executable. In other words, my oleDbConnection objects look for the database (.mdb file) in the same directory.

You see, this application will be independantly run on different PCs (each PC is in a different branch of our shop). I want to make all the different PCs share the same database. Ofcourse, the PCs will be connected (via LAN) to a central database server (where my .mbd file will be stored).

In essence, all I want to do is make my application look for the .mbd file on the database server, instead of localdisk. However, there are some issues which I dont know how to address:

1) I guess the simplest way to achieve this is to create a shared network folder. But I dont think this solution is elegant... because it seems I have to hardcode the network path into the program (specifically, I have to hardcore the ConnectionString of the oleDbConnection object)

2) How do I keep the data synchronized? (ie, Race condition)
The naive way to do this would be simply allow the database to throw an exception, and simply make the user "try again". But I want a more robust solution.
In University, I learnt how to tackle race conditions in the same application using Semaphores, Monitors, etc. But I have no idea how to do it via networks.. since I am no longer dealing with Threads anymore.

I would sincerely appreciate if someone could guide me in the right direction. I am sure there are well-establish methodologies for achieving this... a nudge in the right direction will help. A link, a book, anything.
AnswerRe: Connect to a central db server Pin
LongRange.Shooter31-Jul-06 5:56
LongRange.Shooter31-Jul-06 5:56 
QuestionHow to create a setup in C#? Pin
Mithun Acharya30-Jul-06 18:09
Mithun Acharya30-Jul-06 18:09 
AnswerRe: How to create a setup in C#? Pin
AnnnS30-Jul-06 19:50
AnnnS30-Jul-06 19:50 
QuestionFlickering problem! help! :( Pin
janita30-Jul-06 18:01
janita30-Jul-06 18:01 
AnswerRe: Flickering problem! help! :( Pin
Vipin Venugopal30-Jul-06 20:35
Vipin Venugopal30-Jul-06 20:35 
AnswerRe: Flickering problem! help! :( Pin
janita30-Jul-06 21:10
janita30-Jul-06 21:10 
AnswerRe: Flickering problem! help! :( Pin
janita1-Aug-06 15:41
janita1-Aug-06 15:41 
Questionconnection for excel Pin
Mohammed Elkholy30-Jul-06 11:35
Mohammed Elkholy30-Jul-06 11:35 
AnswerRe: connection for excel Pin
Guffa30-Jul-06 11:53
Guffa30-Jul-06 11:53 
Questionnew process information ? Pin
raol duke30-Jul-06 9:47
raol duke30-Jul-06 9:47 
QuestionIs there any packer for .NET? Pin
xkx3230-Jul-06 7:13
xkx3230-Jul-06 7:13 
AnswerRe: Is there any packer for .NET? Pin
leppie30-Jul-06 15:31
leppie30-Jul-06 15:31 
QuestionShould I use Dispose in this situation Pin
xkx3230-Jul-06 7:01
xkx3230-Jul-06 7:01 
AnswerRe: Should I use Dispose in this situation Pin
Colin Angus Mackay30-Jul-06 11:14
Colin Angus Mackay30-Jul-06 11:14 
AnswerRe: Should I use Dispose in this situation Pin
Guffa30-Jul-06 11:51
Guffa30-Jul-06 11:51 
AnswerRe: Should I use Dispose in this situation Pin
LongRange.Shooter31-Jul-06 5:59
LongRange.Shooter31-Jul-06 5:59 
QuestionHow to get Text control value into a numeric data type? Pin
Amol Ravatale30-Jul-06 5:39
Amol Ravatale30-Jul-06 5:39 

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.