How to edit/save data on a form?

[vbhvw]

Hello,

I would like to manually edit some data during runtime and save/load it to/from any file.

I think about a kind of Grid-component like DataGrid but it must be editable by an operator during runtime without being connected to any database.

What kind of object do I need?
I tried many but can't find an editable one (without a connected database).

regards,

Henk

 

[dtqbterror]

Look into disconnected into a disconnected recordset, databinding and datagrids.

http://www.chiefscoalition.com

 

[SmallTalker]

Hi!

storage media:

The next best format to save your data to a file (a database is a file too, but you dont't want to use a database) is to store it in a XML-File.

data display:

There are several vb-controls. The best Grid for vb6 is TrueDBGrid from Apex Software. It supports an unbound mode and an array mode. MS-Flexgrid couls be a "free" alternative.

SmallTalker

 

[BobRodes]

Also, version 5.0 of the Microsoft Data Bound Grid supports an unbound mode.

 

[strongm]

As dtqbterror suggests, a disconnected recordset would be a good approach here. And you can save it to (and load it from) any file by using ADO's stream object (write the disconnected recordset to the stream, then save the stream). With this method you can even take on board SMallTalker's suggestion, and elect to have the stream saved as XML

 

[BobRodes]

strongm, why shouldn't you just use the .save method of the recordset, and save it as an xml file that way, rather than using an intermediary stream object?

 

[strongm]

Habit ...

I generally use the stream object because it is more flexible - but in this case the standard Save would be equally applicable

 

[BobRodes]

Aha, very good.