C#WinForm下动态创建的DataGridView更换表头字段名--转⽅法⼀:
DataGridView gvshow = new DataGridView();//new⼀个grideview
gvshow.DataBindingComplete += new
System.Windows.Forms.DataGridViewBindingCompleteEventHandler(this.gvshow_DataBindingComplete);
DataTable dt = CreateSource(sqlStr); //获得数据源
gvshow.DataSource = dt;//设置数据源
this.Controls.Add(gvshow);
public DataTable CreateSource(string sqlStr)
{
DataSet ADataSet = new DataSet();
OleDbDataAdapter ADataAdapter = new OleDbDataAdapter(sqlStr, conn);
ADataAdapter.Fill(ADataSet);
return ADataSet.Tables[0];
}
private void gvshow_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)datagridview数据源
{
//设置显⽰的列名
gvshow.Columns["RealName"].HeaderText = "姓名";
gvshow.Columns["LogTime"].HeaderText = "操作⽇期";
//设置列的宽度
gvshow.Columns["LogTime"].Width = 150;
gvshow.Columns["FormName"].HeaderText = "模块名称";
gvshow.Columns["FormName"].Width = 150;
gvshow.Columns["EventName"].HeaderText = "具体操作";
gvshow.Columns["UserIPAddress"].HeaderText = "IP地址";
gvshow.Columns["UserComputerName"].HeaderText = "计算机名称";
gvshow.Columns["UserComputerName"].Width = 150;
gvshow.Columns["CustomerID"].Visible = false;//隐藏某列:
}
⽅法⼆:
bind()中,selectCommand的select语句,指定中⽂名例:sslect stuId as 学号,stuName as 姓名 from stu.

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。