Re: best way to tackle issue with writing Data, Appending Data and Rea



Uh, why does the data have to be written to a file???

--
Robbe Morris [Microsoft MVP - Visual C#]
..NET PropertyGrid Control - ListBox, ComboBox, and Custom Classes
http://www.eggheadcafe.com/tutorials/aspnet/270e9432-d236-47e7-b1af-5cd3abe27a75/net-propertygrid-control.aspx




"LW" <LW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:6739832A-25D3-4AF1-9761-8277DF4A55D5@xxxxxxxxxxxxxxxx
Hello!
I need some input as I am not quite sure the best way to approach what I
need to do.....

I am collecting information from users in a Forms Application but also have
data that I have read from my database and the two are related. As I read the
data from the user (every time they hit Enter), I need to be able to write
the data to a file on my machine (so I need to be able to append to this
file) and also display it in a DataGrid. Once the user is finished, I need to
write all that data to a table in my database. I am not sure what kind of
file I should use, a flat file or an xml file since I need to be adding this
file but also displaying it. I thought of writing to an xml file as that
would help me in my display of data in a grid.

Steps are:
1. Read data and store in a DataSet.
2. Read user input and store user input and DataRow to a file.
Also, display user input and data row in a DataGrid.
3. Continue with step 2 until done. As user enters data, keep appending to
the file on the file system and also refresh the DataGrid.
4. When done, write the file to a table in the database.

I am using SQL2000, VS2005 and C#.

Your thoughts please!!!

LW

.



Relevant Pages

  • Re: How to refresh a datatable??
    ... then you don't need to requery the database ... > But I want to display the table IncomeProducts in the DataGrid like that: ... > And now I display this View on the DataGrid ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to refresh a datatable??
    ... Hello Bill! ... display all the updated data in the DataGrid (DataGrid is used to display ... > that your update is successful, the database and the local datatable ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to avoid users pick same case
    ... The case number will be removed from the datagrid. ... I am using ADO and Access database which is located on the ... In a 'general' table I have a field named InUse. ... I display a message and skip. ...
    (microsoft.public.vb.general.discussion)
  • CANT see EDIT UPDATE CANCEL Buttons for DATAGRID
    ... display records from a database based on a user input, ... records are displayed where company name matches with user input. ... I need the datagrid to be editable. ... .NET "Using a datagrid for reading & writing data to database" or it was some ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: User input directly into datagrid or table?
    ... My database table will not be in the ... same format as the datagrid that I wish to display to the user. ...
    (microsoft.public.dotnet.framework.aspnet)