title: Getting name of table columns in gridview in addition to custom names
body: <p>I have a simple grid on my ASPX page and I am binding it with data coming from a select query on button click event. I am not sure how to bind columns of this table with my grid as currently I am getting 8 columns, 4 with the header given in aspx page and 4 with headers of table columns. Below is my button click event code.</p>
  
  <pre><code>protected void btnSearch_Click(object sender, EventArgs e)
          {
              MyBookListCont myBookListCont = new MyBookListCont();
              gdvMyBooks.DataSource = myBookListCont.SearchBookDetailsCont();
              gdvMyBooks.DataBind();            
          }
  </code></pre>
  
  <p>And below is aspx code of gridview.</p>
  
  <pre><code>&lt;asp:GridView ID="gdvMyBooks" runat="server"&gt;
      &lt;Columns&gt;            
          &lt;asp:BoundField DataField="BK_NM" HeaderText="Book Name" /&gt;
          &lt;asp:BoundField DataField="ATHR_NM" HeaderText="Author Name" /&gt;
          &lt;asp:BoundField DataField="BUY_YR" HeaderText="Buy Year" /&gt;
          &lt;asp:BoundField DataField="PRICE" HeaderText="Price" /&gt;
      &lt;/Columns&gt;
  &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>Looks like a silly question, but help would be much appreciated.</p>