Automatic creation of DB fields.

[tina2626]

i hv to increase my Database fields at runtime.
Example: i am hving fields like

1.company name

2. account number.

i hv to increase many account number for single company name.

how can i dynamically increase the field ie.(account number field).

FrontEnd - ASP.NET(C#)
BackEnd - SQL Server2005

[ck9663]

i hv to increase my Database fields at runtime.
Example: i am hving fields like

1.company name

2. account number.

i hv to increase many account number for single company name.

how can i dynamically increase the field ie.(account number field).

FrontEnd - ASP.NET(C#)
BackEnd - SQL Server2005

Increase size/length?

-- CK

[tina2626]

Increase size/length?

-- CK

Thankz for reply me,

i m not asking that, i m asking abt increase column,

like account number1, account number2....................

[Delerna]

Hi tina2626.
If i understand you correctly, your tables should be designed so that the quantity of account numbers for a company grows vertically.

IE
CompanyName Count AccountNo
Microsoft............1.......123456
Microsoft............2.......456789
AppleInc.............1......345677

etc

[tina2626]

Hi tina2626.
If i understand you correctly, your tables should be designed so that the quantity of account numbers for a company grows vertically.

IE
CompanyName Count AccountNo
Microsoft............1.......123456
Microsoft............2.......456789
AppleInc.............1......345677

etc

it should increase like this

ie

CompanyName........AccountNo1......AccountNo2..... ..AccountNo3 goes onnnn
Microsoft...................123456............2324 2343..............354543534
Microsoft...................456789............3423 423..................23424234


but it shld increase at runtime.

no account number creation at the time of table creation.

[ck9663]

You might want to follow Delerna's structure.

-- CK

[deric]

Yeah, I also suggest you design your table similar to what Delerma suggested. Your idea is so complex that it comes with several issues. If you need more help, let us know.