How to disable creation of new rows in a DataGridView?

Question

This is about a .NET Windows Forms application written in C#. I have a DataGridView which is connected to a database. It displays the contents of a selected table.

Now if there are 4 rows in that table, it will display 4 rows. After this I am able to enter the 5^th row in the datagrid view. It should be avoided. Now I have to disable creation of a new row. How can I do it?

score 39 · Accepted Answer · edited Jun 20 '13 at 14:08

39

Simply set the DataGridView.AllowUserToAddRows property to false.

edited Jun 20 '13 at 14:08

MarkJ

30,070
5
68
111

answered Apr 19 '10 at 08:57

stakx - no longer contributing

83,039
20
168
268

score 10 · Answer 2 · answered Apr 19 '10 at 08:57

10

Set

dataGrid.AllowUserToAddRows = false

answered Apr 19 '10 at 08:57

Axarydax

16,353
21
92
151

score 2 · Answer 3 · answered Feb 12 '18 at 11:01

2

In XAML, set the property CanUserAddRows to false. For example see the following code

 <DataGrid   CanUserAddRows="False">

 </DataGrid>

answered Feb 12 '18 at 11:01

Binoy Pilakkat

150
1
6

1

This is the correct answer in WPF, but I don't think it works in Windows Forms. It helped me out tho in WPF – Lonefish Aug 21 '20 at 12:03

score -6 · Answer 4 · edited Dec 18 '11 at 03:45

-6

Do this:

this.dataGridView1.DataBindings.Clear();
this.dataGridView1.DataSource = (set the original source back)

edited Dec 18 '11 at 03:45

Mark Hall

53,938
9
94
111

answered Dec 18 '11 at 02:50

a user

1

How to disable creation of new rows in a DataGridView?

4 Answers4

Linked