I have a need to input a large tab delimited text file, which I will parse
to check it has the expected columns, before allowing the user to submit it
to the database. The user may paste the file into a textbox, or upload it
(haven't decided yet).
The problem I have is that the text file consists of around 3000 lines, and
I want to display the formatted columns to the user before submitting it to
the database (perhaps allowing them to edit some fields if they want, before
clicking submit).
Clearly 3000 lines is too much to display on one gridview page - so the
question is::
How can I page the data in the grid, without having to parse the text each
time - i.e. where can I 'store' the parsed text so that I use that during my
paging operations (prior to inserting it into the database)?
Thanks,
JJ
JJ,
What I'd consider doing is to read and parse the file into a
DataTable, and use this to bind to a pageable grid.
Peter
inputing, paging, sorting, a large text file ... I have a need to input a large tab delimited text file, which I will parse... to check it has the expected columns, before allowing the user to submit it ... I want to display the formatted columns to the user before submitting it to ... the database (perhaps allowing them to edit some fields if they want, ... (microsoft.public.dotnet.framework.aspnet)
Re: Architectural advice needed on client-side browser scripting ... can easily serialize a DataTable (in this case the INFORMATION_SCHEMA views ...easily parse that XML to load listboxes or arrays. ... on a database chosen parse it for all tables in this database ... list all tables in the chosen database as interactive interface... (comp.lang.javascript)
Re: Parsing and storing formulas ... you could easily store different views/stored ... >I was wondering how I can parse a mathematical formula in a storable way. ... > be stored for in the database.... > The second idea is to represent the formula as a tree.... (microsoft.public.dotnet.languages.csharp)
Re: Running queries on large data structure ... |> nested data structures and allows the user to run quick queries on the ... | the users need to run queries on that within seconds. ... | ugly to convert it into some relational shape for the database)... | (Read the data every now and then, parse it, write the nested Python ... (comp.lang.python)
Re: inputing, paging, sorting, a large text file ... To recreate it I need to parse the text again, ... I want to display the formatted columns to the user before submitting ... the database (perhaps allowing them to edit some fields if they want, ... How can I page the data in the grid, without having to parse the text ... (microsoft.public.dotnet.framework.aspnet)
