protected void lbtnShenHe_Click(object sender, EventArgs e)
{
int lbtn =Convert.ToInt32(((LinkButton)sender).CommandArgument) ;
string strSQL = "UPDATE tb_Order SET Verify=0 WHERE userID=" + lbtn + "";
try
{
if (DbHelper.GetInstance().ExecuteSql(strSQL))
{
JSHelper.Alert("该表单审核成功!", this.Page);
gvOrder.DataBind();
}
}
catch
{
JSHelper.Alert("操作失败!", this.Page);//JSHelper是一个弹窗的一个类
}
}
——————————————————————————————————————————————————
<asp:GridView ID="gvOrder" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="userID" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None"
Width="80%" CellSpacing="1">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"
Height="20px" />
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="userID" HeaderText="用户编号" InsertVisible="False" ReadOnly="True"
SortExpression="userID" />
<asp:BoundField DataField="userName" HeaderText="用 户 名" SortExpression="userName" />
<asp:BoundField DataField="mobilePhone" HeaderText="手 机" SortExpression="mobilePhone" />
<asp:BoundField DataField="pronum" HeaderText="商品" SortExpression="pronum" />
<asp:BoundField DataField="number" HeaderText="件数" SortExpression="number" />
<asp:BoundField DataField="address" HeaderText="联系地址" SortExpression="address" />
<asp:BoundField DataField="phone" HeaderText="联系电话" SortExpression="phone" />
<asp:BoundField DataField="QQ" HeaderText="QQ" SortExpression="QQ" />
<%-- <asp:BoundField DataField="remark" HeaderText="备 注11" SortExpression="remark" />--%>
<asp:TemplateField HeaderText="备 注">
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Eval("remark") %>' Title='<%# Eval("remark") %>'></asp:Label>
</ItemTemplate>
<ControlStyle Width="150px" CssClass="longtext" />
<FooterStyle Width="150px" CssClass="longtext" />
<HeaderStyle Width="150px" CssClass="longtext" />
<ItemStyle Width="150px" CssClass="longtext" />
</asp:TemplateField>
<asp:TemplateField HeaderText="发货状态">
<ItemTemplate>
<asp:Label ID="labStatus" runat="server" Text='<%# BindState(Eval("FinishedState")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="审核状态">
<ItemTemplate>
<asp:Label ID="labVerify" runat="server" Text='<%# BindVerify(Eval("Verify")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="用户操作">
<ItemTemplate>
<asp:LinkButton ID="lbtnShenHe" runat="server" CommandArgument='<%# Eval("userID") %>'
OnClick="lbtnShenHe_Click" ForeColor="Blue" Font-Underline="true">审核</asp:LinkButton>
<a style='display: <%# Eval("FinishedState").ToString()=="0"?"none":"" %>' href="javascript:alert('您已经操作成功!')">
</a> <asp:LinkButton ID="lbtnShipping" runat="server" ForeColor="Blue" Font-Underline="true"
OnClick="lbtnShipping_Click" CommandArgument='<%# Eval("userID") %>'>退回</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<EmptyDataTemplate>
对不起,暂时无任何数据
</EmptyDataTemplate>
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" Font-Size="Larger" />
</asp:GridView>
——————————————————————————————————————————————————