How to store a static value in gridveiw RUD

See more:

ASP.NET

I have a GridView columns ID, Duties, Score, Comments and EP (email and period it was done). The EP is not known to user.

The user should be able to update Duties, Score and Comments but not the EP (which should remain the same without the user seeing it).

I want something like this

update: D1, 2, C1 EP
To : D2, 3, C2, EP

EP = txtEmailPeriod.Text

I am wondering if anyone has any suggestions how to do this.

What I have tried:

<asp:GridView ID="GVDutiesCRUD" runat="server" AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataKeyNames="ID" DataSourceID="SqlGridView" ShowFooter="True" OnSelectedIndexChanged="GVDutiesCRUD_SelectedIndexChanged">
                                    <Columns>
                                        <asp:TemplateField ShowHeader="False">
                                            <EditItemTemplate>
                                                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Update"></asp:LinkButton>
                                                 <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton>
                                               
                                                 <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"></asp:LinkButton>
                                            </ItemTemplate>
                                            <FooterTemplate>
                                                <asp:LinkButton ID="lblInsert" ValidationGroup="insert" onClick="lblInsert_Click" runat="server">Insert</asp:LinkButton>
                                            </FooterTemplate>
                                        </asp:TemplateField>
                                        <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" Visible="False" />
                                        <asp:TemplateField HeaderText="Duties" SortExpression="Duties">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Duties") %>'></asp:TextBox>
                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Required Duties" ControlToValidate="TextBox1" Font-Size="Smaller"></asp:RequiredFieldValidator>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("Duties") %>'></asp:Label>
                                            </ItemTemplate>
                                             <FooterTemplate>
                                                <asp:TextBox ID="txtDutiesFooter" runat="server"></asp:TextBox>
                                                  <asp:RequiredFieldValidator ID="RequiredFieldValidator6" ValidationGroup="insert" runat="server" ErrorMessage="Required Duties" ControlToValidate="txtDutiesFooter" Font-Size="Smaller"></asp:RequiredFieldValidator>
                                          
                                            </FooterTemplate>
                                        </asp:TemplateField>
                                        
                                        <asp:TemplateField HeaderText="Score" SortExpression="Score">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Score") %>'></asp:TextBox>
                                                 <asp:RequiredFieldValidator ID="RequiredFieldValidator3"  runat="server" ErrorMessage="Required Score" ControlToValidate="TextBox3" Font-Size="Smaller"></asp:RequiredFieldValidator>
                                          
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label3" runat="server" Text='<%# Bind("Score") %>'></asp:Label>
                                            </ItemTemplate>
                                             <FooterTemplate>
                                                <asp:TextBox ID="txtScoreFooter" runat="server"></asp:TextBox>
                                                  <asp:RequiredFieldValidator ID="RequiredFieldValidator8" ValidationGroup="insert" runat="server" ErrorMessage="Required score" ControlToValidate="txtScoreFooter" Font-Size="Smaller"></asp:RequiredFieldValidator>
                                          
                                            </FooterTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="Comment" SortExpression="Comment">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Comment") %>'></asp:TextBox>
                                                 <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="Required Comments" ControlToValidate="TextBox1" Font-                                                   Size="Smaller"></asp:RequiredFieldValidator>
                                          
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label4" runat="server" Text='<%# Bind("Comment") %>'></asp:Label>
                                            </ItemTemplate>
                                             <FooterTemplate>
                                                <asp:TextBox ID="txtCommentFooter" runat="server"></asp:TextBox>
                                                  <asp:RequiredFieldValidator ID="RequiredFieldValidator9" ValidationGroup="insert" runat="server" ErrorMessage="Required Comments"                                                   ControlToValidate="txtCommentFooter" Font-Size="Smaller"></asp:RequiredFieldValidator>
                                          
                                            </FooterTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="EP" SortExpression="EP" Visible="False">
                                            <EditItemTemplate>
                                                <!--
                                                <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("EP") %>'></asp:TextBox>
                                                 what to assign a stactic text from a textbox.
                                                -->
                                                 <asp:TextBox ID="TextBox5" runat="server" Text='txtEmailPeriod.Text'></asp:TextBox>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label5" runat="server" Text='<%# Bind("EP") %>'></asp:Label>
                                            </ItemTemplate> 
                                             <FooterTemplate>
                                                <asp:TextBox ID="txtEPFooter" runat="server"></asp:TextBox>
                                            </FooterTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                    <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
                                    <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
                                    <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
                                    <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
                                    <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
                                    <SortedAscendingCellStyle BackColor="#FFF1D4" />
                                    <SortedAscendingHeaderStyle BackColor="#B95C30" />
                                    <SortedDescendingCellStyle BackColor="#F1E5CE" />
                                    <SortedDescendingHeaderStyle BackColor="#93451F" />
                                </asp:GridView>