title: grid view display 2 columns from code behind datatable binding
body: <p>How do I only display two colums in my grid view if the gridview is bound in the code behind by an auto generated table? Right now it displays six columns when I only want it to display two?</p>
  
  <p>Here is my .aspx page code:</p>
  
  <pre><code>&lt;%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %&gt;
  
  &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
  
  &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
  &lt;head runat="server"&gt;
      &lt;title&gt;&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
      &lt;form id="form1" runat="server"&gt;
      &lt;div&gt;
          &lt;asp:GridView ID="GridView1" runat="server"&gt;
  
                  &lt;columns&gt;
            &lt;asp:boundfield datafield="Drug" headertext="ddddrug"/&gt;
            &lt;asp:boundfield datafield="date" headertext="ddddate"/&gt;
  
          &lt;/columns&gt;
  
  
          &lt;/asp:GridView&gt;
      &lt;/div&gt;
      &lt;/form&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>Here is my code behind code:</p>
  
  <pre><code>Imports System.Data
  
  Partial Class Default2
      Inherits System.Web.UI.Page
  
      Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  
      ' auto generated table
          Dim table2 As New DataTable
          ' Create four typed columns in the DataTable.
          table2.Columns.Add("ID", GetType(Integer))
          table2.Columns.Add("Drug", GetType(String))
          table2.Columns.Add("Patient", GetType(String))
          table2.Columns.Add("Date", GetType(DateTime))
          ' Add five rows with those columns filled in the DataTable.
          table2.Rows.Add(25, "Indocin", "David", DateTime.Now)
          table2.Rows.Add(50, "Enebrel", "Sam", DateTime.Now)
          table2.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now)
          table2.Rows.Add(21, "Combivent", "Janet", DateTime.Now)
          table2.Rows.Add(1100, "Dilantin", "Melanie", DateTime.Now)
          table2.Rows.Add(125, "Indocin", "David", DateTime.Now)
          table2.Rows.Add(150, "Enebrel", "Sam", DateTime.Now)
          table2.Rows.Add(110, "Hydralazine", "Christoff", DateTime.Now)
  
          GridView1.DataSource = table2
  
          GridView1.DataBind()
  
      End Sub
  
      End Sub
  End Class
  </code></pre>