Lookup Table to select (or multi-select) for edit

[abc my vclass]

I want to write a form control to lookup some tables fields from
database,
let users to select one record (or multi-select more records) under
win-form
environment for fill some fields of parent forms. Is datagrid control
support multi-select features? Is datagrid control support paging
feature to
access tables (because some tables has more than 100000 records!!)?
Has any
best ideas?

[Ken Tucker [MVP]]

Hi,

Yes the datagrid control supports mutiselect. No the
windows forms datagrid does not support paging.

I would limit the data i load from database. I can not see
a user needing 100000 records. If you load it in to a dataset all the data
will be in memory. I would query the database to get the data the user is
looking for.

Ken
-------------------
"abc my vclass" <my********@myclass.com> wrote in message
news:eI**************@TK2MSFTNGP09.phx.gbl...
I want to write a form control to lookup some tables fields from
database,
let users to select one record (or multi-select more records) under
win-form
environment for fill some fields of parent forms. Is datagrid control
support multi-select features? Is datagrid control support paging
feature to
access tables (because some tables has more than 100000 records!!)?
Has any
best ideas?

[abc my vclass]

Are here any sample code?


"Ken Tucker [MVP]" <vb***@bellsouth.net> ¦b¶l¥ó
news:e6****************@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...

Hi,

Yes the datagrid control supports mutiselect. No the
windows forms datagrid does not support paging.

I would limit the data i load from database. I can not see a user needing 100000 records. If you load it in to a dataset all the data will be in memory. I would query the database to get the data the user is
looking for.

Ken
-------------------
"abc my vclass" <my********@myclass.com> wrote in message
news:eI**************@TK2MSFTNGP09.phx.gbl...
I want to write a form control to lookup some tables fields from
database,
let users to select one record (or multi-select more records) under
win-form
environment for fill some fields of parent forms. Is datagrid control support multi-select features? Is datagrid control support paging
feature to
access tables (because some tables has more than 100000 records!!)?
Has any
best ideas?