Dear Friends,
The scenario:-
In my app, there are 2 EditText views (EditText_ItemCode and EditText_ItemName) where the user has to pick the ItemCode from a list of Items. The SearchView list should show the ItemCode as well as ItemName in a row just like a grid wth 2 columns.
When the user choose an Item the ItemCode should be returned to EditText_ItemCode view. If possible EditText_ItemName should get the ItemName too. I know that, if, I can get the ItemCode, then I can do another query to the MySQL database and then get the ItemName, I am just checking whether this can be done without raising another query to the remote MySQL server.
Some of my app users will be familiar with the ItemCode, but some may not be familiar with the ItemCodes, so they find ItemName or ItemDesctiption easier. That's the reason for the need to show both the columns on the SearchView
Is there any other view available which can be used to do the above said task. The control should handle a list of more than 25000 items efficiently and quickly.
Any suggestions/help will be appreciated.
Regards
Anser
The scenario:-
In my app, there are 2 EditText views (EditText_ItemCode and EditText_ItemName) where the user has to pick the ItemCode from a list of Items. The SearchView list should show the ItemCode as well as ItemName in a row just like a grid wth 2 columns.
When the user choose an Item the ItemCode should be returned to EditText_ItemCode view. If possible EditText_ItemName should get the ItemName too. I know that, if, I can get the ItemCode, then I can do another query to the MySQL database and then get the ItemName, I am just checking whether this can be done without raising another query to the remote MySQL server.
Some of my app users will be familiar with the ItemCode, but some may not be familiar with the ItemCodes, so they find ItemName or ItemDesctiption easier. That's the reason for the need to show both the columns on the SearchView
- The database is remote MySQL server connected via RDC
- The no of items in the list will be more than 25000
Is there any other view available which can be used to do the above said task. The control should handle a list of more than 25000 items efficiently and quickly.
Any suggestions/help will be appreciated.
Regards
Anser
Last edited: