Search Data in CSV-File and show in a table and later in a form

Discussion in 'Questions (Windows Mobile)' started by JOTHA, May 16, 2009.

  1. JOTHA

    JOTHA Well-Known Member Licensed User

    Hi forum,

    i have a little problem, maybe someone can help me. :sign0085:

    I want to search Data out of a CSV-Table and show them first in a table and later on the form. This application should have the following features:

    1) Searching over a mask in the CSV-File. It should be possible to search for fragments in the text in all fields ("*").

    2) Show the found data in a table, sorted by ABC or Numbers (sort.asc)

    3) Should be able to choice one dataset out of the table (maybe the best way is to use "listview.dll" from Filippo for that?)

    4) show dataset in the form1

    I attached a small example.

    If there is anybody who can give me tips - THANK YOU in advance!

    Attached Files:

  2. Erel

    Erel Administrator Staff Member Licensed User

    How large is the CSV file?
    You can load it to a table and then use Table.Filter and Table.TableSort to arrange the data.
    You can also convert the CSV file to a SQLite db which is more powerful.
  3. JOTHA

    JOTHA Well-Known Member Licensed User

    Hello Erel,

    thank you for your fast reaction.

    The CSV file is about 10.000 datasets (lines) in 10 rows.
    I know about this solution, but it would take too long time to load the file and to search the "one" data which is needed.
    1) The data could change every week or every 14 days, because there is a pricing list which includes welding-metal and the prices are different sometimes. So I had to convert the data all the time and it this would be not very comfortable.

    2) For SQL-Programming i need more knowledge ...

    I think, the way to search the data and fill a table, then select one out of it might be the best way for the moment, isn´t it? :confused:

  4. Erel

    Erel Administrator Staff Member Licensed User

    I recommend you to learn the basics of SQL. It is not too complicated and will allow you to do many things with your data.
    There are many resources available online about SQL. Here is one: SQL Syntax
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice