Click here to Skip to main content
15,943,233 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to execute oracle procedure in c# Pin
darkelv6-Jul-08 2:18
darkelv6-Jul-08 2:18 
QuestionmdiChild Form Pin
zeeShan anSari6-Jul-08 1:28
zeeShan anSari6-Jul-08 1:28 
AnswerRe: mdiChild Form Pin
DaveyM696-Jul-08 1:38
professionalDaveyM696-Jul-08 1:38 
GeneralRe: mdiChild Form Pin
zeeShan anSari6-Jul-08 1:54
zeeShan anSari6-Jul-08 1:54 
QuestionHow to lock record when inserting Pin
dabuskol5-Jul-08 23:33
dabuskol5-Jul-08 23:33 
AnswerRe: How to lock record when inserting Pin
Nader Elshehabi6-Jul-08 0:29
Nader Elshehabi6-Jul-08 0:29 
GeneralRe: How to lock record when inserting Pin
dabuskol6-Jul-08 1:01
dabuskol6-Jul-08 1:01 
GeneralRe: How to lock record when inserting Pin
Nader Elshehabi6-Jul-08 1:13
Nader Elshehabi6-Jul-08 1:13 
Nader Elshehabi wrote:

3- The server locks the table for update


It's the server's problem, not the disconnected client to generate & implement the key. That's what is making you problems. You should re-layer you design.

If your DB is on a local network, I suggest upgrading it to another level. You're talking about 10 persons currently, but I believe you should think of the right way to do it. You already go 50K records we don't want to lose that if things got nasty!!

My suggestions:-
1- Take another look at your software design -Client/Server layers-
2- At least upgrade your table be calling an ALTER TABLE ADD COLUMN NewIndex IDENTITY(1,1), & shut down the work for upgrading at least an hour. You can do it like this:
1- Make a test local database
2- Fill it with sample data
3- Upgrade the code of the client & the database to handle the new key
4- Try the upgrade
5- Shut down the original DB for 10 mins for maintenance, and Upgrade both DB & all clients.
6- Everyone ishappy = true; & no more bugs Smile | :)

RegardsRose | [Rose]

AnswerRe: How to lock record when inserting Pin
Pete O'Hanlon6-Jul-08 11:09
mvePete O'Hanlon6-Jul-08 11:09 
QuestionQuestion about running threads in C# Pin
Yanshof5-Jul-08 21:46
Yanshof5-Jul-08 21:46 
AnswerRe: Question about running threads in C# Pin
Nader Elshehabi6-Jul-08 0:50
Nader Elshehabi6-Jul-08 0:50 
QuestionEditing DataGridViewImageCell? Pin
anton-095-Jul-08 19:34
anton-095-Jul-08 19:34 
AnswerRe: Editing DataGridViewImageCell? Pin
Nader Elshehabi6-Jul-08 0:54
Nader Elshehabi6-Jul-08 0:54 
QuestionVS2005 whether there are similar delphi in the control Notebook Pin
ChinaTJBoy5-Jul-08 17:54
ChinaTJBoy5-Jul-08 17:54 
AnswerRe: VS2005 whether there are similar delphi in the control Notebook Pin
Nader Elshehabi6-Jul-08 0:20
Nader Elshehabi6-Jul-08 0:20 
Questionhow to change DataGridView Event calling sequence Pin
Xmen Real 5-Jul-08 17:49
professional Xmen Real 5-Jul-08 17:49 
AnswerRe: how to change DataGridView Event calling sequence Pin
Nader Elshehabi6-Jul-08 0:18
Nader Elshehabi6-Jul-08 0:18 
GeneralRe: how to change DataGridView Event calling sequence Pin
Xmen Real 6-Jul-08 0:23
professional Xmen Real 6-Jul-08 0:23 
GeneralRe: how to change DataGridView Event calling sequence Pin
Nader Elshehabi6-Jul-08 1:03
Nader Elshehabi6-Jul-08 1:03 
GeneralRe: how to change DataGridView Event calling sequence Pin
Xmen Real 6-Jul-08 2:26
professional Xmen Real 6-Jul-08 2:26 
GeneralRe: how to change DataGridView Event calling sequence Pin
Nader Elshehabi6-Jul-08 2:52
Nader Elshehabi6-Jul-08 2:52 
GeneralRe: how to change DataGridView Event calling sequence Pin
Xmen Real 6-Jul-08 2:55
professional Xmen Real 6-Jul-08 2:55 
GeneralRe: how to change DataGridView Event calling sequence Pin
Xmen Real 6-Jul-08 5:39
professional Xmen Real 6-Jul-08 5:39 
QuestionWhat are your suggestions ? Pin
Mohammad Dayyan5-Jul-08 14:24
Mohammad Dayyan5-Jul-08 14:24 
AnswerRe: What are your suggestions ? Pin
Christian Graus5-Jul-08 15:40
protectorChristian Graus5-Jul-08 15:40 

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.