DataColumn Class and AutoIncrement

[Sam]

Hi all

I have a simple datagrid form which has 4 columns. The first one is used
just like a key and the other threes allow user to enter numbers. The
problem that I am having is that when I click on a cell of a new row but
decide not to enter a value and go back to any of the previous rows for
editting or whatever reason, the value of the new row will be incremented by
value of the AutoIncrementSt ep

Here is the problem I have

When I loaded the table for a first time, the first row has a value of 0 in
column 1. I then entered 5, 5, 5 in column 2, 3, and 4 respectively. I
clicked on the 2nd row (new row), a new value of 1 was in column 1
(everything is fine up to this point). Instead entering values for column 2,
3 and 4, I went back to my row 1 to edit the data. I then came back to my
second row and enter values for my columns 2, 3 and 4. I noticed that the
value of row 2 is now 2 not 1 and it seems like the number keeps on
incrementing.

Can we make the number increment only when an actual new row is created ? I
have included the code for column 1, all others are pretty much the same.

Dim mInputTable As New DataTable

Dim IDColStyle As New DataGridTextBox Column

Dim mIDCol As New DataColumn

'Initialize node column

mIDCol.ColumnNa me = "Node ID"

mIDCol.Caption = "Node ID"

mIDCol.AutoIncr ement = True

mIDCol.AutoIncr ementSeed = 0

mIDCol.AutoIncr ementStep = 1

mIDCol.DataType = GetType(Integer )

IDColStyle.Mapp ingName = "Node ID"

IDColStyle.Null Text = ""

IDColStyle.Widt h = 72

IDColStyle.Read Only = True

IDColStyle.Head erText = mIDCol.Caption

TableStyle.Grid ColumnStyles.Ad d(IDColStyle)

dgdInput.TableS tyles.Add(Table Style)

dgdInput.DataSo urce = mInputTable

[Cor Ligthert]

Sam,

I dont know why it happens in this case, however in my opinion is what is
the value of an autoincrement number is not important at all.

The value will be setted to a new number at update time, where when other
users has changed as well some row the start point will than be the actual
seed point of the database.

It is good to set the seed, the increment of that and the steps by the way.
And than use -1 for all.

http://msdn.microsoft.com/library/de...ementTopic.asp

I hope this helps something?

Cor
"Sam" <qd*@datawave.c a>

Hi all

I have a simple datagrid form which has 4 columns. The first one is used
just like a key and the other threes allow user to enter numbers. The
problem that I am having is that when I click on a cell of a new row but
decide not to enter a value and go back to any of the previous rows for
editting or whatever reason, the value of the new row will be incremented
by value of the AutoIncrementSt ep

Here is the problem I have

When I loaded the table for a first time, the first row has a value of 0
in column 1. I then entered 5, 5, 5 in column 2, 3, and 4 respectively. I
clicked on the 2nd row (new row), a new value of 1 was in column 1
(everything is fine up to this point). Instead entering values for column
2, 3 and 4, I went back to my row 1 to edit the data. I then came back to
my second row and enter values for my columns 2, 3 and 4. I noticed that
the value of row 2 is now 2 not 1 and it seems like the number keeps on
incrementing.

Can we make the number increment only when an actual new row is created ?
I have included the code for column 1, all others are pretty much the
same.

Dim mInputTable As New DataTable

Dim IDColStyle As New DataGridTextBox Column

Dim mIDCol As New DataColumn

'Initialize node column

mIDCol.ColumnNa me = "Node ID"

mIDCol.Caption = "Node ID"

mIDCol.AutoIncr ement = True

mIDCol.AutoIncr ementSeed = 0

mIDCol.AutoIncr ementStep = 1

mIDCol.DataType = GetType(Integer )

IDColStyle.Mapp ingName = "Node ID"

IDColStyle.Null Text = ""

IDColStyle.Widt h = 72

IDColStyle.Read Only = True

IDColStyle.Head erText = mIDCol.Caption

TableStyle.Grid ColumnStyles.Ad d(IDColStyle)

dgdInput.TableS tyles.Add(Table Style)

dgdInput.DataSo urce = mInputTable