sunfei

万事烦扰,皆由心生,心不动,何来纷扰!
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

1.前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testgridview2.aspx.cs" Inherits="web_testgridview2" %>

<!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>
</head>
<body>
    
<form id="form1" runat="server">
        
<div>
            
<table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px">
                
<tr>
                    
<td align="center">
                        
<asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"
                            AutoGenerateColumns
="False" AllowPaging="True" PageSize="12" BorderColor="Silver"
                            BorderStyle
="Solid" BorderWidth="1px" OnRowDataBound="GridView1_RowDataBound"
                            ShowFooter
="True" EmptyDataText="没有数据记录!!" AllowSorting="True" OnSorting="GridView1_Sorting">
                            
<Columns>
                                
<asp:BoundField HeaderText="编号" DataField="id" Visible="False" />
                                
<asp:TemplateField HeaderText="<input type='checkbox' id='chk' name='chk' onclick='checkJs(this.checked);'  />全选" FooterText="全选">
                                    
<ItemTemplate>
                                        
<input type="checkbox" id="checkboxname" name="checkboxname" value='<%# DataBinder.Eval(Container.DataItem, "id")%>' onclick='SingleCheckJs();' />
                                    
</ItemTemplate>
                                
</asp:TemplateField>
                                
<asp:TemplateField HeaderText="单选" FooterText="单选">
                                    
<ItemTemplate>
                                        
<input type="radio" id="RadioName" name="RadioName" value='<%# Eval("id")%>' />
                                    
</ItemTemplate>
                                
</asp:TemplateField>
                                
<asp:TemplateField HeaderText="自增列" FooterText="自增列">
                                    
<ItemTemplate>
                                        
<%# (Container.DataItemIndex+1).ToString()%>
                                    
</ItemTemplate>
                                
</asp:TemplateField>
                                
<asp:BoundField HeaderText="姓名" FooterText="姓名" DataField="name" SortExpression="name" />
                                
<asp:BoundField HeaderText="身份证号" FooterText="身份证号" DataField="card" SortExpression="card" />
                                
<asp:BoundField HeaderText="价格" FooterText="价格" DataField="price" DataFormatString="{0:¥#,##0.00}"
                                    HtmlEncode
="False" SortExpression="price" />
                                
<asp:BoundField HeaderText="数字" FooterText="数字" DataField="price" DataFormatString="{0:0.00}"
                                    HtmlEncode
="False" SortExpression="price" />
                                
<asp:BoundField HeaderText="建立时间" FooterText="建立时间" DataField="createdate" DataFormatString="{0:yyyy年MM月dd日 hh时mm分ss秒}"
                                    HtmlEncode
="False" SortExpression="createdate" />
                            
</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" />
                            
<FooterStyle Font-Bold="True" />
                            
<HeaderStyle Font-Bold="False" Font-Italic="False" />
                        
</asp:GridView>
                    
</td>
                
</tr>
                
<tr>
                    
<td align="center" style="height: 25px">
                        
<asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"
                            runat
="server">首 页</asp:LinkButton>
                        
<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></td>
                
</tr>
                
<tr>
                    
<td>
                        
<asp:Button ID="Button2" runat="server" Text="checkbox得到选择的行" OnClick="Button2_Click">
                        
</asp:Button>
                        
<asp:Button ID="Button1" runat="server" Text="radio得到选择的行" OnClick="Button1_Click"></asp:Button>
                    
</td>
                
</tr>
            
</table>
        
</div>
    
</form>
</body>
</html>

 2.后台代码:

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 web_testgridview2 : System.Web.UI.Page
{
    
protected void Page_Load(object sender, EventArgs e)
    
{
        Button2.Attributes[
"onclick"= "return slcNo_click();";
        GridViewBind(
"");
    }


    
private void GridViewBind(string Sqlsort)
    
{
        
string connStr = "server=xww;database=testdb;uid=sa;pwd=admin";
        
string SqlStr = "Select * FROM test01 where id<1000" + Sqlsort;
        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, 
"test01");
            
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();
            
//
        }

        
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 Button2_Click(object sender, EventArgs e)
    
{
        
string str = "";
        
string[] ckb = null;

        str 
= Request.Form.Get("checkboxname");
        ckb 
= str.Split(new char[] ',' });

        Response.Write(
"直接在页面中得到的值为:" + str + "<br>");

        Response.Write(
"处理后存放在数组中,如下:<br>");
        
for (int i = 0; i < ckb.Length; i++)
        
{
            Response.Write(
"ckb[" + i + "]的值为:" + ckb[i] + "<br>");
        }

    }

    
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["SortDirection"== null || ViewState["SortDirection"].ToString().CompareTo(""== 0)
        
{
            ViewState[
"SortDirection"= " desc";
        }

        
else
            ViewState[
"SortDirection"= "";

        sql 
= " order by " + e.SortExpression + ViewState["SortDirection"];

        GridViewBind(sql);
    }

}

3.数据库代码:

Create TABLE [dbo].[test01] (
    
[id] [decimal](180IDENTITY (11NOT NULL ,
    
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    
[card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    
[createdate] [datetime] NULL ,
    
[price][money] null
ON [PRIMARY]
GO

Alter TABLE [dbo].[test01] ADD 
    
CONSTRAINT [DF_test01_createdate] DEFAULT (getdate()) FOR [createdate],
    
CONSTRAINT [PK_test01] PRIMARY KEY  CLUSTERED 
    (
        
[id]
    )  
ON [PRIMARY] 
GO