Change DataGridView Column Name in Entity Framework

Question

I have a DataTable "Items" in my SQL server Database "Procurement"

The DataTable has 3 columns with this schema: id (int), itemDesc (nvarchar), itemCat (int) which is bind to a DataGridView using this code:

namespace EF_Tutorial
{
    public partial class Form1 : Form
    {

        ProcurmentsEntities ProcurmetsContext = new ProcurmentsEntities();


        public Form1()
        {
            InitializeComponent();
        }


        private void Form1_Load(object sender, EventArgs e)
        {
            dgv_ItemList.DataSource = ProcurmetsContext.Items.ToList();
        }

    }
}

Problem is when the form loads the DataGridView shows the column name as it is in the DataTable, I tried adding the columns manually to the DGV and changed their name to that of the DataTable and the Header Text to what I want to display but the columns are generated and the one I added are left blank.

Is there a work around to display the name I want ?

Prasad Kamath · Accepted Answer · 2018-02-19 15:52:33Z

3

@Tima

Try the following:

dgv_ItemList.DataSource = ProcurmetsContext.Items.ToList();  
dgv_ItemList.Columns[0].HeaderText = "Item ID";  
dgv_ItemList.Columns[1].HeaderText = "Item Description";  
dgv_ItemList.Columns[2].HeaderText = "Item Category";

answered Feb 19, 2018 at 15:52

Prasad Kamath

1922 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Change DataGridView Column Name in Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related