Preventing a new row from appearing in a DataGridView before current row is filled in?

Question

I have a DataGridView in my WinForm application in C# 3.5.

AllowUserToAddNewRow property is set true. When user types any text in DataGridView, another new row is automatically added to DataGridView. I do not want this new row added until some checks are performed on the current row and all the necessary information has been filled in there.

Example : I have a DataGridView with a blank row: DataGridView with one blank row

When I begin typing a new row is added, which is too soon:

What I want is that the new row be added only after the user enters a Quantity:

score 5 · Answer 1 · answered Apr 03 '12 at 07:06

5

Set AllowUserToAddNewRow = false Now add a blank row initially to your datasource for eg. if you are binding the DataGridView to a DataTable called DT then just before

dataGridView1.DataSource = DT;

Do something like

 DT.Rows.Add(DT.NewRow());

This is to have one blank row initially so that the first record can be entered. Then handle the event dataGridView1.CellEndEdit, in that event write something like this:

void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
    {
        if (e.ColumnIndex == 1)//The index of your Quantity Column
        {
            int qty = (int)DT.Rows[e.RowIndex][e.ColumnIndex];
            if (qty > 0)//Your logic if required
            {
                DT.Rows.Add(DT.NewRow());                    
            }
        }
    }

answered Apr 03 '12 at 07:06

Arif Eqbal

3,068
1
18
10

Sorry could not understand you...what do you mean suppress row add? If you mean that the new row should not be added in DataGrid then just Set AllowUserToAddNewRow = false as I mentioned in the first line above – Arif Eqbal Apr 04 '12 at 09:55
I want Row should add conditionally – Haider Ali Wajihi Apr 05 '12 at 07:31
2

I think thats what we are trying to achieve here. The idea is that Rows will never add automatically (you achieve this by setting AllowUserToAddNewRow to False, I have a feeling you are missing this). Once you set this property to false new rows will never add, so how do you then add new rows? You add new row to the underlying datasource and you do that "conditionally" i.e. when say Qty is greater than 0 as I showed in the CellEndEdit ebent handler code above. – Arif Eqbal Apr 05 '12 at 11:27
yeh! i have achieved this solution, but in this solution we don't have any NewRow so we can not identify which row is new. but although i have settled my problem with this solution, thank you – Haider Ali Wajihi Apr 05 '12 at 13:41

Stefan Huy · Answer 2 · 2016-02-28T22:56:57.740

Basically it's a simple play with some events and enabling/disabling the AllowUserToAddRow property:

public Form1()
        {
            InitializeComponent();
            //creating a test DataTable and adding an empty row
            DataTable dt = new DataTable();
            dt.Columns.Add("Column1");
            dt.Columns.Add("Column2");
            dt.Rows.Add(dt.NewRow());

            //binding to the gridview
            dataGridView1.DataSource = dt;

            //Set  the property AllowUserToAddRows to false will prevent a new empty row
            dataGridView1.AllowUserToAddRows = false;
        }

Now the events... When the cell recognize the editing it will fire a event called CellBeginEdit. When it's in editing mode set the AllowUserToAddRows to false

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
    dataGridView1.AllowUserToAddRows = false;
}

When the cell recognize the end of editing it will fire a event called CellEndEdit. When it ends the editing mode check for your conditions. Based on the result set the AllowUserToAddRows to true ot keep it false.

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    //instead of MessageBox there could be as well your check conditions
    if (MessageBox.Show("Cell edit finished, add a new row?", "Add new row?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
        dataGridView1.AllowUserToAddRows = true;
    else dataGridView1.AllowUserToAddRows = false;
}

score 1 · Answer 3 · answered Jul 05 '15 at 02:30

1

I know this is old. The easiest way is, uncheck "Enable Adding" from the design view

enter image description here

answered Jul 05 '15 at 02:30

Dragon Warrior

307
3
16

This is by far the easiest way to resolve the extra empty row appearing when it is not needed. – CPlusPlus OOA and D Apr 24 '17 at 22:29

score 0 · Answer 4 · answered Apr 03 '12 at 06:47

0

I think on the event CellClick you can check in which column you are and then add a new row, something like : DataGridView1.Rows.Add()

answered Apr 03 '12 at 06:47

Alex

5,971
11
42
80

it is not necessory user navigates by mouse, may be they interfaces by keyboard – Haider Ali Wajihi Apr 03 '12 at 06:56

score 0 · Answer 5 · answered Apr 03 '12 at 08:16

0

This is how it is achieved.

a) You can check contents of current row in RowLeave event using

String.IsNullOrWhiteSpace(GridPGLog.Rows[e.RowIndex].Cells[0].value.toString())
using (or) Cells[0] || cells[1] || cell[2] || ..

if any error is found, set focus to the error cell and force user to enter data.

DataGridViewRow rowToSelect = this.dgvJobList.CurrentRow;
rowToSelect.Selected = true;
rowToSelect.Cells[0].Selected = true;
this.dgvJobList.CurrentCell = rowToSelect.Cells[0];

b) or you can place a Save button and check all newly added rows using a foreach loop

answered Apr 03 '12 at 08:16

arvind

1,385
1
13
21

what you mentioned above this is can be achieved very easily on RowValidating event by e.Cancel = true, but i want new row should not add if current row is not filled. – Haider Ali Wajihi Apr 03 '12 at 11:10
if you execute it, the user will not be able to focus outside the row to add a new row – arvind Apr 03 '12 at 13:43
but this is not the answer which i am looking for – Haider Ali Wajihi Apr 03 '12 at 13:51
i just want to suppress row add – Haider Ali Wajihi Apr 03 '12 at 13:52

Preventing a new row from appearing in a DataGridView before current row is filled in?

5 Answers5