有关DataGrid的所有代码

来源：互联网发布：电脑网络异常怎么回事编辑：程序博客网时间：2024/04/29 22:14

有网友向我索取代码，现在帖出所有
这个DataGrid包含以下功能的示范：
添加、删除、修改、分页、下载数据到客户端、合计、筛选记录、单选、多选。

数据库表名:tb1，其中有3个字段，分别是ID自增的主键、vName varchar(50)、iAge int

客户端代码：
<%...@ Page language="c#" Codebehind="WebForm5.aspx.cs" AutoEventWireup="false" Inherits="csdn.WebForm5" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>WebForm5</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">
    </HEAD>
    <body>
        <form id="Form1" method="post" runat="server">
            <input type="hidden" id="rd" runat="server" name="rd">
            <asp:textbox id="TextBox1" runat="server" Width="88px"></asp:textbox>
            <asp:TextBox id="TextBox2" runat="server" Width="40px"></asp:TextBox>
            <asp:Button id="Button1" runat="server" Text="添加"></asp:Button>
            <asp:TextBox id="TextBox3" runat="server" Width="128px"></asp:TextBox>
            <asp:Button id="Button2" runat="server" Text="筛选"></asp:Button>
            <asp:Button id="Button3" runat="server" Text="下载"></asp:Button>
            <asp:datagrid id="DataGrid1" runat="server" AutoGenerateColumns="False" DataKeyField="ID" AllowPaging="True"
                PageSize="20" OnEditCommand="edit" OnCancelCommand="cancel" OnUpdateCommand="update">
                <Columns>
                    <asp:TemplateColumn HeaderText="多选">
                        <ItemTemplate>
                            <input type="hidden" id="SelectedID" runat="server"
                value='<%# Container.ItemIndex%>' NAME="SelectedID"/>
                            <asp:CheckBox ID="chkExport" Runat="server" />
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="单选">
                        <ItemTemplate>
                            <%...# Container.ItemIndex+1%>
                            <input type=radio name="rad" value='<%# Container.ItemIndex+1%>'>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="姓名">
                        <ItemTemplate>
                            <%...# myfunc(DataBinder.Eval(Container.DataItem,"vName")) %>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id="name" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"vName") %>' Width="88px">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="年龄">
                        <ItemTemplate>
                            <%...# DataBinder.Eval(Container.DataItem,"iAge") %>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id="age" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"iAge") %>' Width="40px">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="打开">
                        <ItemTemplate>
                            <asp:HyperLink Text="打开" NavigateUrl='<%#"newpage.aspx?name="+DataBinder.Eval(Container.DataItem, "vname")+"&age="+DataBinder.Eval(Container.DataItem, "iage") %>' Runat="server" Target="_blank">
                            </asp:HyperLink>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="打开">
                        <ItemTemplate>
                            <asp:HyperLink Text="打开" NavigateUrl='<%# myfunc2(DataBinder.Eval(Container.DataItem,"vName"),DataBinder.Eval(Container.DataItem,"iAge"))%> ' Runat="server" Target="_blank" ID="Hyperlink1">
                            </asp:HyperLink>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
                    <asp:ButtonColumn Text="删除" CommandName="del"></asp:ButtonColumn>
                </Columns>
                <PagerStyle Mode="NumericPages"></PagerStyle>
            </asp:datagrid>
            <asp:Label id="Label1" runat="server"></asp:Label>
            <asp:Button id="button4" runat="server" Text="单选结果"></asp:Button>
            <asp:Button id="Button5" runat="server" Text="多选结果"></asp:Button>
            <asp:Button id="Button6" runat="server" Text="选中所有"></asp:Button>
            <asp:Button id="Button7" runat="server" Text="取消所有"></asp:Button></form>
    </body>
</HTML>
服务端代码：
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls; using System.IO;

namespace csdn
...{
    /**//// <summary>
    /// WebForm5 的摘要说明。
    /// </summary>
    public class WebForm5 : System.Web.UI.Page
    ...{
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.TextBox TextBox2;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.TextBox TextBox3;
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.Button Button3;
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.HtmlControls.HtmlInputHidden rd;
        protected System.Web.UI.WebControls.Button button4;
        protected System.Web.UI.WebControls.Button Button5;
        protected System.Web.UI.WebControls.Button Button6;
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.WebControls.Button Button7;


        private void Page_Load(object sender, System.EventArgs e)
        ...{

            string js = "";
            js+="<script>/r/n";
            js+="function ld(){/r/n";
            js+="for(i=0;i<document.getElementsByName('rad').length;i++)/r/n";
            js+="if(document.getElementsByName('rad')[i].value==";
            js+="document.getElementById('rd').value) ";
            js+="document.getElementsByName('rad')[i].checked=true/r/n";
            js+="}/r/n";
            js+="window.onload=ld/r/n";
            js+="</script>/r/n";
            this.RegisterClientScriptBlock("js",js);

            if(!IsPostBack)
            ...{
                SetBind();
            }

        }

        protected void SetBind()
        ...{

            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
            SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
            DataSet ds=new DataSet();
            da.Fill(ds,"table1");
            this.DataGrid1.DataSource=ds.Tables["table1"];
            this.DataGrid1.DataBind();
            this.Label1.Text=ds.Tables["table1"].Compute("avg(iAge)","iAge>20").ToString();
        }

        protected void SetBind(string s)
        ...{
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
            SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
            DataSet ds=new DataSet();
            da.Fill(ds,"table1");
            DataView dv=ds.Tables["table1"].DefaultView;
            dv.RowFilter=s;
            this.DataGrid1.DataSource=dv;
            this.DataGrid1.DataBind();
        }

        Web 窗体设计器生成的代码

        private void Button1_Click(object sender, System.EventArgs e)
        ...{
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
            SqlCommand comm=new SqlCommand("insert into tb1 (vName,iAge) values (@vName,@iAge)",conn);
            SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
            parm1.Value=this.TextBox1.Text;
            SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
            parm2.Value=this.TextBox2.Text;
            comm.Parameters.Add(parm1);
            comm.Parameters.Add(parm2);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
            SetBind();
        }

        private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        ...{
            if(e.CommandName=="del"&&e.Item.ItemType!=ListItemType.EditItem)
            ...{
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
                SqlCommand comm=new SqlCommand("delete from tb1 where ID=@id",conn);
                SqlParameter parm1=new SqlParameter("@id",SqlDbType.Int);
                parm1.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
                comm.Parameters.Add(parm1);
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                SetBind();
            }
        }

        private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
        ...{
            this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
            SetBind();
        }

        protected void edit(object sender,DataGridCommandEventArgs e)
        ...{
            this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
            SetBind();
        }

        protected void cancel(object sender,DataGridCommandEventArgs e)
        ...{
            this.DataGrid1.EditItemIndex=-1;
            SetBind();
        }

        protected void update(object sender,DataGridCommandEventArgs e)
        ...{
            if(e.Item.ItemType==ListItemType.EditItem)
            ...{
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
                SqlCommand comm=new SqlCommand("update tb1 set vName=@vName,iAge=@iAge where ID=@id",conn);
                SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
                parm1.Value=((TextBox)e.Item.FindControl("name")).Text;
                SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
                parm2.Value=((TextBox)e.Item.FindControl("age")).Text;
                SqlParameter parm3=new SqlParameter("@id",SqlDbType.Int);
                parm3.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
                comm.Parameters.Add(parm1);
                comm.Parameters.Add(parm2);
                comm.Parameters.Add(parm3);
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                this.DataGrid1.EditItemIndex=-1;
                SetBind();
            }
        }

        private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        ...{

                if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
                ...{
                    ((LinkButton)e.Item.Cells[7].Controls[0]).Attributes.Add("onclick","return confirm('delete?');");
                }

        }

        private void Button2_Click(object sender, System.EventArgs e)
        ...{
            if(this.TextBox3.Text=="")
            ...{
                SetBind();
            }
            else
            ...{
                SetBind(this.TextBox3.Text);
            }
        }

        private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
        ...{

        }

        private void Button3_Click(object sender, System.EventArgs e)
        ...{
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
            SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
            DataSet ds=new DataSet();
            da.Fill(ds,"table1");
            DataTable dt=ds.Tables["table1"];
            string name=System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString()+DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString()+".csv";
            FileStream fs=new FileStream(name,FileMode.Create,FileAccess.Write);
            StreamWriter sw=new StreamWriter(fs,System.Text.Encoding.GetEncoding("gb2312"));
            sw.WriteLine("自动编号,姓名,年龄");
            foreach(DataRow dr in dt.Rows)
            ...{
                sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
            }
            sw.Close();
            Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
            Response.ContentType = "application/ms-excel";
            Response.WriteFile(name);
            Response.End();
        }

        private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        ...{
            if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
            ...{
                if(Convert.ToInt16(DataBinder.Eval(e.Item.DataItem,"iAge"))<30)e.Item.BackColor=Color.Pink;

            }
        }

        protected string myfunc(object s)
        ...{
            string _s;
            if(s.ToString()=="朱晔")
                _s="<b>"+s.ToString()+"</b>";
            else
                _s=s.ToString();
            return _s;
        }

        protected string myfunc2(object s1,object s2)
        ...{
            return "newpage.aspx?name="+s1.ToString()+"&age="+s2.ToString();
        }

        private void Button4_Click(object sender, System.EventArgs e)
        ...{
            if(Request.Form["rad"] != null)
            ...{
                rd.Value = Request.Form["rad"].ToString();

                this.Label1.Text = "选择的行号：" + Request.Form["rad"].ToString();
            }


        }

        private void Button5_Click(object sender, System.EventArgs e)
        ...{
            this.Label1.Text="";
            foreach(DataGridItem di in this.DataGrid1.Items)
            ...{
                if(((CheckBox)di.FindControl("chkExport")).Checked==true)
                ...{
                    this.Label1.Text+=this.DataGrid1.DataKeys[int.Parse(((HtmlInputHidden)di.FindControl("SelectedID")).Value)]+"<br>";
                }
            }
        }

        private void Button6_Click(object sender, System.EventArgs e)
        ...{
            foreach(DataGridItem di in this.DataGrid1.Items)
            ...{

                ((CheckBox)di.FindControl("chkExport")).Checked=true;

            }
        }

        private void Button7_Click(object sender, System.EventArgs e)
        ...{
            foreach(DataGridItem di in this.DataGrid1.Items)
            ...{

                ((CheckBox)di.FindControl("chkExport")).Checked=false;

            }

        }
    }

不好意思
vs.net吃掉了一些事件注册
补上：
this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);