How to fill Datagridview in C# from DataTable adding custom columns?

Question

I use the following code to bind DataTable with DataGridView:

DataTable dt = new DataTable();   
dt = serviceSqlite.select(new Pacients());    
dataGridView1.DataSource = dt;

I want to add custom columns in dt it should be one CheckBox and Image.

How to do that?

You can add them to your DataGridView like this dataGridView1.Columns.Add(new DataGridViewCheckBoxColumn()); — Salah Akbari
– Salah Akbari, Commented Aug 30, 2017 at 19:31
You can add columns to the table; add the 1st one a bool and the 2nd one as byte[] . Much more flexible when it comes to sorting or filtering.. — TaW
– TaW, Commented Aug 30, 2017 at 19:35

Salah Akbari · Accepted Answer · 2017-08-30 20:01:03Z

1

You can add them to your DataGridView. Like this:

var checkBox = new DataGridViewCheckBoxColumn
{
    Name = "checkBox",
    HeaderText = @"checkBox",
    Width = 70
};
//Set other properties...
dataGridView1.Columns.Add(checkBox);

And same for Image:

DataGridViewImageColumn image = new DataGridViewImageColumn();
//....

Also if you want the new column to be appear in another column you can replace dataGridView1.Columns.Add(checkBox); with following:

dataGridView1.DataSource = dt;
var checkBox = new DataGridViewCheckBoxColumn
{
    Name = "checkBox",
    HeaderText = @"checkBox",
    Width = 70
};
//Set other properties...
dataGridView1.Columns.Insert(1, checkBox);

And if you want to add it to your DataTable you can add it as boolean field in the DataTable:

dt.Columns.Add(new DataColumn("checkBox", typeof(bool)));
dataGridView1.DataSource = dt;

So when you bind the DataTable to your DataGridView, a CheckBoxColumn is created for this boolean field.

edited Aug 30, 2017 at 20:01

answered Aug 30, 2017 at 19:37

Salah Akbari

40k10 gold badges85 silver badges115 bronze badges

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

11 Comments

POV Over a year ago

After how to bind with DataTable?

POV Over a year ago

I dont understand, I need to add new column to DataTable or to dataGridView1? Will it work correct? When one part of data from DataTable one added manually?

Salah Akbari Over a year ago

@OPV You need to add column to your DataGridView to show on your form. Just add my answer to your code and you will see the result.

blaze_125 Over a year ago

@OPV, Pick your poison... Bind to your DataTable then, add a column to the DataGridView... Or... Add the column to your DataTable, then bind the DataGridView to your DataTable. The Global scope of your requirements should tell you which way to swing. Personally, I'd alter my DataTable, and then bind it to the DataGridView.

POV Over a year ago

How can I change DataTable for new column CheckBox, I need to add empty column to DataTable? Can you edit your answer please

|

Collectives™ on Stack Overflow

How to fill Datagridview in C# from DataTable adding custom columns?

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related