欢迎光临
我们一直在努力
当前位置：IDC资讯中心 > 网络编程 > ASP.NET教程 > 正文

gridview 分页导航_asp.net技巧

2007-08-24 分类：ASP.NET教程 阅读(957) 评论(0)
建站超值云服务器，限时71元/月

自己做的一个项目中所运用到的技术：|


1.         日历控件（带时分秒）
2.         GridView 批量删除,自定义分页,定位页码
3.         GridView 修改
4.        GridView 鼠标经过改变行的颜色
效果如下：


gridview 分页导航_asp.net技巧
HTML：
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”StfCmpManager.aspx.cs” Inherits=”StfCmpManager” %>


<!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 id=”Head1″ runat=”server”>
    <title>合作商信息维护</title>
    <script language=”javascript” type=”text/javascript”>   
    // 判断多选是否与选中项（没有选中的返回false）
    function slcNo_click()
    …{
        if (document.form1.checkboxname.length)
        …{
            for (var i=0;i<document.form1.checkboxname.length;i++)
            …{
                if(document.form1.checkboxname[i].checked)
                …{
                    return true;
                }
            }
        }
        else
        …{
            if(document.form1.checkboxname.checked)
            …{
                return true;
            }
        }
        alert(“请选择后再操作！”);
        return false;
    }
   
    // 鼠标经过改变行的颜色
    if (!objbeforeItem)
    …{
        var objbeforeItem=null;
        var objbeforeItembackgroundColor=null;
    }   
    function ItemOver(obj)
    …{
        if(objbeforeItem)
        …{
            objbeforeItem.style.backgroundColor = objbeforeItembackgroundColor;
        }
        objbeforeItembackgroundColor = obj.style.backgroundColor;
        objbeforeItem = obj;
        obj.style.backgroundColor = “#B9D1F3”;    
    }
    //       
 
    // 多选的全选与取消
    function checkJs(boolvalue)
    …{
        if(document.all.checkboxname.length>1)
        …{
            for(var i=0;i<document.all.checkboxname.length;i++)
            …{
                document.all.checkboxname[i].checked = boolvalue;           
            }
        }
        else
            document.all.checkboxname.checked = boolvalue;
    }
    //
   
    // 只有全部选中时“全选”选中
    function SingleCheckJs()
    …{
        var flag1=false;
        var flag2=false;
       
        if (document.form1.checkboxname.length)
        …{
            for (var i=0;i<document.form1.checkboxname.length;i++)
            …{
                if(document.form1.checkboxname[i].checked)
                    flag1 = true;
                else
                    flag2 = true;
            }
        }
        else
        …{
            if(document.form1.checkboxname.checked)
                flag1 = true;
            else
                flag2 = true;
        }
       
        if(flag1==true&&flag2==false)
            document.getElementById(“chk”).checked = true;
        else
            document.getElementById(“chk”).checked = false;
    }
  
    </script> 
<script type=”text/javascript” language=”javascript” src=”http://www.knowsky.com/Selecttime/calendar.js”></script>     
</head>
<body>
    <form id=”form1″ runat=”server”>
            <table id=”Table10″ cellSpacing=”0″ cellPadding=”0″ border=”0″ Style=”z-index: 103;
            left: 21px; position: absolute; top: 20px; width: 90%;”>
                <tr>
                    <td bgColor=”#fafafa”>
                        <FIELDSET style=”BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid; HEIGHT: 45px”><LEGEND><FONT face=”宋体” size=”2″>合作商查询</FONT></LEGEND>
                            <table id=”Table1″ height=”40″ cellSpacing=”0″ cellPadding=”0″ width=”100%” align=”center”
                                border=”0″>
                                <tr>
                                    <td height=”30″><FONT face=”宋体”>&nbsp;</FONT><FONT face=”宋体”>&nbsp;合作商名称
                                            <asp:textbox id=”TStfName” runat=”server” BorderStyle=”Groove” Width=”144px”></asp:textbox>&nbsp;</FONT></td>
                                </tr>
                                <tr>
                                    <td style=”height: 30px”>&nbsp;<FONT face=”宋体”> 添加时间 </FONT>
                                        <asp:textbox id=”StartTime” onfocus=”setday(this)” runat=”server” Width=”159px”></asp:textbox>&nbsp;到
                                        <asp:textbox id=”EndTime” onfocus=”setday(this)” runat=”server” Width=”160px”></asp:textbox>&nbsp;&nbsp;&nbsp;<FONT face=”Times New Roman”>&nbsp;&nbsp;&nbsp;</FONT></td>
                                </tr>
                                <TR>
                                    <TD height=”30″><FONT face=”宋体”>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT face=”宋体”>
                                                <asp:button id=”SelectClient” runat=”server” Text=”搜　索” onclick=”SelectClient_Click”></asp:button>&nbsp;&nbsp;&nbsp;</FONT></FONT></TD>
                                </TR>
                            </table>
                        </FIELDSET>
                    </td>
                </tr>
            </table>
            <table cellpadding=”0″ cellspacing=”0″ border=”0″ Style=”z-index: 103;
            left: 21px; position: absolute; top: 140px; width: 90%;”>
                <tr bgColor=”#6B696B”>
                    <td align=”center” style=”width: 85%”>
                        <asp:GridView ID=”GridView1″ runat=”server” Width=”100%” CellPadding=”4″ ForeColor=”#333333″
                            AutoGenerateColumns=”False” AllowPaging=”True” BorderColor=”Silver”
                            BorderStyle=”Solid” BorderWidth=”1px” OnRowDataBound=”GridView1_RowDataBound”
                            ShowFooter=”false” EmptyDataText=”没有数据记录！！” AllowSorting=”True” OnSorting=”GridView1_Sorting”>
                            <Columns>
                                <asp:BoundField HeaderText=”编号” DataField=”id” Visible=”False” />
                                <asp:TemplateField HeaderText=”&lt;input type=checkbox id=chk name=chk onclick=checkJs(this.checked);  /&gt;全选”>
                                    <ItemTemplate>
                                        <input type=”checkbox” id=”checkboxname” name=”checkboxname” value=<%# DataBinder.Eval(Container.DataItem, “StfId”)%> onclick=SingleCheckJs(); />
                                    </ItemTemplate>
                                </asp:TemplateField>


                                <asp:TemplateField HeaderText=”序号”>
                                    <ItemTemplate>
                                        <%# (Container.DataItemIndex+1).ToString()%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText=”充值”>
                                    <ItemTemplate>
                                        <%#GetClientVisitInfoShowCmpMoney(DataBinder.Eval(Container.DataItem,”StfId”),DataBinder.Eval(Container.DataItem,”StfName”))%>
                                    </ItemTemplate>
                                </asp:TemplateField>                                                      
                                <asp:BoundField HeaderText=”公司名称” DataField=”StfCmpName” SortExpression=”StfCmpName”/>
                                <asp:BoundField HeaderText=”登陆名” DataField=”StfName” SortExpression=”StfName” />
                                <asp:BoundField HeaderText=”帐户金额” DataField=”StfCmpMoney” SortExpression=”StfCmpMoney” />
                                <asp:BoundField HeaderText=”帐户Q币” DataField =”StfQbmoney” SortExpression=”StfQbmoney” />
                                <asp:BoundField HeaderText=”合作日期” DataField=”StfRegisterTime” HtmlEncode=”False” SortExpression=”StfRegisterTime” />
                                <asp:TemplateField HeaderText=”操作” >
                                    <ItemTemplate>
                                        <%#GetClientVisitInfoShowAnchorStr(DataBinder.Eval(Container.DataItem,”StfId”),DataBinder.Eval(Container.DataItem,”StfName”))%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <RowStyle BackColor=”#F7F6F3″ ForeColor=”#333333″ />
                            <EditRowStyle BackColor=”#999999″ />
                            <SelectedRowStyle BackColor=”#E2DED6″ Font-Bold=”True” ForeColor=”#333333″ />
                            <PagerStyle BackColor=”#284775″ ForeColor=”White” HorizontalAlign=”Center” />
                            <AlternatingRowStyle BackColor=”White” ForeColor=”#284775″ />
                            <PagerSettings Visible=”False” />
                            <HeaderStyle Font-Bold=”False” Font-Italic=”False” />
                        </asp:GridView>
                    </td>
                </tr>
                <tr>
                    <td align=”center” style=”height: 25px; width: 569px;”>
                        <asp:LinkButton ID=”btnFirst” CommandArgument=”first” OnClick=”PagerButtonClick”
                            runat=”server”>首 页</asp:LinkButton>&nbsp;<asp:LinkButton ID=”btnPrev” CommandArgument=”prev” OnClick=”PagerButtonClick” runat=”server”>上一页</asp:LinkButton>
                        <asp:LinkButton ID=”btnNext” CommandArgument=”next” OnClick=”PagerButtonClick” runat=”server”>下一页</asp:LinkButton>
                        <asp:LinkButton ID=”btnLast” CommandArgument=”last” OnClick=”PagerButtonClick” runat=”server”>尾 页</asp:LinkButton>
                        <asp:Label ID=”LblCurrentIndex” runat=”server”></asp:Label>
                        <asp:Label ID=”LblPageCount” runat=”server”></asp:Label>
                        <asp:Label ID=”LblRecordCount” runat=”server”></asp:Label>
跳转到第<asp:DropDownList ID=”ddlCurrentPage” runat=”server” AutoPostBack=”True” OnSelectedIndexChanged=”DropDownList1_SelectedIndexChanged”>
</asp:DropDownList>页</td>                <tr>
                    <td style=”width: 569px”>
                        &nbsp;操作：
                        <asp:Button ID=”Button3″ runat=”server” OnClick=”Button3_Click” Text=”删除合作商” />
                    </td>
                </tr>
            </table>           
       </form>
</body>
</html>
CS：
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 StfCmpManager : System.Web.UI.Page
…{
    protected void Page_Load(object sender, System.EventArgs e)
    …{
      
        string StfRight = “”;
        // 在此处放置用户代码以初始化页面 http://www.knowsky.com
        if (Session[“UserId”] == null)
        …{
            Response.Write(“<script language=javascript>alert(工作超时，请重新登录。);top.window.location=default.aspx;</script>”);
            return;
        }
        else
        …{
            StfRight = Session[“UserRight”].ToString().Trim();


            if (!this.IsPostBack)
            …{
 
                if (StfRight != “7” && StfRight != “8”)
                …{
                    Response.Write(“<script language=javascript>alert(你没有权限察看此页。);top.window.location=default.aspx;</script>”);
                    return;
                }


                GridViewBind(“”);
            }
        }


    }
    private void GridViewBind(string Sqlsort)
    …{
        string where = string.Empty;
        where = “and a.StfRight=6 and a.StfId=b.Stfid”;
        if (TStfName.Text.Trim() != “”)
        …{
            where += ” and a.StfCmpName like %” + TStfName.Text.Trim() + “%”;
        }



        if (StartTime.Text.Trim() != “”)
        …{
            where += ” and a.StfRegistertime >= ” + StartTime.Text + “”;
        }
        if (EndTime.Text.Trim() != “”)
        …{
            where += ” and a.StfRegistertime <= ” + EndTime.Text + “”;
        }


        if (where != string.Empty)
        …{
            where = “Where ” + where.Substring(4);
        }
        string connStr = ConfigurationManager.AppSettings.Get(“DataConnectionString”);
        string SqlStr = “Select a.StfId as StfId,a.StfName as StfName,a.StfRealName as StfRealName,a.StfCmpName as StfCmpName,b.StfCmpMoney as StfCmpMoney,b.StfQbmoney as StfQbmoney,a.StfRegistertime as StfRegistertime From TStafferInfo a,TCmpMoney b ” + where + Sqlsort;
        //Response.Write(SqlStr);
        //Response.End();      
        DataSet ds = new DataSet();


        try
        …{
            SqlConnection conn = new SqlConnection(connStr);
            if (conn.State.ToString() == “Closed”) conn.Open();


            SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
            da.Fill(ds, “TStafferInfo”);
            if (conn.State.ToString() == “Open”) conn.Close();


            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();


            LblCurrentIndex.Text = “第 ” + (GridView1.PageIndex + 1).ToString() + ” 页”;
            LblPageCount.Text = “共 ” + GridView1.PageCount.ToString() + ” 页”;
            LblRecordCount.Text = “总共 ” + ds.Tables[0].Rows.Count.ToString() + ” 条”;
            if (ds.Tables[0].Rows.Count == 0)
            …{
                btnFirst.Visible = false;
                btnPrev.Visible = false;
                btnNext.Visible = false;
                btnLast.Visible = false;


                LblCurrentIndex.Visible = false;
                LblPageCount.Visible = false;
                LblRecordCount.Visible = false;
            }
            else if (GridView1.PageCount == 1)
            …{
                btnFirst.Visible = false;
                btnPrev.Visible = false;
                btnNext.Visible = false;
                btnLast.Visible = false;
            }


            // 计算生成分页页码,分别为：”首 页” “上一页” “下一页” “尾 页”
            btnFirst.CommandName = “1”;
            btnPrev.CommandName = (GridView1.PageIndex == 0 ? “1” : GridView1.PageIndex.ToString());


            btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
            btnLast.CommandName = GridView1.PageCount.ToString();
            //


            this.ddlCurrentPage.Items.Clear();
            for (int i = 1; i <= this.GridView1.PageCount; i++)
            …{
                this.ddlCurrentPage.Items.Add(i.ToString());
            }
            this.ddlCurrentPage.SelectedIndex = this.GridView1.PageIndex;



        }
        catch (Exception ex)
        …{
            Response.Write(“数据库错误，错误原因：” + ex.Message);
            Response.End();
        }
    }
    protected void PagerButtonClick(object sender, EventArgs e)
    …{
        GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName) – 1;
        GridViewBind(“”);
    }


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    …{
        e.Row.Attributes[“onmouseover”] = “ItemOver(this)”;
    }



    protected void Button1_Click(object sender, EventArgs e)
    …{
        Response.Write(Request.Form.Get(“RadioName”));
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    …{
        string sql = “”;


        if (ViewState[“DataConnectionString”] == null || ViewState[“DataConnectionString”].ToString().CompareTo(“”) == 0)
        …{
            ViewState[“DataConnectionString”] = ” desc”;
        }
        else
            ViewState[“DataConnectionString”] = “”;


        sql = ” order by ” + e.SortExpression + ViewState[“DataConnectionString”];
        GridViewBind(sql);


        //DataFormatString=”{0:yyyy年MM月dd日 hh时mm分ss秒}”
    }
   
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    …{
        this.GridView1.PageIndex = this.ddlCurrentPage.SelectedIndex;
        GridViewBind(“”);
    }


    private bool CheckAddClientInfoForm()
    …{
        int Tag = 0;


 


        if (Tag == 1)
        …{


            Response.Write(“<script>alert(请将带*项填写!)</script>”);
            return false;
        }
        if (Tag == 2)
        …{


            Response.Write(“<script>alert(两次输入密码不同)</script>”);
            return false;
        }
        else
        …{
            return true;
        }
    }


    public string GetClientVisitInfoShowAnchorStr(object StfId, object StfName)
    …{
        string AnchorStr = “<a href=#><Div onclick=javascript:window.open(“TManageModify.aspx?StfId=” + StfId + “&StfName=” + StfName + “”,””,”height=280,Width=600,scrollbars=yes,resizable=yes,status=no”)>修改</Div></a>”;
        return AnchorStr;
    }
    public string GetClientVisitInfoShowCmpMoney(object StfId, object StfName)
    …{
        string AnchorStr = “<a href=#><Div onclick=javascript:window.open(“StfCmpMoneyInfo.aspx?StfId=” + StfId + “&StfName=” + StfName + “”,””,”height=250,Width=500,scrollbars=yes,resizable=yes,status=no”)>充值</Div></a>”;
        return AnchorStr;
    }
    protected void Button3_Click(object sender, EventArgs e)
    …{
        string str = “”;
        string[] ckb = null;


        str = Request.Form.Get(“checkboxname”);
        ckb = str.Split(new char[] …{ , });
        for (int i = 0; i < ckb.Length; i++)
        …{   //帐户和信息同时删除
            string StrSql = ” Delete TStafferInfo where StfId =” + ckb[i] + “”;
            String StrSql_d = ” Delete TCmpMoneyInfo where StfId =” + ckb[i] + “”;
            SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get(“DataConnectionString”));
            SqlCommand Cmd = new System.Data.SqlClient.SqlCommand(StrSql, Conn);
            SqlCommand Cmd_d = new System.Data.SqlClient.SqlCommand(StrSql_d, Conn);


            Conn.Open();
            SqlTransaction Trans = Conn.BeginTransaction();
            try
            …{
                Cmd.Transaction = Trans;
                Cmd_d.Transaction = Trans;
                Cmd.ExecuteNonQuery();
                Cmd_d.ExecuteNonQuery();
                Trans.Commit();


            }
            catch (Exception Err)
            …{
                Trans.Rollback();
                Response.Write(Err.Message);
            }


        }
        Response.Write(“<script>window.close();alert(操作员删除成功！);</script>”);
        GridViewBind(“”);
    }


    protected void SelectClient_Click(object sender, EventArgs e)
    …{
        GridViewBind(“”);
    }
 
}

赞(0)
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com 特别注意：本站所有转载文章言论不代表本站观点！ 本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。未经允许不得转载：IDC资讯中心 » gridview 分页导航_asp.net技巧
分享到： 更多 (0)

相关推荐

热门标签

ldquo (1370)win (1324)活动 (1166)ios (1162)rdquo (818)微信 (747)iphone (728)小米 (722)windows (706)手机 (698)酷跑 (686)飞车 (540)天天 (492)qq (491)网站 (457)全民 (442)discuz (408)充值 (389)安装 (368)更新 (321)华为 (300)浏览器 (292)支付宝 (289)三星 (266)note (264)教程 (262)预览版 (261)小编 (258)越狱 (254)linux (248)

热门文章

分类目录