Hi ,
Hope it help you .
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
string statment = "select * from Items ";
SqlDataAdapter da = new SqlDataAdapter(statment, con);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
int ColNumber = dt.Columns.Count;
for (int i = 0; i < ColNumber; i++)
{
BoundField bu = new BoundField();
string col_name = dt.Columns[i].ColumnName;
bu.HeaderText = col_name;
bu.DataField = col_name;
GridView1.Columns.Add(bu);
}
GridView1.DataBind();
}
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
</asp:GridView>
</div>
Best Regards
M.Mitwalli