Click here to Skip to main content
15,917,481 members
Home / Discussions / C#
   

C#

 
GeneralRe: How can I check if a table exists? Pin
Emmet_Brown12-Nov-09 9:36
Emmet_Brown12-Nov-09 9:36 
GeneralRe: How can I check if a table exists? Pin
Christian Graus12-Nov-09 9:42
protectorChristian Graus12-Nov-09 9:42 
GeneralRe: How can I check if a table exists? Pin
Emmet_Brown12-Nov-09 9:50
Emmet_Brown12-Nov-09 9:50 
GeneralRe: How can I check if a table exists? Pin
Christian Graus12-Nov-09 10:43
protectorChristian Graus12-Nov-09 10:43 
AnswerRe: How can I check if a table exists? Pin
The Man from U.N.C.L.E.12-Nov-09 9:36
The Man from U.N.C.L.E.12-Nov-09 9:36 
GeneralRe: How can I check if a table exists? Pin
Emmet_Brown12-Nov-09 9:39
Emmet_Brown12-Nov-09 9:39 
GeneralRe: How can I check if a table exists? Pin
Emmet_Brown12-Nov-09 9:47
Emmet_Brown12-Nov-09 9:47 
GeneralRe: How can I check if a table exists? Pin
The Man from U.N.C.L.E.12-Nov-09 10:48
The Man from U.N.C.L.E.12-Nov-09 10:48 
SQL CE. silly me.

string command2 = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'your table name'";
SqlCeCommand com2 = new SqlCeCommand(command2, conn);
bool tableExists = false;
If ((Integer)com2.ExecuteNonQuery() > 0){
   tableExists = true;
}


ExecuteNonQuery returns the number of rows selected and if the table exists the return value will be 1.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk

GeneralRe: How can I check if a table exists? Pin
Emmet_Brown12-Nov-09 10:56
Emmet_Brown12-Nov-09 10:56 
AnswerRe: How can I check if a table exists? Pin
PIEBALDconsult12-Nov-09 9:46
mvePIEBALDconsult12-Nov-09 9:46 
Question[Message Deleted] Pin
Michael Smacks12-Nov-09 8:46
Michael Smacks12-Nov-09 8:46 
QuestionHow to convert Dialogic .vox to .wav using c# or vb Pin
bruze12-Nov-09 8:45
bruze12-Nov-09 8:45 
AnswerRe: How to convert Dialogic .vox to .wav using c# or vb Pin
Christian Graus12-Nov-09 9:17
protectorChristian Graus12-Nov-09 9:17 
QuestionListView or not? Pin
Blubbo12-Nov-09 8:28
Blubbo12-Nov-09 8:28 
AnswerRe: ListView or not? Pin
Saksida Bojan12-Nov-09 8:41
Saksida Bojan12-Nov-09 8:41 
GeneralRe: ListView or not? Pin
Blubbo13-Nov-09 3:10
Blubbo13-Nov-09 3:10 
Questionhow to get the recognized phoneme in SAPI [modified] Pin
Xelalem12-Nov-09 7:49
Xelalem12-Nov-09 7:49 
AnswerRe: how to get the recognized phoneme in SAPI Pin
Elgimas14-Nov-09 12:12
Elgimas14-Nov-09 12:12 
GeneralRe: how to get the recognized phoneme in SAPI Pin
Xelalem15-Nov-09 6:00
Xelalem15-Nov-09 6:00 
GeneralRe: how to get the recognized phoneme in SAPI Pin
Elgimas19-Nov-09 15:52
Elgimas19-Nov-09 15:52 
QuestionMultiple inheritance.. Pin
kumar sanghvi12-Nov-09 7:33
kumar sanghvi12-Nov-09 7:33 
AnswerRe: Multiple inheritance.. Pin
Abhishek Sur12-Nov-09 8:03
professionalAbhishek Sur12-Nov-09 8:03 
AnswerRe: Multiple inheritance.. Pin
Christian Graus12-Nov-09 9:24
protectorChristian Graus12-Nov-09 9:24 
AnswerRe: Multiple inheritance.. Pin
PIEBALDconsult12-Nov-09 9:37
mvePIEBALDconsult12-Nov-09 9:37 
AnswerRe: Multiple inheritance.. Pin
Shameel12-Nov-09 22:42
professionalShameel12-Nov-09 22:42 

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.