• GridView实现删除时弹出确认对话框


    效果图:



    实现方法:
    双击GridView的OnRowDataBound事件;
    在后台的GridView1_RowDataBound()方法添加代码,最后代码如下所示:

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            //如果是绑定数据行
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                 if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
                {
                    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:\"" + e.Row.Cells[1].Text + "\"吗?')");
                }
            }

        }

    9.GridView实现自动编号:

    效果图:


    实现方法:
    双击GridView的OnRowDataBound事件;
    在后台的GridView1_RowDataBound()方法添加代码,最后代码如下所示:
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            //如果是绑定数据行 //清清月儿http://blog.csdn.net/21aspnet
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                ////鼠标经过时,行背景色变
                //e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
                ////鼠标移出时,行背景色变
                //e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");

                ////当有编辑列时,避免出错,要加的RowState判断
                //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
                //{
                //    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:\"" + e.Row.Cells[1].Text + "\"吗?')");
                //}

            }
            if (e.Row.RowIndex != -1)
            {
                int id = e.Row.RowIndex + 1;
                e.Row.Cells[0].Text = id.ToString();
            }

        }

    注意这时最好把前台的第一列的表头该为“编号”,因为以前的第一列被“吃掉”了。
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="3" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
                            OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" OnRowDataBound="GridView1_RowDataBound">
                            <FooterStyle BackColor="White" ForeColor="#000066" />
                            <Columns>
                                <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                                <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
                                <asp:BoundField DataField="员工性别" HeaderText="性别" />
                                <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
                                <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                                <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                                <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                            </Columns>
                            <RowStyle ForeColor="#000066" />
                            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                        </asp:GridView>

    10.GridView实现自定义时间货币等字符串格式:

    效果图:
    图1-未格式化前


    图2-格式化后


    解决方法:
    在asp.net 2.0中,如果要在绑定列中显示比如日期格式等,如果用下面的方法是显示不了的

    <asp :BoundField DataField="CreationDate"
    DataFormatString="{0:M-dd-yyyy}"
    HeaderText="CreationDate" />

    主要是由于htmlencode属性默认设置为true,已防止XSS攻击,安全起见而用的,所以,可以有以下两种方法解决

    1、

    <asp :GridView ID="GridView1" runat="server">
    <columns>
    <asp :BoundField DataField="CreationDate"
    DataFormatString="{0:M-dd-yyyy}"
    HtmlEncode="false"
    HeaderText="CreationDate" />
    </columns>
    </asp>

    将htmlencode设置为false即可

    另外的解决方法为,使用模版列

    <asp :GridView ID="GridView3" runat="server" >
    <columns>
    <asp :TemplateField HeaderText="CreationDate" >
    <edititemtemplate>
    <asp :Label ID="Label1" runat="server"
    Text='<%# Eval("CreationDate", "{0:M-dd-yyyy}") %>'>
    </asp>
    </edititemtemplate>
    <itemtemplate>
    <asp :Label ID="Label1" runat="server"
    Text=’<%# Bind("CreationDate", "{0:M-dd-yyyy}") %>'>
    </asp>
    </itemtemplate>
    </asp>
    </columns>
    </asp>

    前台代码:
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="身份证号码"
                DataSourceID="SqlDataSource1" AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Size="12px" OnRowDataBound="GridView1_RowDataBound">
                <Columns>
                    <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" ReadOnly="True" SortExpression="身份证号码" />
                    <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
                    <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
                    <asp:BoundField DataField="出生日期" HeaderText="出生日期" SortExpression="出生日期" />
                    <asp:BoundField DataField="起薪" HeaderText="起薪" SortExpression="起薪" />
                </Columns>
                <FooterStyle BackColor="White" ForeColor="#000066" />
                <RowStyle ForeColor="#000066" />
                <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:北风贸易ConnectionString1 %>"
                SelectCommand="SELECT top 5 [出生日期], [起薪], [身份证号码], [姓名], [家庭住址], [邮政编码] FROM [飞狐工作室]" DataSourceMode="DataReader"></asp:SqlDataSource>

    附录-常用格式化公式:
    {0:C}  货币;
    {0:D4}由0填充的4个字符宽的字段中显示整数;
    {0:000.0}四舍五入小数点保留第几位有效数字;
    {0:N2}小数点保留2位有效数字;{0:N2}%   小数点保留2位有效数字加百分号;
    {0:D}长日期;{0:d}短日期;{0:yy-MM-dd}   例如07-3-25;;{0:yyyy-MM-dd}  例如2007-3-25

  • 相关阅读:
    四则运算(Android)版
    返回二维数组最大联通子数组的和
    第二阶段每日总结08
    第二阶段每日总结07
    第十三周进度条
    第二阶段每日总结06
    第二阶段每日总结05
    找水王02
    第二阶段每日总结04
    浪潮之巅阅读笔记01
  • 原文地址:https://www.cnblogs.com/nianyuwen/p/3003801.html
Copyright © 2020-2023  润新知