This is my metadata table. I have entered values also.
CREATE TABLE [dbo].[tr_doc_content] (
[doc_contentid] INT IDENTITY (1, 1) NOT NULL,
[doc_typeid] INT NOT NULL,
[doc_contenttypelabel] NVARCHAR (500) NULL,
[doc_ctrltype] NVARCHAR (500) NULL,
[doc_fieldtype] NVARCHAR (500) NULL,
[doc_isrequired] BIT NULL,
[doc_isactive] BIT NULL,
CONSTRAINT [PK_tr_doc_content] PRIMARY KEY CLUSTERED ([doc_contentid] ASC),
CONSTRAINT [FK_tr_doc_content_tm_doc_type] FOREIGN KEY ([doc_typeid]) REFERENCES [dbo].[tm_doc_type] ([doc_typeid])
);
Please find below sample values.
1 1 PAN number textbox text True True
2 1 DOB textbox date True True
3 2 Passport number textbox text True True
4 2 PassportIssuedate textbox date True True
5 2 PassportExpiry textbox text True True
I main page i have one dropdown box and i have binded that dropdownbox with PAN(id is 1),Passport(id is 2) Etc. so when i select PAN, below i want to render or genereate view with fields PAN,DOB or if i select Passport(2) i want to render Passport Number,PassportIssuedate and PassportExpiry. Also i have mentioned textbox type to hold those values. Even those Values i want to check and i want to render accordingly. Please suggest how to achieve this?