title: Manually binding data to Gridview
body: <p>I need to bind my SQL fields to my Gridview column. I did this a while ago and it worked great, but I forgot how to do this, so I let ASP.NET AutoGenerate the columns and it works, now I want to control the data binding, below is my code behind and my Gridview... any assistance will be appreciated.</p>
  
  <pre><code> protected void Page_Load(object sender, EventArgs e)
          {
              SqlConnection conn = new SqlConnection(Sitecore.Configuration.Settings.GetConnectionString("feedback"));
              SqlCommand cmd = new SqlCommand("select * from fb_results", conn);
              DataSet ds = new DataSet();
              SqlDataAdapter da = new SqlDataAdapter(cmd);
              da.Fill(ds);
              GridView1.DataSource = ds;
              GridView1.DataBind();
  
              conn.Close();
          }
  </code></pre>
  
  <p>Gridview: </p>
  
  <pre><code>&lt;head id="Head1" runat="server"&gt;
      &lt;title&gt;Feedback&lt;/title&gt;
  &lt;/head&gt;
  &lt;asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"&gt;
      &lt;Columns&gt;
          &lt;asp:BoundField DataField="rpt_login" HeaderText="User Id" /&gt;
          &lt;asp:BoundField DataField="fb_url" HeaderText="URL___" /&gt;
          &lt;asp:BoundField DataField="fb_response" HeaderText="Answer: Did you find what you were looking for?" /&gt;
          &lt;asp:BoundField DataField="fb_noResponse" HeaderText="No Response or Ignore" /&gt;
          &lt;asp:BoundField DataField="fb_date" HeaderText="Date" /&gt;
          &lt;asp:BoundField DataField="fb_serviceCall" HeaderText="Prevented Service Call" /&gt;
          &lt;asp:BoundField DataField="fb_partsShipment" HeaderText="Prevented Parts Shipment" /&gt;
          &lt;asp:BoundField DataField="fb_warranty" HeaderText="Under Warranty" /&gt;
          &lt;asp:BoundField DataField="fb_cancel" HeaderText="Cancelled" /&gt;
          &lt;asp:BoundField DataField="fb_none" HeaderText="None of the Above" /&gt;
      &lt;/Columns&gt;
  &lt;/asp:GridView&gt;
  </code></pre>