Click here to Skip to main content
15,907,183 members
Home / Discussions / C#
   

C#

 
AnswerRe: urgent need of a code Pin
Saksida Bojan19-Nov-09 7:03
Saksida Bojan19-Nov-09 7:03 
QuestionC# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 1:11
Ahmed Charfeddine19-Nov-09 1:11 
AnswerRe: C# file containing all langage constructs Pin
Abhishek Sur19-Nov-09 1:29
professionalAbhishek Sur19-Nov-09 1:29 
GeneralRe: C# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 1:42
Ahmed Charfeddine19-Nov-09 1:42 
GeneralRe: C# file containing all langage constructs Pin
Pete O'Hanlon19-Nov-09 1:54
mvePete O'Hanlon19-Nov-09 1:54 
GeneralRe: C# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 1:58
Ahmed Charfeddine19-Nov-09 1:58 
GeneralRe: C# file containing all langage constructs Pin
Pete O'Hanlon19-Nov-09 2:38
mvePete O'Hanlon19-Nov-09 2:38 
GeneralRe: C# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 2:40
Ahmed Charfeddine19-Nov-09 2:40 
GeneralRe: C# file containing all langage constructs Pin
Dave Kreskowiak19-Nov-09 3:58
mveDave Kreskowiak19-Nov-09 3:58 
AnswerRe: C# file containing all langage constructs Pin
Eddy Vluggen19-Nov-09 3:13
professionalEddy Vluggen19-Nov-09 3:13 
GeneralRe: C# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 3:16
Ahmed Charfeddine19-Nov-09 3:16 
AnswerRe: C# file containing all langage constructs Pin
Daniel Grunwald19-Nov-09 3:44
Daniel Grunwald19-Nov-09 3:44 
GeneralRe: C# file containing all langage constructs Pin
Ahmed Charfeddine19-Nov-09 3:58
Ahmed Charfeddine19-Nov-09 3:58 
QuestionHow to delete a file, which is engaged by something? Pin
Chesnokov Yuriy19-Nov-09 0:13
professionalChesnokov Yuriy19-Nov-09 0:13 
AnswerRe: How to delete a file, which is engaged by something? Pin
Abhishek Sur19-Nov-09 1:27
professionalAbhishek Sur19-Nov-09 1:27 
QuestionUpdating databse table on basis of Excel sheet Pin
Priya Prk18-Nov-09 22:54
Priya Prk18-Nov-09 22:54 
QuestionRe: Updating databse table on basis of Excel sheet Pin
musefan18-Nov-09 22:59
musefan18-Nov-09 22:59 
AnswerRe: Updating databse table on basis of Excel sheet Pin
Priya Prk18-Nov-09 23:01
Priya Prk18-Nov-09 23:01 
GeneralRe: Updating databse table on basis of Excel sheet Pin
dan!sh 18-Nov-09 23:10
professional dan!sh 18-Nov-09 23:10 
GeneralRe: Updating databse table on basis of Excel sheet Pin
Priya Prk18-Nov-09 23:14
Priya Prk18-Nov-09 23:14 
GeneralRe: Updating databse table on basis of Excel sheet Pin
dan!sh 18-Nov-09 23:26
professional dan!sh 18-Nov-09 23:26 
AnswerRe: Updating databse table on basis of Excel sheet [modified] Pin
musefan18-Nov-09 23:24
musefan18-Nov-09 23:24 
If you have an ID value in the excel spreadsheet this will be useful to check for existing entries. I assume this field will be empty for new entries? (I say that as you may have trouble adding, if its an auto incremet column)

I would...

1. Search all rows in existing database, pulling only the ID field data.
2. Create a list of ID values
3. Loop all rows in datatable (from excel)
4. Check if datatable row ID is in list of ID values, if so then do an UPDATE query, if not do an INSERT query

...that's it

Life goes very fast. Tomorrow, today is already yesterday.

modified on Thursday, November 19, 2009 6:07 AM

QuestionDrop down control. Pin
Sasmi_Office18-Nov-09 20:18
Sasmi_Office18-Nov-09 20:18 
AnswerRe: Drop down control. Pin
dan!sh 18-Nov-09 20:21
professional dan!sh 18-Nov-09 20:21 
GeneralRe: Drop down control. Pin
0x3c018-Nov-09 20:22
0x3c018-Nov-09 20:22 

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.