Simple DB Editor

[coox]

What's the quickest and simplest way to make a db editor? I mean, could you use a Data control, link it to your db, then link a grid of some sort (flexgrid type thing) to the data control and do your editing from there? And if so, would the users actions in the grid be automatically entered into the db? I'm talking an access type db here...

Cheers!!!!!!

[alex_read]

What were you thinking of using it for? Small / large program?

Alex

[coox]

Just to maintain a database of probably no more than 30 records with 2 fields to each.

[Mark Sreeves]

Take a look at the Visdata sample which comes with VB and use the bits you need.

[alex_read]

If there are only 2 fields, I would just use the Data control and 2 text boxes.

Apart from this, for slightly larger programs, I would use the datagrid control (from selecting project...references menu).

Draw the data control onto your form, in the properties window, click into the databasename property & select the database, recordset (ie a table), and recordsource (ie - the name of the table) from there.


After that, you can set the datagrid's datasource as the same name as the data control and use either ADO or DAO to alter the tables etc.

Hope this helps!

If you are planning to use a grid to display your Data and allow users to edit, use a DBGrid instead of the FlexGrid. And yes, the users editing of the data will be automatically saved.