Data set to display Individual Columns from Ms acess Using C#

Question

            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            ds.Tables.Add(dt);
            OleDbDataAdapter dd = new OleDbDataAdapter();
            dd = new OleDbDataAdapter("Select * From Jet", dbConn);
            dd.Fill(dt);
            dataGridView1.DataSource = dt.DefaultView;
            dbConn.Close();

I have this data set to display my whole table onto my Ms Acess database table

Now i need your help in displaying  only two columns of my table in my grideview. e.g. I have  (File_sed), (Names), (surname) ......n more  and now i want to diplay only (File_seq), (Name)

Answer 1

You need to set AutoGenerateColumns to false on the GridView. Then add the columns manually for the ones you want displayed and set their properties for their header text and the databinding to the columns in the table.

http://www.codeproject.com/Articles/13462/How-to-create-template-columns-dynamically-in-a-gr

---

HTH
Ciaran
http://www.wannabedeveloper.com

Answer 2

okay , this is not a web app but i can relate to what you saying

i get you

Thanks alot

Answer 3

Hi Siphambo,

"displaying only two columns of my table in my grideview"

You can just hide the columns you don't want to show.

eg: this.dataGridView1.Columns["surname"].Visible = false;   // hide "surname" column

And you can check this article: How to: Hide Columns in the Windows Forms DataGridView Control.

Have a nice day.

---

Bob Shen [MSFT]
MSDN Community Support | Feedback to us

Answer 4

that was just super, thanks alot