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;