selection from db and insertion into a form.

[Ryan McConnell]

Is there any way i can select a number of records from a database and
display then. Then give the user the ability to double click on any
record to add the contents to a text box. (i will format the contents
as xml)
Is there anyway of interfacing with a datagrid other than using the
Grid.Item(int, int) approach? as this would be inefficient.
Another method id considered using was to populate a listBox from the
database and to enable a click to load the info into a form page.
Which of these methods would be the best?

Thanks
Ryan McConnell

 

[Cor]

Hi Ryan,

Because there are all thos posibilities, there is not a general the "best"
than there was only one, it is your decission what is for you the best.

But as I see your question, I would just start with a datagrid,

And when that does not fit, you can always change.

It is always posible to bring an item from the datagrid to a textbox, but
there are so many possibilities to do that, that it needs something a book
to tell you that

Just my thougth about this.

Cor