winForm datagridview 操作小方法

来源：互联网发布：韩顺平java从入门到精通编辑：程序博客网时间：2024/05/21 02:22

datagridview 粘贴功能(以下)

private void DataGirdViewCellPaste(DataGridView grid)
        {
            try
            {
                // 获取剪切板的内容，并按行分割
                string pasteText = Clipboard.GetText().Trim();
                if (string.IsNullOrEmpty(pasteText))
                    return;
                string[] lines = pasteText.Replace("\r\n","|").Replace("\t","^").Split('|');
                int currRow = grid.CurrentCell.RowIndex;
                if ((grid.Rows.Count-currRow)<lines.Length)
                {
                    MessageBox.Show("粘贴的行数越界！", "提示！");
                    return;
                }

                int rowNum = 0;
                int colNum = 0;
                int currCol = grid.CurrentCell.ColumnIndex;
                for (int i = currRow; i < currRow+lines.Length; i++)
                {
                    colNum = 0;
                    string[] vals = lines[rowNum].Split('^');
                    rowNum++;
                    if (vals.Length>(grid.Columns.Count-currCol))
                    {
                        MessageBox.Show("粘贴的列数越界！", "提示！");
                        return;

                    }
                    for (int k= 0; k < vals.Length; k++)
                    {

                        if (!Common.IsDecimalNoEmptyNull(ref vals[k]))
                        {
                            MessageBox.Show("粘贴的数据中含有非数字字符！", "提示！");
                            return;
                        }
                    }
                    for (int j = currCol; j < currCol+vals.Length; j++)
                    {
                        grid.Rows[i].Cells[grid.Columns[j].HeaderText].Value = vals[colNum];
                        colNum++;
                    }

                }

            }
            catch
            {
                // 不处理
            }
        }

//Ctrl+V 调用上面的方法

private void dataGridView2_KeyDown(object sender, KeyEventArgs e)
        {
            if (Control.ModifierKeys == Keys.Control && e.KeyCode == Keys.V)
            {
                if (sender != null && sender.GetType() == typeof(DataGridView))
                    // 调用上面的粘贴代码
                    DataGirdViewCellPaste(this.dataGridView2);
            }

}

datagridview 粘贴功能(以上)

datagridview中ComboBoxColumn赋值（以下）

((DataGridViewComboBoxColumn)this.dataGridView1.Columns["absenceType"]).Items.Add("");
for (num = 0; num < defaultView.Count; num++)
{

((DataGridViewComboBoxColumn)this.dataGridView1.Columns["absenceType"]).Items.Add(defaultView[num][0]);

}

datagridview中ComboBoxColumn赋值（以上）

//datagridview中的checkbox改成红勾

((DataGridViewCheckBoxCell)this.dataGridView1.Rows[i].Cells["second"]).Style.ForeColor = Color.Red;
((DataGridViewCheckBoxCell)this.dataGridView1.Rows[i].Cells["second"]).FlatStyle = FlatStyle.Popup;