Bind data from SP to textbox thats inside gridview
<p>How do I bind data from a SP to my gridview which all have textboxes for each cell. My asp for is below.</p>

<pre><code> &lt;asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"&gt;
        &lt;Columns&gt;
            &lt;asp:TemplateField HeaderText="Year"&gt;
                &lt;ItemTemplate&gt;
                    &lt;asp:TextBox ID="TextBox1" runat="server" Text='&lt;%# Bind("Year") %&gt;'&gt;&lt;/asp:TextBox&gt;

                &lt;/ItemTemplate&gt;

            &lt;/asp:TemplateField&gt;
            &lt;asp:TemplateField HeaderText="Period"&gt;
                &lt;ItemTemplate&gt;
                    &lt;asp:TextBox ID="TextBox2" runat="server" Text='&lt;%# Bind("Period") %&gt;'&gt;&lt;/asp:TextBox&gt;
                &lt;/ItemTemplate&gt;
</code></pre>
