DataGridView Default Value

[klornpallier]

I guess this is really easy if you now how but how do you add a default value to a DataGridView cell. I tried the following off msdn but it dont work:

Private Sub VARIABLE_INPUTDataGridView1_DefaultValuesNeeded(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowEventArgs) Handles VARIABLE_INPUTDataGridView1.DefaultValuesNeeded


With e.Row
.Cells("LOCK_USER").Value = "0"
End With

End Sub

 

[RiverGuy]

Set this in your DataTable

YourDataTable.Columns("YourColumn").DefaultValue = "0"

 

[klornpallier]

Thank you I tried as you described in the forms load event but the default value does not appear in the datagrid:

KPPERSON.VARIABLE_INPUT.Columns("PERIOD").DefaultValue = "2"

I get the error below:

Object reference not set to an instance of an object.

Any Idea

 

[RiverGuy]

My guess is that you don't really have a column named "PERIOD." Maybe you need to try "Period"?

 

[klornpallier]

Spiffing! Cheers