GridView右键菜单，进行无刷新操作

来源：互联网发布：php接收app上传图片编辑：程序博客网时间：2024/06/11 21:58

工作之余，写了个gridview的右键菜单示例，希望可以帮助需要的人。

示例抓图：

程序打包下载地址： http://download.csdn.net/source/1049911

全部代码附上

default.aspx

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

<!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>
    <title></title>
    <script type="text/javascript" src="default.js"></script>
    <style type="text/css">
    #divh { position:absolute; z-index:1001; left:40%; top:30%; width:300px; margin-left:-200px; border:solid 6px #ddd; }
    .box { border:solid 1px #999; font-size:12px; }
    #tit { border-bottom:solid 1px #999;background-color:#cccccc; padding:6px; font-weight:bold;}
    #bod { background-color:#ffffff; padding:20px; }
    #bot { border-top:solid 1px #999;background-color:#cccccc; text-align:right;}
    .menu { position:absolute; z-index:101; width:100px; border:solid 1px #999; padding:2px; background-color:#ffffff;}
    .menu a { display:block; padding:3px 6px; font-size:12px; color:#000000; cursor:default; text-decoration:none; }
    .menu a:hover { background-color:#507cd1; color:#ffffff;}
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" Width="260" Font-Size="10">
                <RowStyle BackColor="#EFF3FB" HorizontalAlign="center" />
                <Columns>
                    <asp:BoundField DataField="_id" HeaderText="编号" />
                    <asp:BoundField DataField="_name" HeaderText="姓名" />
                    <asp:BoundField DataField="_sex" HeaderText="性别" />
                    <asp:BoundField DataField="_age" HeaderText="年龄" />
                </Columns>
                <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="White" />
            </asp:GridView>
        </div>
        <div id="divh" style="display: none;">
        <div class="box">
        <div id="tit"></div>
        <div id="bod"></div>
        <div id="bot"></div>
        </div>
        </div>
    </form>
</body>
</html>

default.aspx.cs

using System;
using System.Data;
using System.Configuration;
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;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["getinfo"] != null)
        {
            GetInfo();
            Response.End();
        }
        if (Request.QueryString["delete"] != null)
        {
            DeleteInfo();
            Response.End();
        }
        if (Request.QueryString["edit"] != null)
        {
            EditInfo();
            Response.End();
        }
        if (!IsPostBack)
        {
            CreateTable();

            DataTable dt = DB.GetTable("select * from test_users");
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }

    private void CreateTable()
    {
        string sql = "select [name] from sysobjects where objectproperty(object_id('test_users'),'istable') = 1";
        int c = DB.GetTable(sql).Rows.Count;
        if (c > 0) return;
        sql = @"create table test_users(
_id int identity(1,1) not null,
_name varchar(50) not null,
_sex varchar(4) not null,
_age int null,
_email varchar(100) null,
_address varchar(200) null) ;
insert into test_users(_name,_sex,_age,_email,_address)
select '刘备','男',32,'liubei@sanguo.com','朝阳公园' union
select '关羽','男',28,'guanyu@sanguo.com','中关村' union
select '张飞','男',27,'zhangfei@sanguo.com','八里庄西里' union
select '赵云','男',22,'zhaoyun@sanguo.com','东长安街' union
select '貂蝉','女',20,'diaochan@sanguo.com','避暑山庄'";
        DB.Execute(sql);
    }

    private void GetInfo()
    {
        int id = 0;
        if (!int.TryParse(Request.QueryString["id"], out id))
        {
            Response.Write("error");
            return;
        }
        string sql = "select * from test_users where _id=" + id.ToString();
        DataTable dt = DB.GetTable(sql);
        if (dt.Rows.Count == 0)
        {
            Response.Write("error");
            return;
        }
        DataRow row = dt.Rows[0];

        StringBuilder sb = new StringBuilder();
        sb.Append("<table>");
        sb.AppendFormat("<tr><td>姓名：</td><td>{0}</td></tr>", row["_name"]);
        sb.AppendFormat("<tr><td>性别：</td><td>{0}</td></tr>", row["_sex"]);
        sb.AppendFormat("<tr><td>年龄：</td><td>{0}</td></tr>", row["_age"]);
        sb.AppendFormat("<tr><td>邮件：</td><td>{0}</td></tr>", row["_email"]);
        sb.AppendFormat("<tr><td>地址：</td><td>{0}</td></tr>", row["_address"]);
        sb.Append("</table>");

        Response.Write(sb.ToString());
    }

    private void DeleteInfo()
    {
        int id = 0;
        if (!int.TryParse(Request.QueryString["id"], out id))
        {
            Response.Write("error");
            return;
        }
        string sql = "delete from test_users where _id=" + id.ToString();
        DB.Execute(sql);
        Response.Write("true");
    }

    private void EditInfo()
    {
        int id = 0;
        if (!int.TryParse(Request.QueryString["id"], out id))
        {
            Response.Write("error");
            return;
        }
        string sql = "update test_users set _name='{1}',_sex='{2}',_age={3} where _id={0}";
        sql = String.Format(sql, id, Request["name"].Replace("'", ""), Request["sex"] == "男" ? "男" : "女", int.Parse(Request["age"]));
        DB.Execute(sql);
        Response.Write("true");
    }
}

DB.cs

using System;
using System.Data;
using System.Data.SqlClient;

public class DB
{
    public DB()
    {

    }

    public static SqlConnection SqlConn
    {
        get { return new SqlConnection("server=(local);database=tempdb;uid=sa;pwd=;"); }
    }

    public static DataTable GetTable(string sql)
    {
        using (SqlConnection conn = SqlConn)
        {
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }
    }

    public static int Execute(string sql)
    {
        using (SqlConnection conn = SqlConn)
        {
            SqlCommand cmd = new SqlCommand(sql, conn);

            conn.Open();
            return cmd.ExecuteNonQuery();
        }
    }
}

default.js

本人新开发博客平台 www.cnopenblog.com，欢迎访问