GridView页脚应用

最新推荐文章于 2017-06-22 14:15:58 发布
最新推荐文章于 2017-06-22 14:15:58 发布
阅读量1k 收藏
点赞数
文章标签： textbox button asp server string javascript
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yjpbibi/article/details/1770077
版权
前台：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SetGradeItemsRules.aspx.cs" Inherits="yjp_SetVoteRules" EnableEventValidation="false"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table width="80%" align="Center" cellpadding="0" cellspacing="0">
            <tr>
                <td>        <asp:GridView Width="100%" ID="gv_GradeItem" runat="server" AutoGenerateColumns="False" ShowFooter="True" OnRowDataBound="gv_GradeItem_RowDataBound" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowCommand="gv_GradeItem_RowCommand1" AllowPaging="True" OnPageIndexChanging="gv_GradeItem_PageIndexChanging">
        <Columns>
            <asp:TemplateField HeaderText="评分项">
                <EditItemTemplate>
                    <asp:TextBox ID="txt_GradeItemName" runat="server" Text='<%# Bind("GradeItemName") %>'></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txt_GradeItemName" runat="server" Width="90%" ></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("GradeItemName") %>'></asp:Label>
                   
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="总分">
                <EditItemTemplate>
                    <asp:TextBox ID="txt_MaxPoint" runat="server" Text='<%# Bind("MaxPoint") %>' Width="87px"></asp:TextBox>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="txt_MaxPoint" runat="server" Width="90%" ></asp:TextBox>
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("MaxPoint") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="评分类型">
       <EditItemTemplate>
         <asp:DropDownList ID="ddl_DGradedType"  runat="server" DataSourceID="SqlDataSource1" DataTextField="GradeTypeName" DataValueField="GradeTypeID" ></asp:DropDownList>
                <asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("GradeTypeID")%>' />
       </EditItemTemplate>
            <ItemTemplate>
             <asp:DropDownList ID="ddl_DGradedType"  runat="server" DataSourceID="SqlDataSource1" DataTextField="GradeTypeName" DataValueField="GradeTypeID" Enabled=false ></asp:DropDownList>
                <asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("GradeTypeID")%>' />
<%--                    <asp:Label ID="lbl_type" runat="server" Text='.ToString()=="1"?"电脑评分":"专家评分" %>'></asp:Label>
--%>            </ItemTemplate>
                <FooterTemplate>
                    <asp:DropDownList ID="ddl_GradedType"  runat="server" DataSourceID="SqlDataSource1" DataTextField="GradeTypeName" DataValueField="GradeTypeID" Width="90%">
                 
                    </asp:DropDownList>
                   
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="操作">
                <FooterTemplate>
                    <asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click1" Font-Size="9pt" />
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Button ID="btn_modify" runat="server" CommandName="Modify"  Text="修改" Font-Size="9pt" />
                    <asp:Button ID="btn_del" runat="Server" CommandName="del" Text="删除" CommandArgument='<%#Eval("GradedItemID") %>' Font-Size="9pt"/>
                      <asp:Button ID="Button2" runat="server" Text="明细操作" CommandName="GradeRule" CommandArgument='<%#Eval("GradedItemID") %>' Font-Size="9pt" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:Button ID="Button3" runat="server" Text="更新" CommandName="N_update" CommandArgument='<%#Eval("GradedItemID") %>' Font-Size="9pt" />
                    <asp:Button ID="Button4" runat="server" Text="取消" CommandName="N_Cancel" CommandArgument='<%#Eval("GradedItemID") %>' Font-Size="9pt"/>
                </EditItemTemplate>
            </asp:TemplateField>
         
         
        </Columns>
            <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <RowStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#EFF3FB" Font-Size="9pt" />
            <EditRowStyle BackColor="#2461BF" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Font-Size="9pt" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>

                </td>
                <td valign="top">
                    <asp:GridView Width="100%" ID="gv_GradeRules" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowCommand="gv_GradeRules_RowCommand" ShowFooter="True" OnRowDataBound="gv_GradeRules_RowDataBound" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px">
                        <Columns>
                            <asp:TemplateField HeaderText="明细项">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server" Text='<%#Eval("GradedItemExplain") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%#Eval("GradedItemExplain") %>'></asp:Label>
                                </ItemTemplate>
                                <FooterTemplate>
                    <asp:TextBox ID="txt_GradedItemExplain" runat="server" Width="90%" ></asp:TextBox>
                </FooterTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="分数">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("GradePoint") %>' Width="90%"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label2" runat="server" Text='<%#Eval("GradePoint") %>'></asp:Label>
                                </ItemTemplate>
                                 <FooterTemplate>
                    <asp:TextBox ID="txt_Point" runat="server" Width="90%" ></asp:TextBox>
                </FooterTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="操作">
                                 <FooterTemplate>
                    <asp:Button ID="Button1" runat="server" Text="添加" OnClick="btn_addGradeRules" Font-Size="9pt" />
                </FooterTemplate>
                <ItemTemplate>
                    <asp:Button ID="btn_modify" runat="server" CommandName="Modify"  Text="修改" Font-Size="9pt" />&nbsp;
                                        <asp:Button ID="btn_del" runat="Server" CommandName="del" Text="删除" CommandArgument='<%#Eval("GradeRuleID") %>' Font-Size="9pt"/>

<%--                      <asp:Button ID="Button2" runat="server" Text="明细操作" CommandName="GradeRule" CommandArgument='<%#Eval("GradeRuleID") %>' />
--%>                </ItemTemplate>
                <EditItemTemplate>
                    <asp:Button ID="Button3" runat="server" Text="更新" CommandName="N_update" CommandArgument='<%#Eval("GradeRuleID") %>' Font-Size="9pt" />
                    <asp:Button ID="Button4" runat="server" Text="取消" CommandName="N_Cancel" CommandArgument='<%#Eval("GradeRuleID") %>' Font-Size="9pt"/>
                </EditItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" VerticalAlign="Middle" />
                        <RowStyle BackColor="#EFF3FB" Font-Size="9pt" HorizontalAlign="Center" VerticalAlign="Middle" />
                        <EditRowStyle BackColor="#2461BF" />
                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Font-Size="9pt" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>
                </td>
            </tr>
        </table>
    
        &nbsp;&nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

后台：
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class yjp_SetVoteRules : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DDL_GradedType_DataBound();

            gv_GradeItem_DataBound();
        }

    }

    private void DDL_GradedType_DataBound()
    {
        SqlDataSource1.ConnectionString = CommonClass.ConnectionString;
        SqlDataSource1.SelectCommand = "select * from Project_GradeTypes ";
    }

 

    public void gv_GradeItem_DataBound()
   {
       string selectString = "select GradedItemID,GradeItemName,GradeTypeID,Maxpoint from Project_GradedItems";// where GradeTypeID=0";// +ddl_GradeType.SelectedValue;

       AheadDataSource.IAheadDataLinker linker = CommonClass.GetDataLinker();
       System.Data.DataTable table = linker.GetDataFormString(selectString);


       if (table.Rows.Count == 0)
       {
           DataRow dr = table.NewRow();
           table.Rows.Add(dr);


       }

       gv_GradeItem.DataSource = table;
       gv_GradeItem.DataBind();
    }

 
    protected void gv_GradeItem_RowDataBound(object sender, GridViewRowEventArgs e)
    {
      
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                DropDownList ddl_type = (DropDownList)e.Row.FindControl("ddl_DGradedType");
                HiddenField hd = (HiddenField)e.Row.FindControl("HiddenField1");
                ddl_type.SelectedValue = hd.Value;
               // Button btn_del = (Button)e.Row.FindControl("btn_del");
              //  btn_del.Attributes.Add("onclick", "return confirm('此操作将删除所有依赖项！继续吗？')");
                foreach (System.Web.UI.WebControls.TableCell cell in e.Row.Cells)
                {
                    foreach (System.Web.UI.Control control in cell.Controls)
                    {
                        if (control is System.Web.UI.WebControls.Button)
                        {
                           System.Web.UI.WebControls.Button  btn_del=(System.Web.UI.WebControls.Button)control;
                            if(btn_del.CommandName =="del" )
                            {
                                btn_del.Attributes.Add("onclick", "return confirm('此操作将删除所有依赖项！继续吗？')");
                            }
                        }
                    }
                }
                if (e.Row.Cells[0].Controls[1] is Label)
                {
                    if (((Label)e.Row.Cells[0].Controls[1]).Text == string.Empty)
                    {
                        e.Row.Cells[2].Controls[1].Visible = false;
                        e.Row.Cells[3].Controls[1].Visible = false;
                        e.Row.Cells[3].Controls[3].Visible = false;
                    }
                    else
                    {
                        e.Row.Cells[2].Controls[1].Visible = true;
                        e.Row.Cells[3].Controls[1].Visible = true;
                        e.Row.Cells[3].Controls[3].Visible = true;
                    }
                }
            }
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        TextBox txt_GradeItemName = (TextBox)gv_GradeItem.FooterRow.FindControl("txt_GradeItemName");
        TextBox txt_MaxPoint = (TextBox)gv_GradeItem.FooterRow.FindControl("txt_MaxPoint");
        DropDownList ddl_GradedType = (DropDownList)gv_GradeItem.FooterRow.FindControl("ddl_GradedType");

        string insertGradeItems = "insert into Project_GradedItems (GradeItemName,ProjectID,GradeTypeID,MaxPoint) values" +
           " (@name,@projectid,@type,@point)";
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(insertGradeItems, con);
        com.Parameters.AddWithValue("@name", txt_GradeItemName.Text.Trim());
        com.Parameters.AddWithValue("@projectid", CommonClass.GetProjectID(this));
        com.Parameters.AddWithValue("@type", ddl_GradedType.SelectedValue);
        com.Parameters.AddWithValue("@point", Convert.ToDecimal(txt_MaxPoint.Text.Trim()));
        con.Open();
        if (com.ExecuteNonQuery() > 0)
        {
            gv_GradeItem_DataBound();
            DDL_GradedType_DataBound();
            Response.Write("<script language='javascript'>alert('添加成功!')</script>");
        }
        con.Close();
    }
    protected void gv_GradeItem_RowCommand1(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Modify")
        {
            this.gv_GradeItem.EditIndex = ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowIndex;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState=DataControlRowState.Edit;
            DDL_GradedType_DataBound();
            gv_GradeItem_DataBound();
        }

        if (e.CommandName == "N_update")
        {

            TextBox txt_EGradeItemName = (TextBox)((GridViewRow)(((Button)e.CommandSource)).Parent.Parent).FindControl("txt_GradeItemName");
            TextBox txt_EMaxPoint = (TextBox)((GridViewRow)(((Button)e.CommandSource)).Parent.Parent).FindControl("txt_MaxPoint");
            DropDownList ddl_DGradedType = (DropDownList)((GridViewRow)(((Button)e.CommandSource)).Parent.Parent).FindControl("ddl_DGradedType");
            UpdateGradeItem(txt_EGradeItemName.Text.Trim(), txt_EMaxPoint.Text.Trim(), ddl_DGradedType.SelectedValue, e.CommandArgument.ToString());
            this.gv_GradeItem.EditIndex = -1;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState = DataControlRowState.Normal;
            DDL_GradedType_DataBound();
            gv_GradeItem_DataBound();
        }
        if (e.CommandName == "N_Cancel")
        {
            this.gv_GradeItem.EditIndex = -1;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState = DataControlRowState.Normal;
            DDL_GradedType_DataBound();
            gv_GradeItem_DataBound();
        }

        if (e.CommandName == "GradeRule")
        {
            ViewState["GradedItemID"] = e.CommandArgument.ToString();
            gv_GradeRules_DataBind();
        }

        if(e.CommandName == "del")
        {
            if (IsExistGradeRules(e.CommandArgument.ToString()))
            {
                if (DeletGradeRules(e.CommandArgument.ToString(), 1))
                {
                    if (DeleteGradeItem(e.CommandArgument.ToString()))
                    {
                        DDL_GradedType_DataBound();
                        gv_GradeItem_DataBound();
                        gv_GradeRules_DataBind();
                        Response.Write("<script language='javascript'>alert('删除成功!')</script>");
                    }
                }
            }
            else
            {
                if (DeleteGradeItem(e.CommandArgument.ToString()))
                {
                    DDL_GradedType_DataBound();
                    gv_GradeItem_DataBound();
                    gv_GradeRules_DataBind();
                    Response.Write("<script language='javascript'>alert('删除成功!')</script>");
                }
            }
        }
    }

    public bool IsExistGradeRules(string GradedItemID)
    {
        string slecectGradeRules = "select GradeRuleID from Project_GradeRules where GradedItemID=" + GradedItemID;
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(slecectGradeRules, con);
        con.Open();
        if (com.ExecuteScalar() != null)
        {
            con.Close();
            return true;
        }
        else
        {
            con.Close();
            return false;
        }
    
    }

    public bool DeleteGradeItem(string GradeItemID)
    {
        string   deletestring = "delete from Project_GradedItems where GradedItemID=" + GradeItemID;
      
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(deletestring, con);
        con.Open();

        if (com.ExecuteNonQuery() > 0)
        {
            con.Close();
            return true;
        }
        else
        {
            con.Close();
            return false;
        }
      
    }

    public bool DeletGradeRules(string GradeRuleID,int sign)
    {
        string deletestring = "";
        if (sign == 1)
        {
            deletestring = "delete from Project_GradeRules where GradedItemID=" + GradeRuleID;
        }
        else if (sign == 2)
        {
            deletestring = "delete from Project_GradeRules where GradeRuleID=" + GradeRuleID;
        }
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(deletestring, con);
        con.Open();
        if (com.ExecuteNonQuery() > 0)
        {
            con.Close();
            return true;
        }
        else
        {
            con.Close();
            return false;
        }
      
    }

    public void gv_GradeRules_DataBind()
    {
        string selectString = "";

        if (ViewState["GradedItemID"] == null)
        {
            selectString = "select GradeRuleID,GradedItemExplain,GradePoint from Project_GradeRules where GradedItemID=0"; //+ ViewState["GradedItemID"].ToString();
        }
        else
        {
            selectString = "select GradeRuleID,GradedItemExplain,GradePoint from Project_GradeRules where GradedItemID=" + ViewState["GradedItemID"].ToString();

        }

        AheadDataSource.IAheadDataLinker linker = CommonClass.GetDataLinker();
        System.Data.DataTable table = linker.GetDataFormString(selectString);


        if (table.Rows.Count == 0)
        {
            DataRow dr = table.NewRow();
            table.Rows.Add(dr);


        }

        gv_GradeRules.DataSource = table;
        gv_GradeRules.DataBind();
    }

    protected void UpdateGradeItem(string name,string point,string typeid,string gradeitemid)
    {
        string updateString = "update Project_GradedItems set GradeItemName='" + name + "',GradeTypeID="+typeid+",MaxPoint=" + point+ " where GradedItemID="+gradeitemid;
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(updateString, con);
        con.Open();
        com.ExecuteNonQuery();
        con.Close();
    }
    protected void gv_GradeItem_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.gv_GradeItem.PageIndex = e.NewPageIndex;
        DDL_GradedType_DataBound();
        gv_GradeItem_DataBound();
    }
    protected void gv_GradeRules_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Modify")
        {
            this.gv_GradeRules.EditIndex = ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowIndex;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState = DataControlRowState.Edit;
            gv_GradeRules_DataBind();
        }

        if (e.CommandName == "N_update")
        {

            TextBox txt_EGradeItemName = (TextBox)((GridViewRow)(((Button)e.CommandSource)).Parent.Parent).FindControl("TextBox1");
            TextBox txt_EMaxPoint = (TextBox)((GridViewRow)(((Button)e.CommandSource)).Parent.Parent).FindControl("TextBox2");
             UpdateGradeRules( ViewState["GradedItemID"].ToString(),txt_EGradeItemName.Text.Trim(), txt_EMaxPoint.Text.Trim(), e.CommandArgument.ToString());
             this.gv_GradeRules.EditIndex = -1;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState = DataControlRowState.Normal;
            gv_GradeRules_DataBind();
        }
        if (e.CommandName == "N_Cancel")
        {
            this.gv_GradeRules.EditIndex = -1;
            ((GridViewRow)((Button)e.CommandSource).Parent.Parent).RowState = DataControlRowState.Normal;
            gv_GradeRules_DataBind();
        }

        if (e.CommandName == "GradeRule")
        {
            ViewState["GradedItemID"] = e.CommandArgument.ToString();
            gv_GradeRules_DataBind();
        }

        if (e.CommandName == "del")
        {
          
                if (DeletGradeRules(e.CommandArgument.ToString(), 2))
                {
                  
                        Response.Write("<script language='javascript'>alert('删除成功!')</script>");
                        gv_GradeRules_DataBind();
                }
          
        }
    }

    protected void UpdateGradeRules(string gradeditemid,string gradeditemexplain,string point,string graderuleid )
    {
        string updateString = "update Project_GradeRules set GradedItemID=" + gradeditemid + ",GradedItemExplain='" + gradeditemexplain + "',GradePoint=" + point + " where GradeRuleID=" + graderuleid;
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(updateString, con);
        con.Open();
        com.ExecuteNonQuery();
        con.Close();
    }
    protected void btn_addGradeRules(object sender, EventArgs e)
    {
        TextBox txt_GradeItemName = (TextBox)gv_GradeRules.FooterRow.FindControl("txt_GradedItemExplain");
        TextBox txt_MaxPoint = (TextBox)gv_GradeRules.FooterRow.FindControl("txt_Point");
       // DropDownList ddl_GradedType = (DropDownList)gv_GradeItem.FooterRow.FindControl("ddl_GradedType");

        string insertGradeItems = "insert into Project_GradeRules (GradedItemID,GradedItemExplain,GradePoint) values" +
           " (@gradeditemid,@gradeditemexplain,@point)";
        SqlConnection con = new SqlConnection(CommonClass.ConnectionString);
        SqlCommand com = new SqlCommand(insertGradeItems, con);
        com.Parameters.AddWithValue("@gradeditemid", ViewState["GradedItemID"].ToString());
        com.Parameters.AddWithValue("@gradeditemexplain", txt_GradeItemName.Text.Trim());
     
        com.Parameters.AddWithValue("@point", Convert.ToDecimal(txt_MaxPoint.Text.Trim()));
        con.Open();
        if (com.ExecuteNonQuery() > 0)
        {
            gv_GradeRules_DataBind();
            Response.Write("<script language='javascript'>alert('添加成功!')</script>");
        }
        con.Close();
    }
    protected void gv_GradeRules_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Button btn_del = (Button)e.Row.FindControl("btn_del");
            btn_del.Attributes.Add("onclick", "return confirm('此操作将删除所有依赖项！继续吗？')");

            if (e.Row.Cells[0].Controls[1] is Label)
            {
                if (((Label)e.Row.Cells[0].Controls[1]).Text == string.Empty)
                {
                    e.Row.Cells[2].Controls[1].Visible = false;
                    e.Row.Cells[2].Controls[3].Visible = false;
                }
                else
                {
                    e.Row.Cells[2].Controls[1].Visible = true;
                    e.Row.Cells[2].Controls[3].Visible = true;
                }
            }
        }
    }
}

  
yjpbibi
关注
asp gridview 页脚ShowFooter绑定数据，增加一个统计行方法，ShowFooter统计行方法
Bychentufeiyang的专栏
01-18 6187
先设置gridview的ShowFooter="True" ，每次gridview读取绑定数据都会出发gridview中的GridView1_RowDataBound事件，从而得到每一行的数据。 第一种情况。gridview动态绑定数据。  aspx asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="Fa
GridView的页眉页脚
08-21
ListView或GridView的页眉页脚的渐变模糊特效 提升用户体验
[翻译]Scott Mitchell 的ASP.NET 2.0数据教程之十五：在GridView的页脚中显示统计信息...
weixin_34143774的博客
07-09 131
在ASP.NET 2.0中操作数据：在GridView的页脚中显示统计信息英文原版  |   本教程的代码(C#)   |   翻译目录   |   原文目录导言 除了需要了解产品的单价、库存量和订货量，并按等级排序之外，用户可能还对统计信息感兴趣，比如说平均价格、库存总量等等。这些统计信息常常显示在报表最下面的一个统计行中。GridView控件可以含有一个页脚行，我们可以通过编程将统计数据插入...
.Net GridView应用：通用样式及动态页尺寸、通用页脚处理
行成于思，形之于文
01-17 791
前段时间将奚江华老师的书读了一遍，非常有感触，尤其是对Ajax部分很感兴趣，也碰了不少钉子，终于将区域选择的部分写成了用户控件（先前是直接调用，代码维护量大也刷页面；后来借鉴于动易的方式用IFrame处理，再修改为后台Ajax动态获取，但由于使用同一Cookie记录信息则造成了同时操作的冲突，现为用户控件，但放置在DetailsView中无法实现部分刷新，故同时刷父级控件了，也属无奈）也由此将PS
GridView中页脚汇总显示
atian15的专栏
12-11 1233
 有时候需要在GridView的页脚中汇总显示一些信息，常见的方法有两种：1、在SQL中使用汇总统计函数，直接在SSQL中查询出来，但是这种方法不常用。2、在程序中使用代码实现，这样比较灵活，代码如下：grdBlogs.ShowFooter = true;grdBlogs.DataSource = table;grdBlogs.DataBind();Tabl
【转】GridView中页脚汇总显示
weixin_30455661的博客
05-15 193
来源：http://blog.csdn.net/atian15/article/details/3495514 有时候需要在GridView的页脚中汇总显示一些信息，常见的方法有两种： 1、在SQL中使用汇总统计函数，直接在SSQL中查询出来，但是这种方法不常用。 2、在程序中使用代码实现，这样比较灵活，代码如下： grdBlogs.ShowFooter = true; grdBlo...
GridView控件应用9个经典实例
09-27
以下是对"GridView控件应用9个经典实例"的详细说明： 1. **基础展示** - GridView的基本使用涉及数据源的绑定，如SqlDataSource或ObjectDataSource。通过设置`DataSourceID`属性，可以将数据源与GridView绑定，...
【ASP.NET编程知识】在ASP.NET 2.0中操作数据之五十一：从GridView的页脚插入新记录.docx
最新发布
05-21
【ASP.NET编程知识】在ASP.NET 2.0中操作数据之五十一：从GridView的页脚插入新记录 在ASP.NET 2.0中，GridView控件是用于展示和编辑表格数据的强大工具，但默认情况下它并不支持直接的插入功能。本教程将指导你...
JS打印gridview实现原理及代码
12-10
在JS中，打印gridview涉及到的关键技术主要是利用浏览器的打印功能，并对打印设置进行自定义，包括页眉、页脚、边距等。以下将详细介绍该代码实现的过程。 首先，代码通过创建`ActiveXObject("WScript.Shell")`来...
asp.net Gridview行绑定事件新体会
01-20
2. **RowCreated** 事件：当GridView创建每一行时，不论是表头、数据行、页脚还是分页栏，都会触发此事件。这个事件在数据绑定之前发生，允许开发者对每一行的HTML结构进行修改，比如添加额外的CSS类或者JavaScript...
简单随笔——如何在gridview的页脚显示信息。。。。
weixin_30642561的博客
02-10 131
我是超级大菜鸟。。。哈哈 先上图看看是不是你需要的 第一步，右击gridview，在事件中，单击RowdataBond事件。 在这之前一定要记得在gridview属性中的ShowFooter设置为“true”。 第二步，需要实现这个功能可以看看我的代码。 1 protected void GridView1_RowDataBound(object sende...
[转]从GridView的页脚插入新记录
weixin_33769125的博客
01-19 119
http://tech.ddvip.com/2008-10/122422506879014.html 导言： 　　正如教程《概述插入、更新和删除数据》里探讨过的一样， GridView, DetailsView和FormView Web控件都有内置的修改数据的功能。当声明绑定到数据源控件时，可以快速而方便地修改数据——甚至不用写一行代码。不幸的是，只有DetailsView和FormView...
C#中如何给GridView添加页脚以实现统计某一列值的和
03-04 6020
第一步： 设置GridView的属性：ShowFooter=true 第二步： 定义一个全局变量，以备使用，如:private decimal thisTotal=0;//本页面合计 private decimal total=0;//共计然后在GridViewShow()函数中计算出这些值。自定义函数GridViewShow()用于实现GridView的数据绑定。 如GridView的格
GridView页脚汇总(统计)行的方法(.net 2.0)
berwos的专栏
05-27 2850
第一步：我们要把gridview里面的属性中ShowFooter="True"，就是把gridview的页脚显示出来。第二步：在双击属性面板中的事件，让他自动生成一个GridView1_RowDataBound的事件。第三步:定义变量 private  decimal sum=0;        第四步:在protected void GridView1_RowDataBound(ob
gridviewtips1:gridview的页脚中的加亮显示和页数显示
jackyrongvip的专栏
07-01 1266
在asp.net 中,要经常显示gridview中的页数,并且当用户点下一页时,最好的 方法是加亮予以显示,下面分别介绍下实现方法: 1)加亮显示当前的页数   先增加CSS如下:        .gvPagerCss span    {        background-color:#DEE1E7;         font-size:20px;    }      .gvPager
ASP.NET开发之GridView使用方法
各安天涯丶
06-22 804
史上最全GridView使用方法 1.GridView无代码分页排序 1.AllowSorting设为True，aspx代码中是AllowSorting="True"； 2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。 3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。
GridView生成thead、tbody、tfoot标签！
那片田，那片天~~
05-19 2314
需求：GridView生成的Table 要求添加标签，以便集成Jquery相关插件使用(如：Jquery-easyUI    datagrids) 解决方案：
"ASP.NET 2.0中操作数据之GridView页脚插入新记录的方法详解
本文详细介绍了在ASP.NET 2.0中使用GridView控件实现插入新记录的方法。...总之，通过深入理解ASP.NET 2.0中GridView控件的特性和使用方法，我们可以更加灵活地操作数据，提升应用程序的用户体验和功能性。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值