Hi
I have 3 tables. How to create Classes & link them . All will be used in 1 View. I am using Ado.Net.
1. OrderHeader
[No] [nvarchar](20) NOT NULL, [DocDate] [datetime] NULL, [Gross_Amount] [decimal](18, 2) NULL, [Tax_Amount] [decimal](18, 2) NULL, [Others] [decimal](18, 2) NULL, [Net_Amount] [decimal](18, 2) NULL, [Status] [nvarchar](3) NULL,
2. OrderLines
[DocumentNo] [nvarchar](20) NOT NULL, [ItemCode] [nvarchar](25) NOT NULL, [Quantity] [decimal](18, 2) NOT NULL, [Uom] [nvarchar](5) NOT NULL, [PricePerUnit] [decimal](18, 2) NULL, [GrossAmount] [decimal](18, 2) NULL, [NetAmount] [decimal](18, 2) NULL
No & DocumentNo are link between the tables.
3. Item
[Id] [nvarchar](25) NOT NULL, [Description] [nvarchar](100) NULL,
Thanks