Fill datatable columns with increasing numbers
How to fill datatable columns with increasing numbers - like the way in Excel?
Given a datatable with 2 columns : ID & Data.
Supposed that there are 100 EXISTING records.
EXISTING datatable
ID Data
---------------------
1 700
2 400
3 399
...
98 100
99 600
100 500
Resulting datatable
ID Data
---------------------
1 700
2 400
3 300
4 301
5 302
6 303
7 304
8 305
9 306
10 307
...
100 500
Given a form with 3 textfields: StartID, EndID & StartData.
How to fill the datatable (not form) column "Data", in the range of ID specified by user, with consecutive increasing numbers?
Example:
StartID --> 3
EndID -->10
StartData --> 300
Then, in the datatable, fill record with ID 3 with 300 (StartData). And fill the ongoing records (ID4, ID5, ID6...ID10) with consecutive increasing numbers?
Many many thanks for any help and discussion!
How to fill datatable columns with increasing numbers - like the way in Excel?
Given a datatable with 2 columns : ID & Data.
Supposed that there are 100 EXISTING records.
EXISTING datatable
ID Data
---------------------
1 700
2 400
3 399
...
98 100
99 600
100 500
Resulting datatable
ID Data
---------------------
1 700
2 400
3 300
4 301
5 302
6 303
7 304
8 305
9 306
10 307
...
100 500
Given a form with 3 textfields: StartID, EndID & StartData.
How to fill the datatable (not form) column "Data", in the range of ID specified by user, with consecutive increasing numbers?
Example:
StartID --> 3
EndID -->10
StartData --> 300
Then, in the datatable, fill record with ID 3 with 300 (StartData). And fill the ongoing records (ID4, ID5, ID6...ID10) with consecutive increasing numbers?
Many many thanks for any help and discussion!
Last edited: