Set default values for new DataRows in Ado.Net

[Jateen]

Hi,

I have a dataGridView on a WindowsForm. The DataSource for the bindingSource is a DataSet containing a table, say Orders.
When the addNewItem button on the navigator is pushed, I want to provide
some default values for columns in the new row in the grid: e.g.
CustomerNumber and OrderNumber (incremented by one).
What is the usual way of doing this?

[Zecho]

You should try the bellow given method for every column,

dataGridView1.Columns[0].CellTemplate.DefaultNewRowValue

[Reegan]

Check the given code,

 '
    ' Create a new row, set its values and add it.
    '
    Dim aNewRow As DataRow = myDataSet.Tables("Orders").NewRow
    
    With myDataSet.Tables("Orders")
        .Columns("Order_Date") = Today
        .Columns("Quantity") = 1
        . . .
        .Rows.Add(aNewRow)
    End With

[Reegan]

This is same as above mentioned code but it is just given in the different format, you can use this also,

 '
    ' Set default values.
    '
    With myDataSet.Tables("Orders")
        .Columns("Order_Date").DefaultValue = Today
        .Columns("Quantity").DefaultValue = 1
        . . .
    End With

    '
    ' Add the new row.
    '
    Dim aNewRow As DataRow = myDataSet.Tables("Orders").NewRow
    myDataSet.Tables("Orders").Rows.Add(aNewRow)