Hello ,
Similar Requirement I Faced Some Months Back.So i Achieved with The Help Pf Following Steps
1) First Retieve The Table From DataBase.
2) Add The Column into That DataTable
3) Bind The Datatable To The GRid View.
To Add The Columns into The Data Table
Assumption: you have declared a DataTable Object as dt
dt.Columns.Add("colItemCode");
dt.Columns.Add("colDescription");
After this Bind The GridView
dataGridView1.DataSource = dt
It will display the columns added in the added table
[If you insert some data into dt,then write dt.AcceptChanges();]
Hope It Solves Your Problem
Happy Coding
:-)