locked
what is the most fast way for searching in database - windows-ce RRS feed

  • Question

  • hi

    i work on C#,  windows-CE, sqlCE

    i have database with 200,000 records.

    i need to run any query and see the result on datagridview

    it takes me alot of time until i see the result.

    is there any fast way ?

    can i get any sample code ?

     

    thank's in advance

    Friday, July 30, 2010 6:42 AM

Answers

  • You could use SqlCeResult set with DataGrid (there's no DataGridView on NETCF):

    dataGrid.DataSource  = command.ExecuteResultSet(...);

     


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by warrentang Thursday, August 5, 2010 6:16 AM
    Saturday, July 31, 2010 12:21 AM

All replies

  • I have a question for you, do you need to install something on the phone for SqlCE ?

    For your questions, maybe if you cut your request whit "LIMIT 0,100", it will be faster. Also you can "preload" information before the user request to be faster, this only work if its not a real-time db.

    MadeByHisto

    Friday, July 30, 2010 8:41 PM
  • You could use SqlCeResult set with DataGrid (there's no DataGridView on NETCF):

    dataGrid.DataSource  = command.ExecuteResultSet(...);

     


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by warrentang Thursday, August 5, 2010 6:16 AM
    Saturday, July 31, 2010 12:21 AM