records from one DataGrid to another DataGrid in visual basic 6

Dear All,

I have a project where I have to transfer records from one datagrid control to another datagrid control (like list.additem formation)
I have two datagrids in my project and both are connected with ADODC. First datagird showing record at run time, when select a row and click to commandbutton to shift the selected record to Second grid.
I have tried my level best but remained failed. Kindly support
Syed Zubair Ali

Multiple fields of one record into datagrid for Visual Basic.

Dear Team,
I am underprocess of a working for Tailor software where i need your kind and appreciation advise.

I have fields of cloth like shirt and trouser of a customer, when i enter the records into database it is working well if single shirt or single trouser.

I want if a customer needs two shirts and three trousers it must be shown into data grid with rows wise as mentioned below.

     Roger          Trouser
                                     Trouser
                                     Trouser
                                     Shirt
                                     Shirt