Updating a dynamic recordset. Best way...

[Ant]

Hello, I'm developing a program that will include a window showing current &
previous records using a scrollable recordset. I need to add records to the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:

i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:

ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need to
declare the scope of the data object global, (something I don't want to do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).

In short, what is the most acceptible method for data input to a dynamic
recordset?

Thanks for your thoughts on this, Ant

[Cor Ligthert]

Ant,

Although ADODB is usable in dotNet is mostly used in that ADONET.

In this international dotnet Newsgroups is I thought only one person giving
really consequently answers on ADODB questions.

The newsgroup for ADODB is more.

microsoft.public.data.ado

Probably you get there your answer much quicker.

I hope this helps something

Cor

"Ant" <An*@discussions.microsoft.com>

Hello, I'm developing a program that will include a window showing current
&
previous records using a scrollable recordset. I need to add records to
the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:

i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:

ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need
to
declare the scope of the data object global, (something I don't want to
do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).

In short, what is the most acceptible method for data input to a dynamic
recordset?

Thanks for your thoughts on this, Ant