DataGridView problems

[Tony K]

When calling my form from within my MDI, I receive this error message.

InvalidOperationException was unhandled
An error occurred creating the form. See Exception.InnerException for
details. The error is: Index was out of range. Must be non-negative and
less than the size of the collection.
Parameter name: index

This error has to do with one line in particular.
Me.Inventory_TransactionsDataGridView.Rows(e.RowIn dex).Cells(0).Value =
Today()

If I rem this line out, the form loads. What I want to do is when a cell in
my DataGridView is changed, insert the date into the 1st column of my DGV.
Here are the first several lines of code:

Private Sub Inventory_TransactionsDataGridView_CellValueChange d(ByVal sender
As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs)
Handles Inventory_TransactionsDataGridView.CellValueChange d
If e.ColumnIndex = 1 Then 'when the part# combo box is changed
(2nd column)
Dim cnnProd As New
OleDbConnection(My.Settings.Inventory_management_d atabaseConnectionString)
'connection used from app settings
Dim cmmProd As OleDbCommand
Dim strSQL As String 'sql statement
Dim description As String
Dim drdProd As OleDbDataReader
Dim prodID As String
Dim unitPrice As Decimal
Me.Inventory_TransactionsDataGridView.Rows(e.RowIn dex).Cells(0).Value
= Today()
The last line is the problem line. In the DataGrid I have default cell
style set as DataGridViewCellStyle { Format=d }

What can I do to correct this exception problem that I am receiving?

Thanks,
Tony K

[Cor Ligthert[MVP]]

Tony,

Be aware that change events normaly are as well called when controls are
initializing, I would put a check around it to see if the index has a value
(probably it is -1 when initialing however I would look at this if I was you
in the debugger).

Cor

"Tony K" <no************@kingprogramming.comschreef in bericht
news:08**********************************@microsof t.com...

When calling my form from within my MDI, I receive this error message.

InvalidOperationException was unhandled
An error occurred creating the form. See Exception.InnerException for
details. The error is: Index was out of range. Must be non-negative and
less than the size of the collection.
Parameter name: index

This error has to do with one line in particular.
Me.Inventory_TransactionsDataGridView.Rows(e.RowIn dex).Cells(0).Value =
Today()

If I rem this line out, the form loads. What I want to do is when a cell
in my DataGridView is changed, insert the date into the 1st column of my
DGV.
Here are the first several lines of code:

Private Sub Inventory_TransactionsDataGridView_CellValueChange d(ByVal
sender As Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs) Handles
Inventory_TransactionsDataGridView.CellValueChange d
If e.ColumnIndex = 1 Then 'when the part# combo box is changed
(2nd column)
Dim cnnProd As New
OleDbConnection(My.Settings.Inventory_management_d atabaseConnectionString)
'connection used from app settings
Dim cmmProd As OleDbCommand
Dim strSQL As String 'sql statement
Dim description As String
Dim drdProd As OleDbDataReader
Dim prodID As String
Dim unitPrice As Decimal

Me.Inventory_TransactionsDataGridView.Rows(e.RowIn dex).Cells(0).Value =
Today()
The last line is the problem line. In the DataGrid I have default cell
style set as DataGridViewCellStyle { Format=d }

What can I do to correct this exception problem that I am receiving?

Thanks,
Tony K

[Tony K]

Yes, that was exactly the problem. e.RowIndex was set to -1 because there
were not any rows in the datagridview when the form loaded and because this
was in a CellValueChanged event that one line was executed. I bypassed this
problem by adding an if statement and checking if the number of rows were <=
0 then exit sub. Would that be an ok workaround?

Thanks,
Tony K

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:3E**********************************@microsof t.com...

Tony,

Be aware that change events normaly are as well called when controls are
initializing, I would put a check around it to see if the index has a
value (probably it is -1 when initialing however I would look at this if I
was you in the debugger).

Cor

"Tony K" <no************@kingprogramming.comschreef in bericht
news:08**********************************@microsof t.com...

>When calling my form from within my MDI, I receive this error message.

InvalidOperationException was unhandled
An error occurred creating the form. See Exception.InnerException for
details. The error is: Index was out of range. Must be non-negative and
less than the size of the collection.
Parameter name: index

This error has to do with one line in particular.
Me.Inventory_TransactionsDataGridView.Rows(e.RowI ndex).Cells(0).Value =
Today()

If I rem this line out, the form loads. What I want to do is when a cell
in my DataGridView is changed, insert the date into the 1st column of my
DGV.
Here are the first several lines of code:

Private Sub Inventory_TransactionsDataGridView_CellValueChange d(ByVal
sender As Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs) Handles
Inventory_TransactionsDataGridView.CellValueChang ed
If e.ColumnIndex = 1 Then 'when the part# combo box is changed
(2nd column)
Dim cnnProd As New
OleDbConnection(My.Settings.Inventory_management_ databaseConnectionString)
'connection used from app settings
Dim cmmProd As OleDbCommand
Dim strSQL As String 'sql statement
Dim description As String
Dim drdProd As OleDbDataReader
Dim prodID As String
Dim unitPrice As Decimal

Me.Inventory_TransactionsDataGridView.Rows(e.RowI ndex).Cells(0).Value =
Today()
The last line is the problem line. In the DataGrid I have default cell
style set as DataGridViewCellStyle { Format=d }

What can I do to correct this exception problem that I am receiving?

Thanks,
Tony K

[Cor Ligthert[MVP]]

Tony,

Very well, you can as well use a switch or add the handler after
initializing, however this one is simple enough,

Cor

"Tony K" <no************@kingprogramming.comschreef in bericht
news:28**********************************@microsof t.com...

Yes, that was exactly the problem. e.RowIndex was set to -1 because there
were not any rows in the datagridview when the form loaded and because
this was in a CellValueChanged event that one line was executed. I
bypassed this problem by adding an if statement and checking if the number
of rows were <= 0 then exit sub. Would that be an ok workaround?

Thanks,
Tony K

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:3E**********************************@microsof t.com...

>Tony,

Be aware that change events normaly are as well called when controls are
initializing, I would put a check around it to see if the index has a
value (probably it is -1 when initialing however I would look at this if
I was you in the debugger).

Cor

"Tony K" <no************@kingprogramming.comschreef in bericht
news:08**********************************@microso ft.com...

>>When calling my form from within my MDI, I receive this error message.

InvalidOperationException was unhandled
An error occurred creating the form. See Exception.InnerException for
details. The error is: Index was out of range. Must be non-negative and
less than the size of the collection.
Parameter name: index

This error has to do with one line in particular.
Me.Inventory_TransactionsDataGridView.Rows(e.Row Index).Cells(0).Value =
Today()

If I rem this line out, the form loads. What I want to do is when a
cell in my DataGridView is changed, insert the date into the 1st column
of my DGV.
Here are the first several lines of code:

Private Sub Inventory_TransactionsDataGridView_CellValueChange d(ByVal
sender As Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs ) Handles
Inventory_TransactionsDataGridView.CellValueChan ged
If e.ColumnIndex = 1 Then 'when the part# combo box is changed
(2nd column)
Dim cnnProd As New
OleDbConnection(My.Settings.Inventory_management _databaseConnectionString)
'connection used from app settings
Dim cmmProd As OleDbCommand
Dim strSQL As String 'sql statement
Dim description As String
Dim drdProd As OleDbDataReader
Dim prodID As String
Dim unitPrice As Decimal

Me.Inventory_TransactionsDataGridView.Rows(e.Row Index).Cells(0).Value =
Today()
The last line is the problem line. In the DataGrid I have default cell
style set as DataGridViewCellStyle { Format=d }

What can I do to correct this exception problem that I am receiving?

Thanks,
Tony K