I am developing a project which will contain a sql database with more than 6000 records . I am using table control to retrieve data from database . But while using this in device , it takes more time to retrieve the particular data . is there any more perfect way to function the device fast , with this example ? Enclosed here my project also .
Instead of loading all the data from the SQL database into to the table (with ExecuteTable), you should only load the specific data the user currently needs.
Anyway the user will have a hard time scrolling all these rows.
I used the method that if the 'txtPlace.text' is null then all place names will be fetched to a list . If the 'txtPlace' contains any letters , then particular places starting with that letters will be filled with list . Other than this method what can do better ? (Pls refer attachment)