DataGrid blues...

I have a DataGrid control on Windows Form bound to a MS Access data table with 12 rows of data. The user requirement is that there should only ever be 12 rows of data in the data table. How can I turn-off the ability to add rows in the DataGrid? According to VB .net Reference books this feature is controlled at the data source, but I have had no luck finding the mechanism to do this in MS Access either. Help! Also, one of my DataGrid columns contains calculated values so I changed the ReadOnly property to True for that GridColumn. It works well in that the users cannot change the data in that column but they are still able to navigate to that column in the DataGrid. Any idea on how to prevent navigation to a particular GridColumn? The last time I worked with VB was way back in 1997 with VB 4. I seem to remember that DataGrids were easier to get along with back then... there was no coding to have a ComboBox column, for example, and I believe there was an AllowAdd property. Oh well. Thanks for any suggestions, Donna

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski22y ago
To avoid adding records set AllowNew=false in DefaultView of table used byDataGrid. You can inherit Your DataGrid and create usful property: public DataView DataView { get { if(this.ListManager==null || this.ListManager.List==null) return null; return this.ListManager.List as DataView; } } To avoid navigating to computed fields (it's a DataGridTextBoxColumn, I think) try to set TextBox properties eg. Enabled=false
0