DataGridView

Baily

Hallo,
In a DataGridView I would like to increase the value in one of my datafields if a new row is addd.

Index | Description       | ItemCode | etc.
233    | First record       | 1234545  | etc.
234    | Second record | 1234568   | etc.
          | Third record      |                   |
If I add one row to the DataGridView I would like to automatically give the value of 235 to the Index variable of the third record in the new row. ( i.e previous Index value + 1)
Is this possible?

Kind Regards,

Baily

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

minakshi16y ago
Accepted answer
Hello,
You can use following code
for (int i = 0; i < datagridview1.Rows.Count; i++)
{
datagridview1.Rows[i].Cells[0]=i+1;
}
regards,
Minakshi
theLizard16y ago
Then all you need to do is rec.index = (recordItems[recorditems.count-1].index++); //gets the index of the last item added to list increments it by one then assigns it to the new items index.
Baily16y ago
No required, as long as I can increase the value of the index when adding a line (record).

Regards,
Baily
theLizard16y ago
Why do you need to show the indexes?
Sam Hobbs16y ago
There are a few ways to do that.

If the DataGridView is bound to a database, then you can set the identity property of the column in the database table, or an equivalent property.

Otherwise you can calculate the new Index value and supply it in an event handler; either the RowsAdded or the DefaultValuesNeeded event. I am sorry that I am not sure which event would be best; my guess is that the DefaultValuesNeeded event would be the most appropriate.

For determining the new Index value, if the DataGridView is sorted by the Index value, then you simply need to access the last row to get the greatest Index value currently. Or you could process the DataGridView when it is first filled with data and store the maximum Index value as a form member and then increment that value each time another record is added.