Click to See Complete Forum and Search --> : Need help on VB6 datagrid


davidbandinelli
April 5th, 2001, 08:25 AM
I am using a VB6.0 datagrid bound to an ADO data control;
I cannot modify the database from this grid (it is only used to display a query result).
My question is, can I remove rows from the grid without touching the underlying database ?
I've noticed that there is not a "row" collection that I can manipulate, but is there any trick to remove, or to hide some rows (selected by the user) from the grid ?
Thank you very much

Iouri
April 5th, 2001, 09:10 AM
if you use a bound grid, you cannot remove row from it without affecting the db. That what bound means. If you want more flexibility in your programming I don't recommend to use adodc and bound grid at all. Create a recordset and enter dat to the unbound grid. Iprefer MSFlexGrid.

Iouri Boutchkine
iouri@hotsheet.com

Cimperiali
April 5th, 2001, 09:20 AM
(add this to Iouri answer)...and you will have to code more -this is what unbound controls means-, but you will gain the full control on your grid. I too prefer MsFlexgrid, even if it is not perfect, of course. I suggest you to think about paging your data...

Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.