would stay in memory should you loose database connectivity. That said,
"LW" <LW@discussions.microsoft.com> wrote in message
news:813AD7B1-C763-492F-952C-C398F96FE112@microsoft.com...
> 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/aspnet/270e9432-d236-47e7-b1af-5cd3abe27a75/net-propertygrid-control.aspx >>
>>
>>
>>
>> "LW" <LW@discussions.microsoft.com> wrote in message
>> news:6739832A-25D3-4AF1-9761-8277DF4A55D5@microsoft.com...
>> > 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
>>
>>
