1.列头,个人习惯将列头存储在操作类中:
#region 课程表数据库字典 KeyValue()
/// <summary>
/// 表字典 KeyValue()
/// </summary>
/// <returns></returns>
public Dictionary<string, string> KeyValue()
{
Dictionary<string, string> keys = new Dictionary<string, string>();
keys.Add("Cid", "编号");
keys.Add("CourseName", "课程名称");
keys.Add("CourseIndex", "课程首页");
return keys;
}
#endregion
(1) 设置列头及绑定数据
(2) 删除最后一行空行
(3) 自适应宽度
#region DataGridView绑定数据及设置
/// <summary>
/// DataGridView绑定数据及设置
/// </summary>
/// <param name="dt">DataTable</param>
/// <param name="Dic">数据字典</param>
private void ShowStudentTasks(DataTable dt, Dictionary<string, string> Dic)
{
dataGridView1.DataSource = dt;
foreach (var item in Dic)
{
dataGridView1.Columns[item.Key].HeaderText = item.Value;
}
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;//自适应宽度
dataGridView1.AllowUserToAddRows = false;//删除最后一行空行
}
#endregion