将所选数据库列显示到datagridview [英] Show selected database column to datagridview

问题描述

您好，我可以知道是否有任何方式可以将所选数据库列显示到datagridview？这是我的代码连接数据库并在datagridview中显示但它显示所有数据库列

Hello,may i know is that any way to show selected database column to datagridview?Here is my code to connect database and show in datagridview but it show all database column

private void tmst_timein_new_Load(object sender, EventArgs e)
        {
         try
         {
            using (TMPB_attn_DAL dalObj = new TMPB_attn_DAL())
          {
              dataGridView1.DataSource = dalObj.GetRecords().Cast<TMPB_attn>().ToList();
              dataGridView1.Refresh();
                    
                }
            }
            catch (Exception es)
            {
                MessageBox.Show(es.Message);

            }
        }

我只想要显示几列！但是使用这段代码太多我需要隐藏它!!!

I just want a few column to display only!but is using this code is too much i need to hide it out!!!

dataGridView1.Columns["attn_id"].Visible = false;

请教我谢谢！

Please teach me thank you!

推荐答案

您应该设置AutoGenerateColumns = false并手动添加特定列。

You should set AutoGenerateColumns=false and add the specific column manually.

在您的aspx页面集中dataGridView1 AutoGenerateColumn = false;

then在BoundColumn中设置DataField =attn_id;

然后更新你的代码如下。

in your aspx page set dataGridView1 AutoGenerateColumn = false;
then in BoundColumn set DataField = "attn_id";
and then update your code as below.

private void tmst_timein_new_Load(object sender, EventArgs e)
        {
         try
         {
            using (TMPB_attn_DAL dalObj = new TMPB_attn_DAL())
          {
              dataGridView1.DataSource = dalObj.GetRecords();
              dataGridView1.DataBind();

                }
            }
            catch (Exception es)
            {
                MessageBox.Show(es.Message);

            }
        }

这篇关于将所选数据库列显示到datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！