C# DataGridView not showing Data (Entity Framework)

Question

I am trying to make a simple binding from SQL server to a DataGridView in C# but this code is not working (My programming skills are little rusty)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace TestProject
{
    public partial class Form1 : Form
    {
        public IQueryable<boklet2> qry;
        public AnalysisUpgradeEntities Ana = new AnalysisUpgradeEntities();

        public class boklet2
        {
            public int _ID;
            public int? _ItemSpecs;
        }

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.AutoGenerateColumns = true;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            qry = from an in Ana.analysis_pipes
                  select new boklet2
                  {
                      _ID = an.ID,
                      _ItemSpecs = an.itemSpecs
                  };

            dataGridView1.DataSource = qry.ToList();
            //dataGridView1.DataSource = qry;
        }

    }
}

Am I missing a library I should add with the word Using I also tried adding the dataGridView1.AutoGenerateColumns = True but still no data is shown

@NiranjanKala I cheched and it contains the 10 elements I added in the SQL server table — Taher
– Taher, Commented Nov 3, 2017 at 14:56

blaze_125 · Accepted Answer · 2017-11-03 15:11:07Z

1

Change this:

public class boklet2
{
    public int _ID;
    public int? _ItemSpecs;
}

to this

public class boklet2
{
    public int _ID { get; set; }
    public int? _ItemSpecs { get; set; }
}

and let me know

Explanation provided by @AdamVincent, thank you!

Fields are ordinary member variables or member instances of a class. Properties are an abstraction to get and set their values. Properties are also called accessors because they offer a way to change and retrieve a field if you expose a field in the class as private. A field is public int _ID;, and the fix was to add the accessors by using the auto property syntax public int _ID { get; set; }

edited Nov 3, 2017 at 15:11

answered Nov 3, 2017 at 14:01

blaze_125

2,3171 gold badge11 silver badges21 bronze badges

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

5 Comments

Taher Over a year ago

Still, no data is shown in the DataGridView. I am confused what could possibly be wrong ?!! Its working now

Taher Over a year ago

Sorry my fault its working now, but what was the problem might I ask ?

blaze_125 Over a year ago

@Tima, I do not know the official answer, but I'll go on a limp and say that I assume the DataGridView initializer does not know how to properly initialize the grid when the fields it needs to display don't have a setter because it's unable to create the initial instance of the field <- It's not exactly how I have it worded in my head but that's how it came out...

Adam Vincent Over a year ago

Fields are ordinary member variables or member instances of a class. Properties are an abstraction to get and set their values. Properties are also called accessors because they offer a way to change and retrieve a field if you expose a field in the class as private. A field is public int _ID;, and the fix was to add the accessors by using the auto property syntax public int _ID { get; set; }

Adam Vincent Over a year ago

please update this code only response with some more information.

Collectives™ on Stack Overflow

C# DataGridView not showing Data (Entity Framework)

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related