小山

付出最大努力，追求最高成就，享受最佳生活，收获无悔人生
博客园 首页 新随笔 联系 订阅 管理
  193 Posts :: 0 Stories :: 1156 Comments :: 70 Trackbacks
功能齐全的DataGrid
//目前功能：编辑、排序、单选项、复选项、合并单元格、产生序列号、联动下拉框、删除、超连接、鼠标移动改变颜色、奇偶项颜色区分、排序、分页

1.html代码
<HTML>
    <HEAD>
        <title>DatagridTest</title>
        <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
        <meta content="C#" name="CODE_LANGUAGE">
        <meta content="JavaScript" name="vs_defaultClientScript">
        <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
        <script language="javascript">
            function fun_option(obj)
            {
                document.Form1.hiduserid.value=obj.value;
            }            
            function chkAll_true()
            {
                var chkall= document.all["chkAll"];
                var chkother= document.getElementsByTagName("input");
                for (var i=0;i<chkother.length;i++)
                {
                    if( chkother[i].type=='checkbox')
                    {
                        if(chkother[i].id.indexOf('chkExport')>-1)
                        {
                            if(chkall.checked==true)
                            {
                                chkother[i].checked=true;
                            }
                            else
                            {
                                chkother[i].checked=false;
                            }
                        }
                    }
                }
            }
            
            function Delete()
            {
                var  al = new Array();
                var chkother= document.getElementsByTagName("input");
                for(var i=0,j=0;i<chkother.length;i++)
                {
                    if( chkother[i].type =='checkbox')
                    {
                        if(chkother[i].id.indexOf('chkExport')>-1)
                        {
                            if(chkother[i].checked==true)
                            {
                                al[j] =chkother[i].value;
                                j++;
                            }
                        }
                    }
                }
                if (al == "")
                {
                    alert('You need to select a row in the list before selecting Delete.\r\nPlease select a row and try again.');
                }
                else if (window.confirm("Are you sure to delete all these?"))
                {
                    var deleteID='<%=btndelete.ClientID%>';
                    window.document.all(deleteID).click();
                }
                else { return false; }               
            }
        </script>
    </HEAD>
    <body>
        <form id="Form1" method="post" runat="server">
            <TABLE id="Table1" height="100%" cellSpacing="1" cellPadding="1" width="100%" border="1">
                <tr>
                    <td><asp:dropdownlist id="DropDownList1" runat="server" AutoPostBack="True"></asp:dropdownlist><asp:dropdownlist id="DropDownList2" runat="server" AutoPostBack="True"></asp:dropdownlist><asp:dropdownlist id="DropDownList3" runat="server"></asp:dropdownlist><asp:textbox id="TextBox1" runat="server"></asp:textbox><asp:checkbox id="CheckBox1" runat="server" Text="可见否"></asp:checkbox><asp:button id="Button1" runat="server" Text="保存"></asp:button><asp:button id="Button2" runat="server" Text="导出Excel"></asp:button></td>
                </tr>
                <tr height="30">
                    <td><INPUT id="chkAll" onclick="chkAll_true()" type="checkbox">全选/取消<asp:button id="btndelete" runat="server" Text="删除"></asp:button></td>
                </tr>
                <TR vAlign="top">
                    <TD width="100%" colSpan="5"><asp:datagrid id="DataGrid1" runat="server" OnDeleteCommand="Delete" ForeColor="Black" GridLines="None"
                            CellPadding="2" BackColor="LightGoldenrodYellow" BorderWidth="1px" BorderColor="Tan" AllowSorting="True" AutoGenerateColumns="False"
                            DataKeyField="UserID" OnUpdateCommand="Update" OnCancelCommand="Cancel" OnEditCommand="Edit" PageSize="5" AllowPaging="True">
                            <FooterStyle BackColor="Tan"></FooterStyle>
                            <SelectedItemStyle ForeColor="GhostWhite" BackColor="DarkSlateBlue"></SelectedItemStyle>
                            <AlternatingItemStyle BackColor="PaleGoldenrod"></AlternatingItemStyle>
                            <HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle>
                            <Columns>
                                <asp:TemplateColumn HeaderText="序号">
                                    <HeaderStyle Width="10px"></HeaderStyle>
                                    <ItemTemplate>
                                        <INPUT id=radio onclick=fun_option(this) type=radio value='<%# DataBinder.Eval(Container.DataItem,"UserID") %>' name=radio>
                                    </ItemTemplate>
                                    <FooterTemplate>
                                    </FooterTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn HeaderText="序号">
                                    <HeaderStyle Width="10px"></HeaderStyle>
                                    <FooterTemplate>
                                    </FooterTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn>
                                    <HeaderStyle Width="10px"></HeaderStyle>
                                    <ItemTemplate>
                                        <asp:CheckBox id="chkExport" Runat="server"></asp:CheckBox>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:BoundColumn DataField="UserID" SortExpression="UserID" ReadOnly="True" HeaderText="UserID">
                                    <HeaderStyle Width="70px"></HeaderStyle>
                                </asp:BoundColumn>
                                <asp:TemplateColumn SortExpression="UserName" HeaderText="姓名">
                                    <HeaderStyle Width="70px"></HeaderStyle>
                                    <ItemTemplate>
                                        <a href='form1.aspx?id=<%# DataBinder.Eval(Container.DataItem,"UserID") %>&name=<%# DataBinder.Eval(Container.DataItem,"UserName") %>' target="_blank">
                                            <%# DataBinder.Eval(Container.DataItem,"UserName") %>
                                        </a>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox id=UserName Text='<%# DataBinder.Eval(Container.DataItem,"UserName") %>' Width="100%" Runat="server">
                                        </asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn SortExpression="province" HeaderText="省市">
                                    <HeaderStyle Width="70px"></HeaderStyle>
                                    <ItemTemplate>
                                        <%# DataBinder.Eval(Container.DataItem,"province") %>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:DropDownList id="province" Width="100%" Runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlprovince_SelectedIndexChanged"></asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn SortExpression="city" HeaderText="县市">
                                    <HeaderStyle Width="70px"></HeaderStyle>
                                    <ItemTemplate>
                                        <%# DataBinder.Eval(Container.DataItem,"city") %>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:DropDownList id="city" Runat="server" Width="100%" AutoPostBack="True" OnSelectedIndexChanged="ddlcity_SelectedIndexChanged"></asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn SortExpression="area" HeaderText="乡镇">
  &nbs