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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Robbe,
The requirement is that a file be written to disk incase of net work issues
as that has happened in the past. So, is what I am thinking possible? Can I
modify a DataSet in memory and write it to an xml file? Can an xml file be
easily appended?

LW

Robbe Morris - [MVP] C# said:
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/tutorial...af-5cd3abe27a75/net-propertygrid-control.aspx




LW said:
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
Click to expand...
Click to expand...
 
Hmmm, if it is a windows forms application, whatever you had in memory
would stay in memory should you loose database connectivity. That said,
the DataTable and DataSet classes have easy methods to read and write
their contents to disk as xml.

--
Robbe Morris [Microsoft MVP - Visual C#]
..NET PropertyGrid Control - ListBox, ComboBox, and Custom Classes
http://www.eggheadcafe.com/tutorial...af-5cd3abe27a75/net-propertygrid-control.aspx




LW said:
Robbe,
The requirement is that a file be written to disk incase of net work
issues
as that has happened in the past. So, is what I am thinking possible? Can
I
modify a DataSet in memory and write it to an xml file? Can an xml file be
easily appended?

LW

Robbe Morris - [MVP] C# said:
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/tutorial...af-5cd3abe27a75/net-propertygrid-control.aspx




LW said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top