c# show 2 columns of database with 28 columns

Question

I have a database with 28 columns. First column is code, second Name and the rest are values.

public void displayData()
{
    con.Open();
    MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM gehaltes", con);
    DataTable dt = new DataTable();

    da.Fill(dt);
    dataGridView1.DataSource = dt;
    dataGridView1.AutoResizeColumn(DataGridViewAutoSizeColumnsMode.DisplayedCells);
    con.Close();
}

With this part of the program I see all the columns in the datagridview. I only want the first 2 but I have to use all the 28 columns if I want to make changes.

Maybe dont use SELECT * ?? Generally a good idea to always specify the columns in the order you want. You dont need all the columns to make changes unless you will be changing something in those other 26 column; which seems less likely if the user cant see/edit them — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Jan 11, 2017 at 17:21
@Plutonix I think he means he doesn't want them displayed in the datagridview. — Uueerdo
– Uueerdo, Commented Jan 11, 2017 at 17:21
You should be able to loop over the datagridview's columns and set their visible properties. — Uueerdo
– Uueerdo, Commented Jan 11, 2017 at 17:22

Uueerdo · Accepted Answer · 2017-01-11 17:27:14Z

1

You can set the visible property of individual columns:

DataGridView dgv;
// ...
foreach(DataGridViewColumn c in dgv.Columns)
   c.Visible = c.Name == "code" || c.Name == "Name";

answered Jan 11, 2017 at 17:27

Uueerdo

16k1 gold badge19 silver badges21 bronze badges

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

Comments

NicoRiff · Accepted Answer · 2017-01-11 17:31:18Z

1

Set the AutoGenerateColumns property of the DataGridView to false, and add two columns with the property DataPropertyName refering to the names that you want to display.

Example:

da.Fill(dt);
dataGridView1.AutoGenerateColumns = false;

DataGridViewColumn col = new DataGridViewColumn();
col.Name = "name";
col.HeaderText = "header";
col.DataPropertyName = "yourDBField";

dataGridView1.Columns.Add(col);

dataGridView1.DataSource = dt;
dataGridView1.AutoResizeColumn(DataGridViewAutoSizeColumnsMode.DisplayedCells);

edited Jan 11, 2017 at 17:31

answered Jan 11, 2017 at 17:23

NicoRiff

4,8933 gold badges29 silver badges57 bronze badges

Collectives™ on Stack Overflow

c# show 2 columns of database with 28 columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related