方法一:
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)
{
//设置显示的列名
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.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步