Click here to Skip to main content
15,906,816 members
Home / Discussions / C#
   

C#

 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:13
Alex Dunlop2-Jun-21 7:13 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Victor Nijegorodov2-Jun-21 7:48
Victor Nijegorodov2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:50
mveDave Kreskowiak2-Jun-21 7:50 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:07
mveGerry Schmitz2-Jun-21 8:07 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:12
Alex Dunlop2-Jun-21 7:12 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:22
mveDave Kreskowiak2-Jun-21 7:22 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:34
Alex Dunlop2-Jun-21 7:34 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:43
mveDave Kreskowiak2-Jun-21 7:43 
You don't know what a stored procedure is, do you?

Yes, you can do it by querying the database for the record you want to insert. If it's already there, you can either update that record or ignore it and go to the next record in your Excel sheet. If it's not there, you can insert it.

Again, there's a problem with doing it from the client-side. In a multi-user environment, if someone else does the same thing at the same time, you could end up with the same record being updated by two or more clients at the same time, or inserting the same record at the same time.

GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:48
Alex Dunlop2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:51
mveDave Kreskowiak2-Jun-21 7:51 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:00
mveGerry Schmitz2-Jun-21 8:00 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 8:02
mveDave Kreskowiak2-Jun-21 8:02 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:09
mveGerry Schmitz2-Jun-21 8:09 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop3-Jun-21 2:06
Alex Dunlop3-Jun-21 2:06 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop3-Jun-21 2:05
Alex Dunlop3-Jun-21 2:05 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Richard MacCutchan3-Jun-21 3:12
mveRichard MacCutchan3-Jun-21 3:12 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Richard Deeming2-Jun-21 21:41
mveRichard Deeming2-Jun-21 21:41 
QuestionHow to increase filtering speed in DataGridView? Pin
Alex Dunlop29-May-21 22:37
Alex Dunlop29-May-21 22:37 
SuggestionRe: How to increase filtering speed in DataGridView? Pin
Richard MacCutchan29-May-21 22:45
mveRichard MacCutchan29-May-21 22:45 
AnswerRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff30-May-21 2:07
mveOriginalGriff30-May-21 2:07 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Alex Dunlop31-May-21 0:58
Alex Dunlop31-May-21 0:58 
GeneralRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff31-May-21 2:14
mveOriginalGriff31-May-21 2:14 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Alex Dunlop31-May-21 3:59
Alex Dunlop31-May-21 3:59 
GeneralRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff31-May-21 4:43
mveOriginalGriff31-May-21 4:43 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Gerry Schmitz31-May-21 7:30
mveGerry Schmitz31-May-21 7:30 

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.