[C#] problem with auto number in datatable

middleman

Dear All,

I having a datatable with the auto number, I need to know that how to restart/recalculate the auto number when a particular row being removed for example :
I have 5 row of record 1,2,3,4,5
When the row 2 being removed. i wanted it to show 1,2,3,4 instead of 1,3,4,5

Thank for helping

middleman

Dear All,

I having a datatable with the auto number, I need to know that how to restart/recalculate the auto number when a particular row being removed for example :
I have 5 row of record 1,2,3,4,5
When the row 2 being removed. i wanted it to show 1,2,3,4 instead of 1,3,4,5

Thank for helping

Plater

Hide the autonumber column and number them yourself?
You cannot manually enter values in the autonumber column of a table.
If you delete one, you're stuck with a gap.

middleman

Quote:

Originally Posted by Plater

Hide the autonumber column and number them yourself?
You cannot manually enter values in the autonumber column of a table.
If you delete one, you're stuck with a gap.

Thanks for yoru reply .but how do number myself since the data is generated dynamically.

Plater

Loop through the rows and assign the number to a spare column?

middleman

Quote:

Originally Posted by Plater

Loop through the rows and assign the number to a spare column?

I don't know how to do it with the suggestion stated by you.

actaully my datatable is use to store shopping cart item.So the autonumber column is create/updated when one item added in.However when the user removed item from the cart the autonumber column become weird as i stated ealier

kunal pawar

In database thats not posible, Either you have to use number in place of auto number fieled and put next numbers by useing code or trucate all records and again save records newly

middleman

Quote:

Originally Posted by kunal pawar

In database thats not posible, Either you have to use number in place of auto number fieled and put next numbers by useing code or trucate all records and again save records newly

Thank for your reply . One thing I need to make it clear. what I try to do with auto number is on datatable is not on database.

I aleready solved the problem by trasnfer it to another temporary datatable

Plater

If you make a spare column in your in your set of data, you can loop through the rows and assign a counter index to each of, for display purposes only

[C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

re: [C#] problem with auto number in datatable

Similar C# / C Sharp bytes

/bytes/development

/bytes/it

/bytes/about