DataGridView TextBox Cell Validating in C#?

Question

I have two DataGridViewTextbox Column in my Form. I want to compare one textbox with another textbox value.

See the image the information is provided there...,

which are in blue color they are readonly ......I tried and i get the answer

So what do you need to compare? Do you need to compare Quantity Required vs Quantity Issues?? — Azhar Khorasany, May 28 '13 at 11:24

Guru · Answer 1 · 2013-05-28T11:03:57.637

1

try this

if (DataGridView.Rows[0].Cells["Quantity"].Value > DataGridView.Rows[0].Cells["other"].Value)
{
//do something
}

edited May 28 '13 at 11:03

answered May 28 '13 at 10:48

Guru

98
7

Hi @Amir i am not asking the cell value.the sum of Quantity issued is not greater than the value of the consumable required – Anjali May 28 '13 at 10:51

score 0 · Answer 2 · answered May 28 '13 at 11:34

Attach your grid to CellValidating event:

private void GridCellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
    if (e.ColumnIndex == ColQuantityIssues.Index)  // Quantity Issues TextBox value has changed
    {
        int quantityIssued = 0;

        if (!Int32.TryParse(e.FormattedValue.ToString(), out quantityRequired))  //value is not a valid number
        {
            e.Cancel = true;
        }

        int quantityRequired = Int32.Parse(dgv.Rows[e.RowIndex].Cells[ColQuantityRequired.Index].Value.ToString());

        if (quantityRequired < quantityIssued)
        {
            e.Cancel = true;
        }
    }
}

Event args has FormattedValue which is the new value user has entered. Setting e.Cancel to true won't allow user to leave current cell as long as value is not valid one.

You may change my ColQuantityIssues and ColQuantityRequired to access them by name (i.e. dgv.Rows[e.RowIndex].Cells["Required"]) but that should work.

DataGridView TextBox Cell Validating in C#?

2 Answers2