投票列表页面gridview

两个按钮，一个链接到详细，一个执行删除

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=ADIR;Initial Catalog=vote;User ID=sa;Password=93626wenbo"
                        SelectCommand="SELECT [Vote_ID], [Vote_Title] FROM [z_VoteInfo]" ProviderName="System.Data.SqlClient">
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
                        Width="800px">
                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:BoundField DataField="Vote_Title" HeaderText="投票主题" SortExpression="Vote_Title" />
                            <asp:TemplateField>
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("Vote_ID") %>'
                                        OnCommand="LinkButton1_Command">详细信息</asp:LinkButton>
                                    &nbsp;
                                    <asp:LinkButton ID="LinkButton2" runat="server" OnCommand="LinkButton2_Command" CommandArgument='<%# Eval("Vote_ID") %>'>删除</asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>

后台

 protected void LinkButton1_Command(object sender, CommandEventArgs e)
    {
        Response.Redirect("Vote_Info.aspx?vid="+e.CommandArgument.ToString());
    }
    protected void LinkButton2_Command(object sender, CommandEventArgs e)
    {
        string strSql = "delete from z_VoteInfo where Vote_ID = '" + e.CommandArgument.ToString() + "';";
        string strConn = "Data Source=ADIR;Initial Catalog=vote;User ID=sa;Password=93626wenbo";
        DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
        DbConnection dbConn = dbProviderFactory.CreateConnection();
        dbConn.ConnectionString = strConn;
        dbConn.Open();
        DbCommand dbComm = dbProviderFactory.CreateCommand();
        dbComm.Connection = dbConn;
        dbComm.CommandText = strSql;
        dbComm.ExecuteNonQuery();
        strSql = "delete from z_VoteOptions where Vote_ID='" + e.CommandArgument.ToString() + "';";
        dbComm.CommandText = strSql;
        dbComm.ExecuteNonQuery();
        dbConn.Close();
        dbConn.Dispose();
        Response.Redirect("Vote_Manage.aspx");
    }

 

修改投票选项页面（从querystring传来的参数）编辑、删除按钮

而添加东西则不在gridview中，下方用文本框自己来处理。

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:voteConnectionString %>"
                        SelectCommand="SELECT VO_Text, VO_Point, VO_ID FROM z_VoteOptions WHERE (Vote_ID = @Vote_ID)"
                        UpdateCommand="UPDATE z_VoteOptions SET VO_Text = @VO_Text WHERE (VO_ID = @VO_ID)">
                         <UpdateParameters>
                            <asp:ControlParameter ControlID="GridView1" Name="VO_Text" PropertyName="SelectedValue" />
                            <asp:ControlParameter ControlID="GridView1" Name="VO_ID" PropertyName="SelectedValue" />
                        </UpdateParameters>
                        <SelectParameters>
                            <asp:QueryStringParameter Name="Vote_ID" QueryStringField="vid" Type="Int32" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                        DataKeyNames="VO_ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
                        Width="500px">
                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:BoundField DataField="VO_Text" HeaderText="选项内容" SortExpression="VO_Text" />
                            <asp:BoundField DataField="VO_Point" HeaderText="选项票数" ReadOnly="True" SortExpression="VO_Point" />
                            <asp:CommandField ShowEditButton="True" />
                            <asp:CommandField ShowDeleteButton="True" />
                        </Columns>
                        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>

 

投票功能实现

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="VO_ID" Width="800px" CellPadding="4" ForeColor="#333333" GridLines="None" ShowHeader="False">
                                    <Columns>
                                        <asp:BoundField DataField="no" />
                                        <asp:BoundField DataField="VO_Text" HeaderText="VO_Text" SortExpression="VO_Text" />
                                        <asp:TemplateField>
                                            <ItemTemplate>
                                                &nbsp;<table style="width: 217px">
                                                    <tr>
                                                        <td colspan="3" rowspan="3" style="text-align: left">
                                                <asp:Label ID="Label1" runat="server" BackColor="Red"></asp:Label></td>
                                                    </tr>
                                                    <tr>
                                                    </tr>
                                                    <tr>
                                                    </tr>
                                                </table>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:BoundField DataField="VO_Point" HeaderText="VO_Point" SortExpression="VO_Point" />
                                         <asp:TemplateField>
                                            <ItemTemplate>
                                                <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("VO_ID") %>'
                                                    OnCommand="LinkButton1_Command">投票</asp:LinkButton>&nbsp;
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                                    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                                    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                                    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                                    <AlternatingRowStyle BackColor="White" />
                                </asp:GridView>

 Label lbl = (Label)gvr.FindControl("Label1");
  lbl.Width = Unit.Parse(gvr.Cells[3].Text);