如何在gridveiw RUD中存储静态值 [英] How to store a static value in gridveiw RUD
本文介绍了如何在gridveiw RUD中存储静态值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个GridView列ID，职责，分数，评论和EP（电子邮件和期间已完成）。用户不知道EP。
用户应该能够更新职责，分数和评论，但不能更新EP（如果没有用户看到，应该保持不变它）。
我想要这样的东西
更新：D1,2，C1 EP
收件人：D2,3，C2，EP
EP = txtEmailPeriod.Text
我想知道是否有人有任何建议如何做到这一点。
我尝试过：
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>
推荐答案
嗨
删除TemplateField
< asp：TemplateField HeaderText =EPSortExpression =EPVisible =False>
写一个更新查询
UPDATE TableName
SET Duties = Duties.text，score = score.text，Comments = comments.text
WHERE（ID = @ id）
Hi
remove TemplateField
<asp:TemplateField HeaderText="EP" SortExpression="EP" Visible="False">
write a update query
UPDATE TableName
SET Duties=Duties.text,score=score.text,Comments=comments.text
WHERE (ID=@id")
这篇关于如何在gridveiw RUD中存储静态值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
