jibie.aspx

系统使用VS2005编写 数据库 使用SQL server 2000 或 SQL server 2005 测试前请先修改app.config 或web.config 的数据库连接字符串

<%@ Page Language="C#"  MasterPageFile="~/MasterPage.master"  AutoEventWireup="true" CodeFile="JiBie.aspx.cs" Inherits="Nian" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
          <script language="javascript">


function CheckAll()
{
	//点击全部选择，选取本页面全部记录
	//因为在Form1中找不到chkSel的CheckBox,所以只好遍历整个document
	var cked=false;
	cked = document.getElementById("chkSelAll").checked;
	for(var i=0;i<document.all.length;i++)
	{
	   //  setInterval(window.open("url"),1000) 
     
		var e = document.all(i);
		try
		{//因为有些document的元素没有name属性，所以加上异常处理。
		//alert(e.name.substring(e.name.length-6,e.name.length));
			if(e.name.substring(e.name.length-6,e.name.length)=="chkSel")
			{
				e.checked = cked;
			}
		}
		catch(exception)
		{
		}
	}		
}
function WhetherSelect()
{
	//点击全部选择，选取本页面全部记录
	//因为在Form1中找不到chkSel的CheckBox,所以只好遍历整个document
	var cked=false;
	cked = document.getElementById("chkSelAll").checked;
	for(var i=0;i<document.all.length;i++)
	{
		var e = document.all(i);
		try
		{//因为有些document的元素没有name属性，所以加上异常处理。
		//alert(e.name.substring(e.name.length-6,e.name.length));
			if(e.name.substring(e.name.length-6,e.name.length)=="chkSel")
			{
			if(e.checked )//有选择数据
			    {
			        if( confirm('你确认删除此项数据吗?'))
			        {
    			    return true;
			        }
			        else //不删除
			        {
			       
			        return false;
			        }
			        
			    }
				
			}
		}
		catch(exception)
		{
		}
	}	
	 alert("你没有选择任何数据");
	return false; //没有数据被选择
}
    </script>

    请选择级别：&nbsp;<asp:DropDownList ID="ddlNian" runat="server">
        </asp:DropDownList>
        <asp:Button ID="btnQuery" runat="server" Text="查询" OnClick="btnQuery_Click" />&nbsp;
        <asp:Button ID="btnAdd" runat="server" Text="增加" OnClick="btnAdd_Click" />
        <asp:Button ID="btnDel" runat="server" Text="删除" OnClick="btnDel_Click" />
        <asp:Label ID="lMsg" runat="server"></asp:Label><br />
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="JBID" ForeColor="#333333"
            GridLines="None" PageSize="10" Width="329px" OnRowDataBound="GridView1_RowDataBound" OnPageIndexChanging="GridView1_PageIndexChanging">
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:TemplateField>
                    <HeaderTemplate>
                        全选<input id="chkSelAll" name="chkSelAll" onclick="javascript:CheckAll();" type="checkbox">
                    </HeaderTemplate>
                    <HeaderStyle Width="50px" />
                    <ItemTemplate>
                        <asp:CheckBox ID="chkSel" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:HyperLinkField HeaderText="序号" />
                <asp:BoundField DataField="JBID" HeaderText="编号" Visible="False" />
                <asp:HyperLinkField DataNavigateUrlFields="JBID" DataNavigateUrlFormatString="JBadd.aspx?JBID={0}"
                    DataTextField="JBName" HeaderText="级别" />
            </Columns>
            <AlternatingRowStyle BackColor="White" />
            <PagerSettings PageButtonCount="15" />
            <RowStyle BackColor="#EFF3FB" />
            <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" />
        </asp:GridView>
</asp:Content>