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.......1 23456
Microsoft...... ......2.......4 56789
AppleInc....... ......1......34 5677

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.......1 23456
Microsoft...... ......2.......4 56789
AppleInc....... ......1......34 5677

etc

it should increase like this

ie

CompanyName.... ....AccountNo1. .....AccountNo2 .......AccountN o3 goes onnnn
Microsoft...... .............12 3456........... .23242343...... ........3545435 34
Microsoft...... .............45 6789........... .3423423....... ...........2342 4234


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.