Click here to Skip to main content
15,890,438 members
Home / Discussions / Mobile
   

Mobile

 
AnswerRe: Installing CAB Files and CF 2.0 on PDA Pin
PavanPareta30-Sep-07 19:11
PavanPareta30-Sep-07 19:11 
AnswerRe: Installing CAB Files and CF 2.0 on PDA Pin
DigiOz Multimedia16-Oct-07 16:06
DigiOz Multimedia16-Oct-07 16:06 
QuestionProgress bar to monitor progress Pin
steve_rm26-Sep-07 7:01
steve_rm26-Sep-07 7:01 
QuestionSwitching between custom and default windows shells, in WinXPe [modified] Pin
All_names_taken26-Sep-07 1:08
All_names_taken26-Sep-07 1:08 
Questionhow do I get 16-bit colors from EVC++? Pin
mercenary0125-Sep-07 16:08
mercenary0125-Sep-07 16:08 
Questionhow to use timer .start & stop Pin
ram krishna pattnayak25-Sep-07 3:27
ram krishna pattnayak25-Sep-07 3:27 
QuestionTransfer data faster Pin
dandi1824-Sep-07 3:31
dandi1824-Sep-07 3:31 
AnswerRe: Transfer data faster Pin
Mike Dimmick27-Sep-07 6:46
Mike Dimmick27-Sep-07 6:46 
Rather ironically for something called 'SQL Server CE', the SQL language is the worst, slowest way to do anything. If you're using .NET Compact Framework 2.0, the solution for loading data that's the fastest to execute while still being pretty readable and maintainable is to use the SqlCeResultSet class.

To do this, create a SqlCeCommand, passing just the name of the table to modify in the query text parameter. Then set the command type to CommandType.TableDirect. Associate it with an open SqlCeConnection and call ExecuteResultSet, using the ResultSetOptions.Updatable option. Then, on the SqlCeResultSet, call CreateRecord to get a new record, set the record's properties, then call Insert to insert it into the table.

See SQL Server Compact Edition Insert Performance[^] for details on just how big a difference this makes.

Equally, a direct table access operation is far, far faster than SELECTing from that table - not just time to first row being returned, but even the time to access each subsequent row. To access the results in a particular order, you can use the IndexName property to use a named index on the table, and you can use the SetRange method to restrict the set of results that are returned.


DoEvents: Generating unexpected recursion since 1991

AnswerRe: Transfer data faster Pin
DigiOz Multimedia16-Oct-07 16:11
DigiOz Multimedia16-Oct-07 16:11 
QuestionNo PPC skin in designer view Pin
Szymon Kamycki22-Sep-07 7:50
Szymon Kamycki22-Sep-07 7:50 
QuestionBackground color for progressbarctrl Pin
MuthiahR21-Sep-07 12:37
MuthiahR21-Sep-07 12:37 
AnswerRe: Background color for progressbarctrl Pin
Alain Rist21-Sep-07 21:37
Alain Rist21-Sep-07 21:37 
GeneralRe: Background color for progressbarctrl Pin
MuthiahR24-Sep-07 4:45
MuthiahR24-Sep-07 4:45 
GeneralRe: Background color for progressbarctrl Pin
MuthiahR27-Sep-07 5:31
MuthiahR27-Sep-07 5:31 
QuestionRAS connection using GSM - GPRS Modem [modified] Pin
BschroederNEC20-Sep-07 10:57
BschroederNEC20-Sep-07 10:57 
AnswerRe: RAS connection using GSM - GPRS Modem Pin
Mike Dimmick27-Sep-07 6:16
Mike Dimmick27-Sep-07 6:16 
GeneralRe: RAS connection using GSM - GPRS Modem Pin
BschroederNEC27-Sep-07 6:54
BschroederNEC27-Sep-07 6:54 
GeneralRe: RAS connection using GSM - GPRS Modem Pin
A P Prajwal29-Jun-09 21:45
A P Prajwal29-Jun-09 21:45 
QuestionHelp regarding sending sms Pin
anu8120-Sep-07 1:16
anu8120-Sep-07 1:16 
QuestionGet Current Directory Pin
chemipoo13-Sep-07 3:10
chemipoo13-Sep-07 3:10 
AnswerRe: Get Current Directory Pin
Alain Rist14-Sep-07 0:42
Alain Rist14-Sep-07 0:42 
QuestionFAST FUNCTION TO WRITE A FILE? Pin
AlexB4712-Sep-07 23:28
AlexB4712-Sep-07 23:28 
QuestionWin Mobile: How to draw an "always on top" graphical element? Pin
thomanil12-Sep-07 1:43
thomanil12-Sep-07 1:43 
QuestionWifi connection through a java/j2me program Pin
haimasree11-Sep-07 5:04
haimasree11-Sep-07 5:04 
QuestionFind character position into .txt file Pin
k.giannis_198010-Sep-07 3:59
k.giannis_198010-Sep-07 3:59 

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.