Datagrid new record - columns display (null)

[rwttm001]

I have a datagrid bound to a datatable but on entering a new row all the columns display (null). I have a dataadapter with select and insert commands to display and insert relevant data. Is there a way to avoid this?

On a more general note is it considered best practice to insert data in this manner or to have a number of controls outside of the datagrid with an update button to update the grid and commit to the database?

TIA

 

[SqueakinSweep]

I guess the way around this is to look at the columns collection of the datatable. Each column can have a default value. I would guess that if you populate the default value, then that is what will be displayed on the new row.



Sweep
...if it works dont mess with it