How to insert "multiple Filed" Value into same column of table in "MVC4"?

See more:

C#

Javascript

SQL

jQuery

MVC4

I need your help. I need to insert "Multiple field values in same Column".

I will explain my issue clearly.

I have "CustomerMaster". It contain TaxDetails. The TaxDetails contains six Fields. TinNo, CstNo, ExciseRegNo,PanNo,ServiceTaxNo, CinNo.

The Database contains the three tables to save Tax Details.

1)TaxField, 2)TaxInfo, 3)TaxInfoTaxField

1)TaxField

TaxFieldID, DisplayName , PrintName.

2)TaxInfo

TaxInfoId, DisplayName, PrintName

3)TaxInfoTaxField

TaxInfoTaxFieldId, TaxInfoID, TaxFieldID, FieldValue.

Now i need to save that six Fields(**TinNo, CinNo, PanNo, CstNo, ExciseRegNo, ServiceTaxNo )**in these Tables.. I will explain Clearly.

In TaxFieldTable contain TaxFieldID, DisplayName,PrintName. In this Table I have Defalut value . That is

TaxField table

TaxFieldID = 1, DisplayName = TinNo, PrintName = TinNo.

If "TinNo" means its valuse is "1" Same as like CstNo and PanNo.

TaxInfo table

TaxInfoID = 1.1, DisplayName = Kallam Spinning Mill, PrintName = Kallam Spinning Mill.

TaxInfoTaxField table

TaxInfoTaxFieldId = 1.1.1, TaxInfoId= 1.1, TaxFieldId = 1, FieldValue = 1234567

(i am able to paste the table)

In View I have Six Fields.

If i insert TinNo ,CstNo, PanNo, ExciseRegNo, CinNo,ServiceTaxNo, values in view it need to save these six field values in FieldValue of TaxInfoTaxField Table. and ID of TinNo(Tinno = 1) , CstNo(CstNo = 2) have to save in TaxFieldID of TaxInfoTaxField Table.

I need to save these six Fields in single Column and there id's in TaxFieldID Column.I think its create 6 rows for a each Customer. I want to know " How to Insert Multiple value in Single Column in Db using MVC4? I need solution for this problem . its very urgent dudes.

Anyone please reply.. Thanks





Thanks in advance..