Multiple fields of one record into datagrid for Visual Basic.

[Syed Zubair]

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

[rproffitt]

First, VB6 is over 28 years ago and good luck buying a license today as well as installing the system on today's Windows.

I'd move to vb.net and for your data grid I'd look at the DataGridView noted at https://www.dotnetperls.com/datagridview-vbnet

[Syed Zubair]

Very simple.
Create comprehensive table of Customer requirement likewise.
Customer Name
Contact No
Address
Shirts
Trousers
QtyShirts
QtyTrousers

For this, you have to select a datagrid control and connect it with ADODC, your all records will be appeared here at run time
now execute,

adodc1.recordsource="Select shirts, trousers, qtyshirts, qtytrousers from Tailor(tablename)

above line may be written on command control button.

here is..

[rproffitt]

"According to https://learn.microsoft.com/en-us/previous-versions/visualstudio/visual-basic-6/visual-basic-6-support-policy although the VB6 runtime and certain files continue to be supported the VB6 IDE is NOT supported by Microsoft in Windows 11."

As we are moving to Windows 11 now, I wonder how folk like you are going to avoid upgrading from VB6.