GridView 实例

最新推荐文章于 2016-02-16 17:00:13 发布
最新推荐文章于 2016-02-16 17:00:13 发布
阅读量1.6k 收藏 2
点赞数
文章标签： textbox asp string server button object
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fxj331072/article/details/1724946
版权
这篇博客介绍了如何在ASP.NET中使用GridView控件进行数据展示、编辑和删除操作。包括使用BoundField和TemplateField显示数据，以及添加编辑、删除按钮。同时，展示了如何实现全选功能和行颜色改变的JavaScript函数。
摘要由CSDN通过智能技术生成
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.Text;
 using  System.Data.SqlClient;
 public   partial   class  Admin_Users : System.Web.UI.Page
 {
    //总记录数
    private int TotalCountRecord;
    //每页显示的条数
    private int PageItem = 5;
    //当前页
    private int CurrentPage = 1;
    private string strUrl = string.Empty;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["page"] != null)
        {
            if (!Int32.TryParse(Request.QueryString["page"].ToString(), out CurrentPage))
            {
                Response.Write("请输入整数页");
                Response.End();
                return;
            }

        }
        if (Session["UserName"] != null)
        {
            Label1.Text = Session["UserName"].ToString();
        }
        if (!this.IsPostBack)
        {
            this.BindData();
            BuildPagers();
        }
    }
    public void BindData()
    {
        string strWhere = string.Empty;

        if (Request.QueryString["key"] != null)
        {
            string key = Convert.ToString(Request.QueryString["key"]);
            strWhere = string.Format("UserName like '%{0}%'", key);
            strUrl = string.Format("&key={0}", key);
        }
        this.GridView1.DataSource = Users.GetAllUsersByStrWhere(PageItem, CurrentPage, strWhere, out TotalCountRecord);
        this.GridView1.DataBind();
    }
    public void BuildPagers()
    {
        //偏移量
        int Step = 10;
        int LeftNum = 0;
        int RightNum = 0;
        string PageUrl = Request.FilePath;
        int PageCount = (int)Math.Ceiling((double)(TotalCountRecord) / PageItem);
        if (CurrentPage - Step < 1)
        {
            LeftNum = 1;
        }
        else
        {
            LeftNum = CurrentPage - Step;
        }

        if (CurrentPage + Step > PageCount)
        {
            RightNum = PageCount;
        }
        else
        {
            RightNum = CurrentPage + Step;
        }
        StringBuilder OutPut = new StringBuilder();

        for (int i = LeftNum; i <= RightNum; i++)
        {
            if (i == CurrentPage)
            {
                OutPut.Append("<font style='margin-left:3px;' color=red>");
                OutPut.Append(i.ToString());
                OutPut.Append("</font>");
            }
            else
            {
                OutPut.Append("<a style='margin-left:3px;' href='");
                OutPut.Append(PageUrl);
                OutPut.Append("?page=");
                OutPut.Append(i.ToString());
                OutPut.Append(strUrl);
                OutPut.Append("'>");
                OutPut.Append(i.ToString());
                OutPut.Append("</a>");
            }
        }

        if (CurrentPage > 1)
        {
            OutPut.Insert(0, string.Format("<a href='{0}?page={1}{2}'>上一页</a>", PageUrl, (CurrentPage - 1), strUrl));
        }

        if (CurrentPage < PageCount)
        {
            OutPut.Append("<a href='");
            OutPut.Append(PageUrl);
            OutPut.Append("?page=");
            OutPut.Append(CurrentPage + 1);
            OutPut.Append(strUrl);
            OutPut.Append("'>下一页</a></li>");
        }
        this.Label3.Text = OutPut.ToString();
        this.Label2.Text = string.Format("总记录数:<font color='red'>{0}</font>  总页数:<font color='red'>{1}</font>", TotalCountRecord, PageCount);
    }



    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.Cells[5].HasControls())
        {
            LinkButton BtnDelete = (LinkButton)e.Row.Cells[5].Controls[0];
            if (BtnDelete.Text.Equals("删除"))
            {
                BtnDelete.Attributes.Add("OnClick", "javascript:return confirm('" + string.Format("您确认要删除{0}吗？", DataBinder.Eval(e.Row.DataItem, "UserName")) + "')");
            }

        }

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            CheckBox checkbox2 = e.Row.Cells[6].FindControl("CheckBox1") as CheckBox;
            checkbox2.Attributes.Add("onclick", "javascript:ChangeColor(this,'" + e.Row.ClientID + "')");
        }
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int UserID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
        Users singleUser = new Users();
        singleUser.UserID = UserID;
        if (Users.DeleteUser(singleUser))
        {
            this.BindData();
            BuildPagers();
            Label4.Text = "删除成功";
        }
        else
        {
            Label4.Text = "删除失败";
        }

    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int UserID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex]["UserID"].ToString());

        string newUserName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("UserName")).Text;
        string newUserPwd = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("UserPwd")).Text;
        int newGrade = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].FindControl("Grade")).Text);

        Users singleUser = new Users();

        singleUser.UserID = UserID;
        singleUser.UserName = newUserName;
        singleUser.UserPwd = newUserPwd;
        singleUser.Grade = newGrade;

        Users.UpdateUser(singleUser);
        GridView1.EditIndex = -1;

        this.BindData();
        BuildPagers();
    }


    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        this.BindData();
        BuildPagers();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int intCount = GridView1.Rows.Count;
        for (int i = 0; i < intCount; i++)
        {
            CheckBox checkbox2 = this.GridView1.Rows[i].Cells[7].FindControl("CheckBox1") as CheckBox;
            if (checkbox2.Checked)
            {
                int UserID = Convert.ToInt32(this.GridView1.Rows[i].Cells[0].Text);
                Users SingleUser = new Users();
                SingleUser.UserID = UserID;
                Users.DeleteUser(SingleUser);
            }

        }
        this.BindData();
        BuildPagers();
    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        string UserName = args.Value;
        if (Users.IsValidateUserName(UserName))
        {
            args.IsValid = false;

        }
        else
        {
            args.IsValid = true;
        }
       
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            string UserName = TextBox1.Text.ToString();
            string UserPwd = TextBox2.Text.ToString();
            int Grade = RadioButtonList1.SelectedValue.ToString();
            Users SingleUser = new Users();
            SingleUser.UserName = UserName;
            SingleUser.UserPwd = UserPwd;
            SingleUser.Grade = Grade;

            if (Users.AddUser(SingleUser))
            {
                Label2.Text = "添加成功！";
                this.GridView1.DataBind();
            }
            else
            {

                Label2.Text = "添加失败！";
            }

        }
    }
}

<%@ Page Language="C#" MasterPageFile="~/Admin/Admin.master" AutoEventWireup="true" CodeFile="Admin.aspx.cs" Inherits="Admin_Users" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
         <script type="text/javascript">

function SelectAll(tempControl)
    {
     var theBox=tempControl;
    xState=theBox.checked;
   elem=theBox.form.elements;
    for(i=0;i<elem.length;i++)
    {
        if(elem[i].type=="checkbox" && elem[i].id!=theBox.id)
        {
            if(elem[i].checked!=xState)
            {
                elem[i].click();
            }
           
        }
    }

}
function ChangeColor(a,b)
{
    var theBox=a;
    var tr=document.getElementById(b);
    if (theBox.checked)
    {
        tr.style.backgroundColor="red";
       
    }
    else
        tr.style.backgroundColor="#cccccc"
   

}

</script>
   
    <table border="0" cellpadding="0" cellspacing="0" style="width:600px; height: 182px">
        <tr>
            <td style="width: 622px">
                欢迎<asp:Label ID="Label1" runat="server" Width="33px"></asp:Label>登陆</td>
        </tr>
        <tr>
            <td style="text-align: right; width: 622px; height: 156px;" >
                <asp:GridView ID="GridView1" runat="server" Height="100%" Width="100%" AutoGenerateColumns="False" DataKeyNames="UserID" OnRowDataBound="GridView1_RowDataBound" OnRowDeleting="GridView1_RowDeleting" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" HorizontalAlign="Center" >
                    <Columns>
                        <asp:BoundField DataField="UserID" HeaderText="ID" >
                            <ControlStyle Width="20px" />
                        </asp:BoundField>
                        <asp:TemplateField HeaderText="用户名">
                        <ItemTemplate>
                               <%#Eval("username") %>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="UserName" runat="server" Text='<%#Eval("username") %>' Width="100px"></asp:TextBox>
                            </EditItemTemplate>
                        </asp:TemplateField>
                       
                        <asp:TemplateField HeaderText="密码">
                        <ItemTemplate>
                               <%#Eval("UserPwd") %>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="UserPwd" runat="server" Text='<%#Eval("UserPwd") %>' Width="100px"></asp:TextBox>
                            </EditItemTemplate>
                        </asp:TemplateField>   
                                           
                        <asp:BoundField DataField="RegisterDate" HeaderText="添加日期" >
                            <ControlStyle Width="100px" />
                        </asp:BoundField>
                       
                        <asp:TemplateField HeaderText="权限">
                        <ItemTemplate>
                               <%#Eval("Grade") %>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <asp:TextBox ID="Grade" runat="server" Text='<%#Eval("Grade") %>' Width="30px"></asp:TextBox>
                            </EditItemTemplate>
                        </asp:TemplateField>   
                      
                        <asp:CommandField ShowEditButton="True" />
                        <asp:CommandField ShowDeleteButton="True" />
                        <asp:TemplateField>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBox1" runat="server" />
                            </ItemTemplate>
                            <HeaderTemplate>                       
                                <asp:CheckBox ID="CheckBox2" runat="server" οnclick="javascript:SelectAll(this);"/>
                            </HeaderTemplate>
                        </asp:TemplateField>

                    </Columns>
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <EditRowStyle BackColor="#999999" />
                    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:GridView>
                <asp:Label ID="Label2" runat="server" Width="150px"></asp:Label>
                <asp:Label ID="Label3" runat="server" Width="71px"></asp:Label>
                &nbsp; &nbsp;
                <asp:Label ID="Label4" runat="server" Width="77px"></asp:Label>
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<asp:Button
                    ID="Button1" runat="server" Text="删除" Width="45px" OnClick="Button1_Click" CausesValidation="False" /></td>
        </tr>
        <tr>
            <td style="height: 160px; width: 622px;" >
                <br />
                <table border="1" cellpadding="0" cellspacing="0" style="width: 317px; height: 136px">
                    <tr>
                        <td colspan="2" style="background-color: #c9c9c9; height: 26px;">
                            添加管理员</td>
                    </tr>
                    <tr>
                        <td style="width: 100px; text-align: right; height: 47px;">
                            管理员：</td>
                        <td style="text-align: left; width: 213px; height: 47px;" >
                            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                                ErrorMessage="**"></asp:RequiredFieldValidator><br />
                            <asp:CustomValidator ID="CustomValidator1" runat="server" ControlToValidate="TextBox1"
                                ErrorMessage="用户名已存在！" Font-Size="12px" OnServerValidate="CustomValidator1_ServerValidate"
                                Width="84px"></asp:CustomValidator></td>
                    </tr>
                    <tr>
                        <td style="text-align: right; height: 47px;" >
                            密 &nbsp;&nbsp; 码：</td>
                        <td style="text-align: left; width: 213px; height: 47px;" >
                            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                                ErrorMessage="**"></asp:RequiredFieldValidator></td>
                    </tr>
                    <tr>
                        <td style="height: 46px; text-align: right" >
                            权 &nbsp;&nbsp; 限：</td>
                        <td style="width: 213px; height: 46px; text-align: left" >
                            <asp:RadioButtonList ID="RadioButtonList1" runat="server" Font-Size="Smaller" RepeatDirection="Horizontal"
                                TextAlign="Left" Width="189px">
                                <asp:ListItem Value="0" Selected>一般管理员</asp:ListItem>
                                <asp:ListItem Value="1">超级管理员</asp:ListItem>
                            </asp:RadioButtonList></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 36px">
                            <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="添加" Width="45px" /></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

 

 

fxj331072
关注
GridView控件应用十个经典实例
11-21
1、数据绑定并实现分页功能 2、选中编辑取消删除数据项 3、GridView正反双向排序的功能 4、GridView控件中DropDownList控件的绑定 5、GridView控件中动态添加模板列 6、通过CheckBox删除选中记录 7、在GridView控件中实现跨页面多选 8、删除GridView控件行信息弹出确认提示框 9、在GridView控件中实现在动编号
GridView例子
04-02
很全的GridView例子 例子 GridView自动编号 GridView增删改 GridView隐藏列 GridView行背景颜色 GridView突显单元格 GridView省略字符 GridView求和平均值 GridView排序 GridView结合控件 GridView合并表头 GridView固定表头 GridView分页 GridView导入导出 GridView弹出窗口 GridView查询 GridView绑定图片
GridView实例
邹玉杰（邹琼俊）的专栏
09-26 890
<br />using System;<br />using System.Collections;<br />using System.Configuration;<br />using System.Data;<br />using System.Linq;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Web.UI.HtmlControls;<br /
GridView三个例子
shotaSu的博客
02-16 771
下面有三个例子，第一个是只显示图片的，第二个是显示图片文字的(这里的图片是Android系统自带的图片)，第三个是显示自定义的图片文字。前面两个例子的实现都不是很难，第三个例子的实现有些复杂，学习GridView的时候，就想着能不能自定义自己喜欢的图片加上文字，在网上找些资料，一般都是第二个例子的形式的，最后在视频学习上找到了能实现自定义自己的图片的例子。自己就照着例子去学习，修改成了第三个例子。
GridView 19例
luobailian的专栏
07-14 5351
快速预览：GridView无代码分页排序GridView选中，编辑，取消，删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“...”代替超长字符串GridView一般换行与强制换行GridVi
RecyclerView 瀑布流、ListView、GridView实例源码
04-15
在Android开发中，UI界面的展示是至关重要的，RecyclerView、ListView和GridView是常见的列表控件，用于展示大量的数据。本文将深入探讨这三个组件，并通过一个Demo_recyclerview的实例源码来解析它们的工作原理和...
Android中实现多行、水平滚动的分页的Gridview实例
01-05
如果是多行水平滚动，则结合Gridview（一般是垂直滚动的）和Horizontalscrollview实现。 (2)水平滚动翻页，下面有显示当前页的icon。1.实现自定义的HorizontalScrollView(HorizontalScrollView.java)： 因为要翻页...
Gridview实例C#
12-19
本实例“Gridview实例C#”旨在通过具体的代码示例，帮助开发者深入理解和掌握GridView的使用技巧。 GridView控件允许我们以网格形式显示数据源中的数据，如数据库表、XML文件或任何其他数据集合。在C#编程环境中，...
gridview例子
weixin_30832405的博客
09-08 66
直接贴代码 MainActivity.java public class MainActivity extends AppCompatActivity { private GridView _gridView = null; private List<ObjectEntity> _dataSource = null; @Overrid...
gridview 示例
09-26
GridView的多个使用示例.详细分解.
GridView小例子_红桃GLF 的博客
10-28
在手机首页显示的app应用图标都是以网格的形式展示的，所以今天就来学习一下GridView组件。列表分为单行和多行，如果是列表（单列多行形式）的使用ListView，如果是多行多列网状形式的优先使用GridView。
Android：控件GridView的使用实例
09-01
本篇文章主要介绍了Android：控件GridView的使用实例，控件GridView是android布局的重要组成，有兴趣的可以了解一下。
GridView各功能实例
04-15
GridView各功能实例GridView各功能实例GridView各功能实例
gridview 实例
Talk Is Cheap
04-17 618
http://www.cnblogs.com/over140/archive/2010/10/19/1855366.html
gridview实例
weixin_34306593的博客
05-25 83
<GridViewandroid:id="@+store/grid"android:layout_width="wrap_content" android:layout_height="wrap_content"android:layout_below="@store/main_daohang"android:numColumns="3" ...
GridView一些实例
09-09 750
前台代码http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" >    GridView实例一             function SelectAll(obj)    {        var allInput = document.getElementsByT
ASP.NET GridView 实例教程：操作与技巧解析
"本文详细介绍了在Visual Studio 2010中使用ASP.NET的GridView控件进行数据展示和操作的各种技巧，包括无代码分页排序、选中编辑删除功能、正反双向排序、与下拉菜单和复选框的结合、行背景色变化、删除确认对话框、...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值