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/tutorials...d-control.aspx
"LW" <(E-Mail Removed)> wrote in message
news:813AD7B1-C763-492F-952C-(E-Mail Removed)...
> 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#" wrote:
>
>> 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...d-control.aspx
>>
>>
>>
>>
>> "LW" <(E-Mail Removed)> wrote in message
>> news:6739832A-25D3-4AF1-9761-(E-Mail Removed)...
>> > 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
>>
>>
Similar Threads
