How to only display certain columns in DataGrid from SQL database?

Question

Lets say I have a table named Table_T in the SQL database and it contains 6 columns (column1, column2, ..., column6).

The following code populates all columns from the database into dataGridView:

private void button1_Click(object sender, EventArgs e)
{

    SqlConnection cn = new SqlConnection(
        "Data Source=PCN-TOSH;Initial Catalog=mydb;Integrated Security=True");
    cn.Open();
    SqlCommand cm = new SqlCommand("SELECT *FROM Table_T");
    cm.Connection = cn;

    SqlDataAdapter da = new SqlDataAdapter(cm);
    DataTable dt = new DataTable();
    da.Fill(dt);
    cn.Close();
    dataGridView1.DataSource = dt;
}

But how can I only select column3 & column5 and populate them into dataGridview1?

SqlCommand cm = new SqlCommand("SELECT column3,column5 FROM Table_T"); — c4pricorn
– c4pricorn, Commented Nov 1, 2015 at 21:54

user4942382 · Accepted Answer · 2015-11-01 21:54:45Z

3

SELECT column3, column5 FROM Table_T

Why wouldn't that work?

answered Nov 1, 2015 at 21:54

user4942382

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

2 Comments

user4942382 Over a year ago

@naouf great! Please mark it as the correct answer by pressing the tick next to the answer :)

Reza Aghaei Over a year ago

@naouf When a post answers your question, you can kindly click check mark near the answer to make it accepted. This way it will be more helpful for users in future. While you can only mark one answer as accepted, but when you reached 15 reputation scores, you can vote up as many answer as you find helpful, including the accepted one. Also you can vote for good questions. :)

Simon Price · Accepted Answer · 2015-11-01 22:13:07Z

if you dont need everything back from the table you should use

select col1, col2 from table

and if you need conditions on it use your where clause

However if do need to grab all th data but display only certain information at certain times I would use a foreach loop like so

foreach(var item in dt.Rows)
{
  var colValue0 = item[0].ToString()
  var colValue1 = item[1].ToString()
  var colValue2 = Convert.ToIn16(item[2])
}

---- edit ----

relooking at your question, if you were binding this to a gridview and only wanted certain information you should add these values to a new datatable then display only the new datatable

so you would need to do something like

var bindableDt = new Datatable();
bindableDt.Columns.Add("colName1")
bindableDt.Columns.Add("colName2")

foreach(var item in dt.Rows)
{
    bindableDt.Row.Add(dt.Rows[0], dt.Rows[1]);
}
gridview.Datasource = bindableDt;

Community · Accepted Answer · 2017-05-23 11:54:27Z

0

[This answer was initially posted as comment by @capricorn]

SqlCommand cm = new SqlCommand("SELECT column3,column5 FROM Table_T")

this code worked very well. thank you all for your help . all respect and regards.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Nov 1, 2015 at 22:12

naouf

6374 gold badges19 silver badges28 bronze badges

1 Comment

Reza Aghaei Over a year ago

Since there is a post that answers your question, you can delete this post and accept this answer :)

Collectives™ on Stack Overflow

How to only display certain columns in DataGrid from SQL database?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related