DataGridView控件操作⼤全（内容居中显⽰，右键绑定菜单）DataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter '标题居中DataGridView1.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter '内容居中
this.dataGridView1.AutoGenerateColumns = false; //让它不⾃⼰产⽣多余的列
// this.dataGridView1.AutoSizeColumnsModel = Fill //列名占满容器
this.dataGridView1.AutoSizeColumnsModel = AllCells //列名占满容器
#region [DataGridView控件单元格点击事件，绑定右键菜单]
private void dataGridView_Score_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
/
/绑定右键菜单
dataGridView_Score.SelectedRows[0].ContextMenuStrip = tMenuStrip1;
}
}
#endregion
DataGridView单元格内容显⽰格式化：代⼊
Dictionary<string,string>⽅法
private void dataGridView_Score_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
Dictionary<string,string> scoreStatus = GetScoreStatus();
if (e.ColumnIndex == 7)
{
e.Value = scoreStatus[e.Value.ToString()];
e.FormattingApplied = true;
}
}
#region [设定ComboBox数据源]
private Dictionary<string, string> GetScoreStatus()
{
Dictionary<string, string> dic = new Dictionary<string, string>
{
{"2", "全部"},
{"1", "成功"},
{"0", "失败"}
};
return dic;
}
#endregion
获取DataGridView选中数据, 返回对象：
#region[获取DataGridView的选中⾏数据]
/// <summary>
/// 获取当前选中⾏的数据
/// </summary>
/
// <returns>当前选中⾏数据</returns>
private JudgeSetting GetSelectRowInfo()
{
DataGridViewRow selectRows = dataGridView_Judge.SelectedRows[0];
JudgeSetting setting = new JudgeSetting();
if (selectRows != null)
{
// 项⽬代码
setting.Ksxmdm = Convert.ToInt32(selectRows.Cells["项⽬代码"].Value);
// 项⽬名称
setting.Gakfmc = Convert.ToString(selectRows.Cells["项⽬名称"].Value);
}
return setting;
}
#endregion
替换DataGridView头部显⽰，
#region[替换DataTable头]
/// <summary>
/// 替换DataTable头
/// </summary>
/// <param name="dt">查询出的DataTable</param>
/// <returns></returns>
private DataTable ReplaceDataTableHead(DataTable dt)
{
dt.Columns[0].ColumnName = "项⽬代码";
dt.Columns[1].ColumnName = "项⽬名称";
dt.Columns[2].ColumnName = "扣分项⽬";
return dt;
}
#endregion
#region[DataTable样式调整]
/// <summary>
/// DataTable样式调整
/
// </summary>
private void ChangeDataTableStyle()
{
// KEY列隐藏
this.dataGridView_Judge.Columns[10].Visible = false;
this.dataGridView_Judge.Columns[9].Visible = false;
//this.dataGridView_Judge.Columns[0].Width = 80;
//this.dataGridView_Judge.Columns[1].Width = 100;
this.dataGridView_Judge.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; }
#endregion
绑定dataTable到DataGridView
#region[绑定dataTable到DataGridView]
/// <summary>
/// 绑定dataTable到DataGridView
/// </summary>
/// <param name="dt">源DataTable</param>
private void BindDataTble(DataTable dt)
{
if (toolStripComboBox1.Text != "全部")
{
DataRow[] rows = dt.Select(string.Format("GAKFMC = '{0}'", toolStripComboBox1.Text));
DataTable table = dt.Clone();
foreach(DataRow row in rows)
{
table.Rows.Add(row.ItemArray);
}
dt = table;
}
// 修改DataTable头部
dt = ReplaceDataTableHead(dt);
// 绑定数据
this.dataGridView_Judge.DataSource = dt;
// 修改DataTable样式
ChangeDataTableStyle();
// 刷新读取的条数
}
#endregion
刷新DataGridView的绑定
#region[刷新DataGridView的绑定]
/// <summary>
/// 刷新DataGridView的绑定
/// </summary>
/// <param name="sqlEnum">查询语句</param>
datagridview数据源private void RefreshBindTable(SqlStatusEnum sqlEnum)
{
try
{
DataTable dt = QueryData(sqlEnum, null);
if (dt != null && dt.Rows.Count > 0)
{
BindDataTble(dt);
}
else
MessageBox.Show("查询错误，或未查询到相关数据!");
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
}
#endregion
DataGridView控件绑定List<string>
List<Student> strList = new List<Student>()
{
new Student(){StuId = 1, StuName = "张三"},
new Student(){StuId = 2, StuName = "李四"},
new Student(){StuId = 3, StuName = "王五"}
};
//查出ID，并显⽰姓名，List<{m}>绑定到datagridview，可以把m去掉,.Select(m => new { m.StuName })这样展⽰就是StuName的列名 var students = strList.Where(s =>s.StuId == 2).Select(m => new { m = m.StuName }).ToList();
dataGridView1.DataSource = students; //显⽰出以m为列名的数据，可以⼿动修改列名
将dataGridView选定的⾏转换为实体对象
ContactModel model = dataGridView1.CurrentRow.DataBoundItem as ContactModel;
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论