0

I have 3000+ record in my database and I want to Display that record in my Windows CE mobile application.Which is Fastest way to Display that record.I used C# language.How can I do that?

Pratik
  • 11,534
  • 22
  • 69
  • 99
  • 3
    You need to be more precise about your question by providing more info. – Lion Dec 29 '11 at 11:15
  • What are you asking? how to retrieve the data from the database? how to make a UI? you need to write provide more information, if you want a useful answer. – Jesper Fyhr Knudsen Dec 29 '11 at 13:18
  • I used windows CE mobile and it's memory low and my database is huge almost 3000+ record and When i displayed record it's time consuming process any other way to display record in my application. –  Dec 29 '11 at 14:37
  • I tried Window CE os --- XML(Middle) --- SQL compact edition –  Dec 29 '11 at 14:39
  • http://stackoverflow.com/questions/1689455/what-is-the-fast-way-for-find-data-in-sqlce-windows-mobile-c-sharp – Pratik Jan 12 '12 at 11:33

1 Answers1

0

This MS artice discusses this exact topic.

http://msdn.microsoft.com/en-us/library/dd938877.aspx

I was using table adapers and it was really, really slow. One operation wrote 3000 records of about 50 chars and took 20-30 minutes on an old win ce 6.1 device.

I changed over to use resultsets and same task is about 1-2 minutes.

Andrew

andrew
  • 1,184
  • 3
  • 19
  • 28