单击datagridview复选框时如何进入cellenter事件？ [英] How to enter into cellenter event when check box of datagridview is clicked?

问题描述

i have three events in cellcontentclick and cellenter and cellleave events of datagridview..winforms...
iam trying to write code this is done :when my checkbox is clicked it allows us to enter data in othercolumn.when i uncheck it it disables us to enter data in other column. 
ths is what i have to do :
when checkbox cell is clicked the cursor has to go to the particular cell automatically.
and must allow us to write data in it..while leaving the cell using cellleave event i have to check whether is empty or not.if empty that checkbox must be uncheked that means have to make it false.and must not allow any user to enter data in other column.else if cell while leaving is not empty it has to store the data of that row in database

我尝试过：

What I have tried:

 private void button1_Click(object sender, EventArgs e)
        {

            
            int row = 0;
            dataGridView1.Rows.Add();
            row = dataGridView1.Rows.Count - 1;
            dataGridView1["AMENITIESNAME", row].Value = textBox1.Text;
            dataGridView1["DESCRIPTION", row].Value = textBox2.Text;

            dataGridView1["CHECKBOX", row].Value = false;
            dataGridView1["AMOUNT", row].ReadOnly = true;
            LoadSerial();
        }

        private async void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {

            if (lastCell != null)
            {
                var lastAmtCell = dataGridView1.Rows[lastCell.RowIndex].Cells["AMOUNT"];
                if (lastAmtCell.ReadOnly == true)
                {
                    // MessageBox.Show("working");

                    lastCell.Value = false;
                }
                else
                {
                    // MessageBox.Show("working");

                    lastCell.Value = true;
                }
            }
            //  System.Threading.Thread.Sleep(300);
            // Stopwatch stopwatch = Stopwatch.StartNew();
            // Thread.SpinWait(1000000);
            // await Task.Delay(20000);
   

            var amountCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
            if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"])
            {

                if (amountCell.ReadOnly == true)

                {
                    amountCell.ReadOnly = false;
                    amountCell.Style.BackColor = Color.White;

                }



                else
                {
                    dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"].ReadOnly = true;
                    amountCell.Style.BackColor = Color.Gray;

                    //dataGridView1.Columns["AMOUNT"].Visible = true;

                }
                lastCell = dataGridView1.CurrentCell;
            }
        }


        private void dataGridView1_CellValidating_1(object sender, DataGridViewCellValidatingEventArgs e)
        {


           /* foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                //dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"].Value=true;
                //dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"].Value = true;

                DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[3];
                if (chk.Value.ToString().ToLower() == " false")
                {
                    //dataGridView1.CurrentCell = dataGridView1[0, 2];
                    if (Convert.ToString(row.Cells["AMOUNT"].Value) != string.Empty)
                    {
                        SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-T09HLQF;Initial Catalog=BANQUET HALL ;PASSWORD=Secret;Integrated Security=True;");
                        con.Open();
                        for (int i = 0; i < dataGridView1.Rows.Count; i++)
                        {
                            //string StrQuery = @"INSERT INTO AMENITIES VALUES (" + dataGridView1.Rows[i].Cells[0].Value + ", " + dataGridView1.Rows[i].Cells[1].Value + "," + dataGridView1.Rows[i].Cells[2].Value + "," + dataGridView1.Rows[i].Cells[3].Value + "," + dataGridView1.Rows[i].Cells[4].Value + ");";

                            string StrQuery = @"INSERT INTO AMENITIES(ID,AMENITIESNAME,DESCRIPTION,CHECKBOX,AMOUNT) VALUES (@ID,@AMENITIESNAME,@DESCRIPTION,@CHECKBOX,@AMOUNT)";
                            SqlCommand CMD = new SqlCommand(StrQuery, con);
                            CMD.Parameters.AddWithValue("@ID", dataGridView1.Rows[i].Cells[0].Value);
                            CMD.Parameters.AddWithValue("@AMENITIESNAME", dataGridView1.Rows[i].Cells[1].Value);
                            CMD.Parameters.AddWithValue("@DESCRIPTION", dataGridView1.Rows[i].Cells[2].Value);
                            CMD.Parameters.AddWithValue("@CHECKBOX", dataGridView1.Rows[i].Cells[3].Value);
                            CMD.Parameters.AddWithValue("@AMOUNT", dataGridView1.Rows[i].Cells[4].Value);

                            CMD.ExecuteNonQuery();



                            // dataGridView1.Rows[lastCell.RowIndex].Cells["AMOUNT"].ReadOnly = true;
                        }
                        chk.Value = "false";
                        //dataGridView1.Rows[lastCell.RowIndex].Cells["AMOUNT"].ReadOnly = true;
                    }

                    else
                    {
                        MessageBox.Show("please provide amount"); return;
                        //   dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"].Value = false;
                    }
                }

            }*/

        }

        private void dataGridView1_CellMouseEnter(object sender, DataGridViewCellEventArgs e)
        {


        }

        private void dataGridView1_CellMouseLeave(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 4)
            {

                foreach (DataGridViewRow row in dataGridView1.Rows)
                {

                    if (Convert.ToString(row.Cells["AMOUNT"].Value) == string.Empty) 
                    {
                        MessageBox.Show("Please enter  value");
                        dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"].Value = false;
                        dataGridView1.Rows[e.RowIndex].Cells[4].Value = null;
                        return;


                    }
                    else
                    {
                        SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-T09HLQF;Initial Catalog=BANQUET HALL ;PASSWORD=Secret;Integrated Security=True;");
                        con.Open();
                        for (int i = 0; i < dataGridView1.Rows.Count; i++)
                        {
                            //string StrQuery = @"INSERT INTO AMENITIES VALUES (" + dataGridView1.Rows[i].Cells[0].Value + ", " + dataGridView1.Rows[i].Cells[1].Value + "," + dataGridView1.Rows[i].Cells[2].Value + "," + dataGridView1.Rows[i].Cells[3].Value + "," + dataGridView1.Rows[i].Cells[4].Value + ");";

                            string StrQuery = @"INSERT INTO AMENITIES(ID,AMENITIESNAME,DESCRIPTION,CHECKBOX,AMOUNT) VALUES (@ID,@AMENITIESNAME,@DESCRIPTION,@CHECKBOX,@AMOUNT)";
                            SqlCommand CMD = new SqlCommand(StrQuery, con);
                            CMD.Parameters.AddWithValue("@ID", dataGridView1.Rows[i].Cells[0].Value);
                            CMD.Parameters.AddWithValue("@AMENITIESNAME", dataGridView1.Rows[i].Cells[1].Value);
                            CMD.Parameters.AddWithValue("@DESCRIPTION", dataGridView1.Rows[i].Cells[2].Value);
                            CMD.Parameters.AddWithValue("@CHECKBOX", dataGridView1.Rows[i].Cells[3].Value);
                            CMD.Parameters.AddWithValue("@AMOUNT", dataGridView1.Rows[i].Cells[4].Value);

                            CMD.ExecuteNonQuery();



                            // dataGridView1.Rows[lastCell.RowIndex].Cells["AMOUNT"].ReadOnly = true;
                        }
                    }
                }

            }
        }
    }
}

推荐答案

我个人不会使用 CellEnter 或 CellLeave 事件 - 用户可能只是在单元格中进行选项而不打算编辑它们。



我会使用 CellBeginEdit 而是 CellEndEdit 事件。这样的东西可能会起作用（尽管你可能想多做一些检查空引用）。注意我假设Checkbox列是列 0

Personally I wouldn't use the CellEnter or CellLeave events - the user could just be tabbing through the cells without intending to edit them.

I would use the CellBeginEdit and CellEndEdit events instead. Something like this might work (although you might want to do a little more checking for null references). Note I've assumed the Checkbox column is column 0

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex == 0)
    {
        return;
    }

    if(string.IsNullOrEmpty((dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]).EditedFormattedValue.ToString()))
    {
        var cb = (dataGridView1.Rows[e.RowIndex].Cells[0]) as DataGridViewCheckBoxCell;
        cb.Value = false;
    }
}

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
    if (e.ColumnIndex == 0)
    {
        return;
    }

    var cb =((DataGridViewCheckBoxCell)(dataGridView1.Rows[e.RowIndex].Cells[0])).Value;
    if(cb == null || !(bool)cb)
    {
        e.Cancel = true;
    }
}

当使用 CellContentClick 来捕获时，有一个陷阱设置复选框的开/关 - 如果您查看此代码段

There is a "gotcha" when using CellContentClick to capture the setting on/off of the Checkbox - If you look at this code snippet

var a = ((dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]) as DataGridViewCheckBoxCell).EditedFormattedValue;
var b = ((dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]) as DataGridViewCheckBoxCell).Value;
var c = ((dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]) as DataGridViewCheckBoxCell).FormattedValue;
Debug.Print("a{0}, b{1}, c{2}", a, b, c);

首次点击复选框时会得到以下输出：

You get the following output when you first click on the Checkbox:

aTrue, b, cFalse

在其他我们需要使用 EditedFormattedValue 来获取我们正在移动的值到



为了防止单元格的编辑，您可以使用单元格的 ReadOnly 属性，但是您需要处理用户尝试编辑新行上的列的情况，而无需勾选框 - 最简单的方法是检查 CellBeginEdit 事件中Checkbox的值，就像我上面所做的那样。请注意，在这种情况下，我们需要使用单元格的 Value 属性。



自动将焦点设置为下一列使用DataGridView的 CurrentCell 属性。所以这可能有效：

In other words we need to use EditedFormattedValue to get the value that we are moving to

To prevent editing of the cells you can use the ReadOnly property of the cells BUT you need to handle the situation of the user trying to edit columns on a new row without ticking the box - the easiest way is just to check the value of the Checkbox in the CellBeginEdit event as I did above. Note in that case we need to use the Value property of the cell.

To automatically set the focus to the next column you use the CurrentCell property of the DataGridView. So this might work:

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

    if (e.ColumnIndex != 0)
    {
        return;
    }

    var z = (bool)((dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]) as DataGridViewCheckBoxCell).EditedFormattedValue;

    for (var i = 1; i < dataGridView1.Columns.Count; i++)
    {
        dataGridView1.Rows[e.RowIndex].Cells[i].ReadOnly = !z;
    }

    if (!z)
    {
        return;
    }
    dataGridView1.CurrentCell = dataGridView1.Rows[e.RowIndex].Cells[1];
}

根据您的最终要求

Down to your final requirement

引用：

如果离开时的单元格不是空的，则必须将该行的数据存储在数据库中

if cell while leaving is not empty it has to store the data of that row in database

这是一个PITA，用于解决您尝试使用这么多注释掉的代码所做的事情，所以请考虑以下内容点数。

你需要确保无论用户输入的是什么，所以 CellLeave ， CellValidating 和 RowValidating 是 不 放置数据库保存代码的适当方法。请考虑以下事项：

It's a PITA to work out what you are trying to do with so much commented out code, so consider the following points.
You need to make sure that whatever the user has entered is valid, so the CellLeave, CellValidating and RowValidating are not appropriate methods in which to put your database save code. Instead consider the following:

private void dataGridView1_CellValidated(object sender, DataGridViewCellEventArgs e)
{
    //The cell has been edited, the editing is finished with and the cell has been validated
    // NOW is the time to write the data for this CELL only to the database
    // BUT do you really want to ...
}

private void dataGridView1_RowValidated(object sender, DataGridViewCellEventArgs e)
{
    //The row has been edited, the editing is finished with and the row has been validated
    // NOW is the time to write the data for this *ROW* only to the database
    // BUT do you really want to ...
}

private void dataGridView1_Validated(object sender, EventArgs e)
{
    //The datagridview has been edited, the editing is finished with and the datagridview has been validated
    // NOW is the time to write ALL of the data for this *DATAGRIDVIEW* to the database
    // BUT do you really want to ...
}
private void btnSaveChanges_Click(object sender, EventArgs e)
{
    // The USER is telling you that they have finished editing.
    // NOW is the time to write ALL of the data for the DATAGRIDVIEW to the database
}

private async void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
    {

        if (lastCell != null)
        {
            var lastAmtCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
            if (lastAmtCell.Value == true)
            {
                // MessageBox.Show("working");

                lastCell.Value = false;
            }
            else
            {
                // MessageBox.Show("working");

                lastCell.Value = true;
            }
        }

        var amountCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
        if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"])
        {

            if (amountCell.ReadOnly == true)

            {
                amountCell.ReadOnly = false;
                amountCell.Style.BackColor = Color.White;

            }



            else
            {
                dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"].ReadOnly = true;
                amountCell.Style.BackColor = Color.Gray;

                //dataGridView1.Columns["AMOUNT"].Visible = true;

            }
            lastCell = dataGridView1.CurrentCell;
        }
    }

这篇关于单击datagridview复选框时如何进入cellenter事件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！