ASP.NET开发之GridView使用方法

最新推荐文章于 2025-03-11 12:16:34 发布
最新推荐文章于 2025-03-11 12:16:34 发布
阅读量846 收藏
点赞数
分类专栏： ASP.NET开发 c#

史上最全GridView使用方法

1.GridView无代码分页排序
1.AllowSorting设为True，aspx代码中是AllowSorting="True"；
2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。
3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

2.GridView选中，编辑，取消，删除：

效果图：

后台代码：
你可以使用sqlhelper,本文没用。代码如下：
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.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{


    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }

//删除
    protected void GridView1_RowDeleting(object sender,GridViewDeleteEventArgs e)
    {
        string sqlstr = "deletefrom 表 where id='" +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcon = new SqlConnection(strCon);
        sqlcom = newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        bind();
    }

//更新
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 表 set 字段1='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',字段2='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+ "',字段3='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where id='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }

//取消
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }

//绑定
    public void bind()
    {
        string sqlstr = "select * from 表";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "表");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "id" };//主键
        GridView1.DataBind();
        sqlcon.Close();
    }
}

前台主要代码：
                           ... ...
<asp:GridView ID="GridView1" runat="server"AutoGenerateColumns="False" CellPadding="4"
                       ForeColor="#333333" GridLines="None"OnRowDeleting="GridView1_RowDeleting"OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit">
                       <FooterStyle BackColor="#990000" Font-Bold="True"ForeColor="White" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
                           <asp:BoundField DataField="员工性别" HeaderText="性别" />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
                           <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>


3.GridView正反双向排序：（用到数据库视图DATAVIEW及GRIDVIEW的VIEWSTAT类）
效果图：点姓名各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 Default3 : System.Web.UI.Page
{

    SqlConnection sqlcon;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

//viewstate:服务器控件的视图状态为其所有属性值的累计。为了在 HTTP请求间保留这些值，ASP.NET服//务器控件使用该属性（它是StateBag 类的实例）来存储属性值。在处理后续请求时，该值随//即作为变量传递给 HTML隐藏输入元素。

           ViewState["SortOrder"] = "身份证号码";
           ViewState["OrderDire"] = "ASC";
            bind();
        }
    }
    protected void GridView1_Sorting(object sender,GridViewSortEventArgs e)
    {
        string sPage = e.SortExpression;
        if(ViewState["SortOrder"].ToString() == sPage)
        {
            if(ViewState["OrderDire"].ToString() == "Desc")
               ViewState["OrderDire"] = "ASC";
            else
               ViewState["OrderDire"] = "Desc";
        }
        else
        {
           ViewState["SortOrder"] = e.SortExpression;
        }
        bind();
    }

public void bind()
    {
       
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");

//DATAVIEW类实现了视图功能，可以在视图中对得出的表进行编辑

//DATATABLE类实现了表功能，可以在表里构造我们想要的数据
        DataView view = myds.Tables["飞狐工作室"].DefaultView;
        string sort =(string)ViewState["SortOrder"] + " " +(string)ViewState["OrderDire"];
        view.Sort = sort;

//数据库中的数据可以经过视图组织之后再承现给GV
        GridView1.DataSource = view;
        GridView1.DataBind();
        sqlcon.Close();
    }
}

前台主要代码：
<asp:GridViewID="GridView1" runat="server" AllowSorting="True"AutoGenerateColumns="False"
                       CellPadding="3" Font-Size="9pt"OnSorting="GridView1_Sorting" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None"BorderWidth="1px">
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                            <asp:BoundField DataField="身份证号码" HeaderText="用户ID" SortExpression="身份证号码" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" SortExpression="姓名"/>
                           <asp:BoundField DataField="员工性别" HeaderText="性别" SortExpression="员工性别"/>
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>
                               
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>

 

4.GridView和下拉菜单DropDownList结合：

效果图：

后台代码：
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 Default4 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        DropDownList ddl;
        if (!IsPostBack)
        {
            stringsqlstr = "select top 5 * from 飞狐工作室";
            sqlcon = newSqlConnection(strCon);
           SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
            DataSet myds= new DataSet();
           sqlcon.Open();
           myda.Fill(myds, "飞狐工作室");
           GridView1.DataSource = myds;
           GridView1.DataBind();
            for (int i =0; i <= GridView1.Rows.Count - 1; i++)
            {
               DataRowView mydrv = myds.Tables["飞狐工作室"].DefaultView[i];
               if (Convert.ToString(mydrv["员工性别"]).Trim() == "True")
               {
                   ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
                   ddl.SelectedIndex = 0;
               }
               if (Convert.ToString(mydrv["员工性别"]).Trim() == "False")
               {
                   ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
                   ddl.SelectedIndex = 1;
               }
            }
           sqlcon.Close();
        }
    }
    public SqlDataReader ddlbind()
    {
        string sqlstr = "selectdistinct 员工性别 from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlCommand sqlcom = newSqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        return sqlcom.ExecuteReader();
    }

前台主要代码：
<asp:GridView ID="GridView1" runat="server"AllowSorting="True" AutoGenerateColumns="False"
                       CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px">
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                            <asp:BoundField DataField="身份证号码" HeaderText="用户ID" SortExpression="身份证号码" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" SortExpression="姓名"/>
                           <asp:TemplateField HeaderText="员工性别">
                               <ItemTemplate>
                                   <asp:DropDownList ID="DropDownList1" runat="server"DataSource='<%# ddlbind()%>' DataValueField="员工性别"DataTextField="员工性别">
                                   </asp:DropDownList>
                               </ItemTemplate>
                           </asp:TemplateField>
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>
                               
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>

5.GridView和CheckBox结合：

效果图：

后台代码：

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.Data.SqlClient;

public partial class Default5 : System.Web.UI.Page
{
//清清月儿http://blog.youkuaiyun.com/21aspnet
    SqlConnection sqlcon;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    protected void CheckBox2_CheckedChanged(object sender,EventArgs e)
    {
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBoxcbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (CheckBox2.Checked== true)
            {
               cbox.Checked = true;
            }
            else
            {
               cbox.Checked = false;
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        SqlCommand sqlcom;
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBoxcbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if(cbox.Checked == true)
            {

               string sqlstr = "delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[i].Value + "'";
               sqlcom = new SqlCommand(sqlstr, sqlcon);
               sqlcon.Open();
               sqlcom.ExecuteNonQuery();
               sqlcon.Close();
            }
        }
        bind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        CheckBox2.Checked = false;
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBoxcbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            cbox.Checked= false;
        }
    }
    public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds,"tb_Member");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }
}

前台主要代码：

<asp:GridView ID="GridView1"runat="server" AllowSorting="True"AutoGenerateColumns="False"
                       CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px">
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                            <asp:TemplateField>
                               <ItemTemplate>
                                   <asp:CheckBox ID="CheckBox1" runat="server" />
                               </ItemTemplate>
                           </asp:TemplateField>
                            <asp:BoundField DataField="身份证号码" HeaderText="用户ID" SortExpression="身份证号码" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" SortExpression="姓名"/>
                           
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>
                               
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
                    <asp:CheckBox ID="CheckBox2" runat="server"AutoPostBack="True" Font-Size="9pt" OnCheckedChanged="CheckBox2_CheckedChanged"
                       Text="全选" />
                   <asp:Button ID="Button1" runat="server"Font-Size="9pt" Text="取消" OnClick="Button1_Click" />
                   <asp:Button ID="Button2" runat="server"Font-Size="9pt" Text="删除" OnClick="Button2_Click" />

6.鼠标移到GridView某一行时改变该行的背景色方法一：

效果图：

做法：
双击GridView的OnRowDataBound事件；实现思路为在ROW属性中增加鼠标经过和鼠标释放的属性
在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        int i;
        //执行循环，保证每条数据都可以更新
        for (i = 0; i <GridView1.Rows.Count; i++)
        {
            //首先判断是否是数据行
            if(e.Row.RowType == DataControlRowType.DataRow)
            {
               //当鼠标停留时更改背景色
               e.Row.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
               //当鼠标移开时还原背景色
               e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
            }
        }

    }

前台代码：
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>实现鼠标划过改变GridView的行背景色 清清月儿http://blog.youkuaiyun.com/21aspnet </title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridViewID="GridView1" runat="server"AutoGenerateColumns="False" DataKeyNames="身份证号码"
           DataSourceID="SqlDataSource1" AllowSorting="True"BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px"CellPadding="3" Font-Size="12px"OnRowDataBound="GridView1_RowDataBound">
           <Columns>
               <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" ReadOnly="True" SortExpression="身份证号码" />
               <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
               <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址" />
               <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
           </Columns>
           <FooterStyle BackColor="White" ForeColor="#000066" />
            <RowStyleForeColor="#000066" />
           <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
           <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
           <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
        </asp:GridView>
        <asp:SqlDataSourceID="SqlDataSource1" runat="server"ConnectionString="<%$ ConnectionStrings:北风贸易ConnectionString1 %>"
           SelectCommand="SELECT top 5 [身份证号码], [姓名], [员工性别], [家庭住址], [邮政编码] FROM [飞狐工作室]"DataSourceMode="DataReader"></asp:SqlDataSource>
   
    </div>
    </form>
</body>
</html>

7.鼠标移到GridView某一行时改变该行的背景色方法二：

效果图：

做法：和上面的一样就是代码不同
protected voidGridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //int i;
        执行循环，保证每条数据都可以更新
        //for (i = 0; i <GridView1.Rows.Count; i++)
        //{
        //    //首先判断是否是数据行
        //    if(e.Row.RowType == DataControlRowType.DataRow)
        //    {
       //        //当鼠标停留时更改背景色
       //       e.Row.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
       //        //当鼠标移开时还原背景色
       //       e.Row.Attributes.Add("onmouseout","this.style.backgroundColor=c");
        //    }
        //}
        //如果是绑定数据行
        if (e.Row.RowType ==DataControlRowType.DataRow)
        {
            //鼠标经过时，行背景色变
           e.Row.Attributes.Add("onmouseover","this.style.backgroundColor='#E6F5FA'");
            //鼠标移出时，行背景色变
            e.Row.Attributes.Add("onmouseout","this.style.backgroundColor='#FFFFFF'");
        }

    }

8.GridView实现删除时弹出确认对话框：

效果图：

实现方法：
双击GridView的OnRowDataBound事件；
在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：

    protected void GridView1_RowDataBound(object sender,GridViewRowEventArgs e)
    {
        //如果是绑定数据行
        if (e.Row.RowType ==DataControlRowType.DataRow)
        {
             if(e.Row.RowState == DataControlRowState.Normal || e.Row.RowState ==DataControlRowState.Alternate)
            {
               ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick","javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')");
           }
        }

    }

9.GridView实现自动编号：

效果图：

实现方法：
双击GridView的OnRowDataBound事件；
在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：
    protected void GridView1_RowDataBound(object sender,GridViewRowEventArgs e)
    {
        //如果是绑定数据行 //清清月儿http://blog.youkuaiyun.com/21aspnet 
        if (e.Row.RowType ==DataControlRowType.DataRow)
        {
            鼠标经过时，行背景色变
           //e.Row.Attributes.Add("onmouseover","this.style.backgroundColor='#E6F5FA'");
            鼠标移出时，行背景色变
           //e.Row.Attributes.Add("onmouseout","this.style.backgroundColor='#FFFFFF'");

           当有编辑列时，避免出错，要加的RowState判断
            //if(e.Row.RowState == DataControlRowState.Normal || e.Row.RowState ==DataControlRowState.Alternate)
            //{
           //   ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick","javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')");
            //}

        }
        if (e.Row.RowIndex!= -1)
        {
            int id =e.Row.RowIndex + 1;
           e.Row.Cells[0].Text = id.ToString();
        }

    }

 

注意这时最好把前台的第一列的表头该为“编号”，因为以前的第一列被“吃掉”了。
<asp:GridView ID="GridView1" runat="server"AutoGenerateColumns="False" CellPadding="3"OnRowDeleting="GridView1_RowDeleting"OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px"Font-Size="12px" OnRowDataBound="GridView1_RowDataBound">
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
                           <asp:BoundField DataField="员工性别" HeaderText="性别" />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
                           <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>

10.GridView实现自定义时间货币等字符串格式：

效果图：
图1-未格式化前

图2-格式化后

解决方法：
在asp.net2.0中，如果要在绑定列中显示比如日期格式等，如果用下面的方法是显示不了的

<asp :BoundField DataField="CreationDate"
DataFormatString="{0:M-dd-yyyy}"
HeaderText="CreationDate" />

主要是由于htmlencode属性默认设置为true,已防止XSS攻击，安全起见而用的，所以，可以有以下两种方法解决

1、

<asp :GridView ID="GridView1"runat="server">
<columns>
<asp :BoundField DataField="CreationDate"
DataFormatString="{0:M-dd-yyyy}"
HtmlEncode="false"
HeaderText="CreationDate" />
</columns>
</asp>

将htmlencode设置为false即可

另外的解决方法为，使用模版列

<asp :GridView ID="GridView3"runat="server" >
<columns>
<asp :TemplateField HeaderText="CreationDate" >
<edititemtemplate>
<asp :Label ID="Label1" runat="server"
Text='<%# Eval("CreationDate", "{0:M-dd-yyyy}")%>'>
</asp>
</edititemtemplate>
<itemtemplate>
<asp :Label ID="Label1" runat="server"
Text=’<%# Bind("CreationDate", "{0:M-dd-yyyy}")%>'>
</asp>
</itemtemplate>
</asp>
</columns>
</asp>

前台代码：
<asp:GridViewID="GridView1" runat="server"AutoGenerateColumns="False" DataKeyNames="身份证号码"
           DataSourceID="SqlDataSource1" AllowSorting="True"BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px" CellPadding="3"Font-Size="12px"OnRowDataBound="GridView1_RowDataBound">
           <Columns>
               <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" ReadOnly="True" SortExpression="身份证号码" />
               <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
               <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
               <asp:BoundField DataField="出生日期" HeaderText="出生日期" SortExpression="出生日期" />
               <asp:BoundField DataField="起薪" HeaderText="起薪" SortExpression="起薪" />
           </Columns>
           <FooterStyle BackColor="White" ForeColor="#000066" />
            <RowStyleForeColor="#000066" />
           <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
           <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
           <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
        </asp:GridView>
        <asp:SqlDataSourceID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:北风贸易ConnectionString1 %>"
           SelectCommand="SELECT top 5 [出生日期], [起薪], [身份证号码], [姓名], [家庭住址], [邮政编码] FROM [飞狐工作室]"DataSourceMode="DataReader"></asp:SqlDataSource>

附录-常用格式化公式：
{0:C} 货币；
{0:D4}由0填充的4个字符宽的字段中显示整数；
{0:000.0}四舍五入小数点保留第几位有效数字；
{0:N2}小数点保留2位有效数字；{0:N2}%  小数点保留2位有效数字加百分号；
{0:D}长日期；{0:d}短日期；{0:yy-MM-dd}  例如07-3-25；；{0:yyyy-MM-dd} 例如2007-3-25

 11.GridView实现用“...”代替超长字符串：

效果图：

解决方法：数据绑定后过滤每一行即可
for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            DataRowViewmydrv;
            stringgIntro;
            if(GridView1.PageIndex == 0)
            {
               mydrv = myds.Tables["飞狐工作室"].DefaultView[i];//表名
               gIntro = Convert.ToString(mydrv["家庭住址"]);//所要处理的字段
               GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);
            }
            else
            {
               mydrv = myds.Tables["飞狐工作室"].DefaultView[i + (5 * GridView1.PageIndex)];
               gIntro = Convert.ToString(mydrv["家庭住址"]);
               GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);
            }
        } 

调用的方法：

    public string SubStr(string sString,int nLeng)
    {
        if (sString.Length <= nLeng)
        {
            returnsString;
        }
        string sNewStr =sString.Substring(0, nLeng);
        sNewStr = sNewStr + "...";
        return sNewStr;
    }

后台全部代码：
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.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           ViewState["SortOrder"] = "身份证号码";
           ViewState["OrderDire"] = "ASC";
            bind();
        }
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowDeleting(object sender,GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from 飞狐工作室 where 身份证号码='" +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcon = new SqlConnection(strCon);
        sqlcom = newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        bind();
    }
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 飞狐工作室 set 姓名='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',家庭住址='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where 身份证号码='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            DataRowViewmydrv;
            stringgIntro;
            if(GridView1.PageIndex == 0)
            {
               mydrv = myds.Tables["飞狐工作室"].DefaultView[i];
               gIntro = Convert.ToString(mydrv["家庭住址"]);
               GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);
            }
            else
            {
               mydrv = myds.Tables["飞狐工作室"].DefaultView[i + (5 * GridView1.PageIndex)];
               gIntro = Convert.ToString(mydrv["家庭住址"]);
               GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);
            }
        }
       
        sqlcon.Close();
    }
    public string SubStr(string sString, int nLeng)
    {
        if (sString.Length <= nLeng)
        {
            returnsString;
        }
        string sNewStr =sString.Substring(0, nLeng);
        sNewStr = sNewStr + "...";
        return sNewStr;
    }
    protected void GridView1_RowDataBound(object sender,GridViewRowEventArgs e)
    {
        //如果是绑定数据行 
        if (e.Row.RowType ==DataControlRowType.DataRow)
        {
            鼠标经过时，行背景色变
           //e.Row.Attributes.Add("onmouseover","this.style.backgroundColor='#E6F5FA'");
            鼠标移出时，行背景色变
           //e.Row.Attributes.Add("onmouseout","this.style.backgroundColor='#FFFFFF'");

           当有编辑列时，避免出错，要加的RowState判断
            //if(e.Row.RowState == DataControlRowState.Normal || e.Row.RowState ==DataControlRowState.Alternate)
            //{
           //    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick","javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')");
            //}

        }
        if (e.Row.RowIndex != -1)
        {
            int id =e.Row.RowIndex + 1;
           e.Row.Cells[0].Text = id.ToString();
        }

    }
}

 11.GridView一般换行与强制换行：

效果图：

首先设置<asp:BoundFieldDataField="家庭住址" HeaderText="家庭住址"  ItemStyle-Width="100" />
gridview里有一列绑定的数据很长，显示的时候在一行里面显示，页面拉得很宽。
原因是连续英文段为一个整体导致的，在RowDataBound中添加上了一句e.Row.Cells[2].Style.Add("word-break","break-all")就可以。

如果要给所有的列增加此属性：
 protected void Page_Load(object sender, EventArgs e)
    {
        //正常换行
       GridView1.Attributes.Add("style","word-break:keep-all;word-wrap:normal");
        //下面这行是自动换行
       GridView1.Attributes.Add("style","word-break:break-all;word-wrap:break-word");
        if (!IsPostBack)
        {
             bind();//调用数据绑定即可
        }
    }
总之：善用CSS的word-break::break-all;word-wrap:break-word属性即可，这个属性是通用的对于顽固的南换行问题都可以解决，不局限于GridView。

 12.GridView显示隐藏某一列：
本方案为月儿独创，不同于网上其他方式，我觉得用一个CheckBox更人性化，这样可以隐藏不必要的列，让用户自己选择需要出现的列，在处理多列时这是一个很好的解决方案！

效果图：
图1-开始

图2-点击显示的CheckBox后

解决方案：
public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
        GridView1.Columns[3].Visible =false;//一开始隐藏
       CheckBox1.Checked = false;//如果不这样后面的代码会把他True
    }

双击CheckBox1，在CheckedChanged方法里写上代码，最后代码如下：
protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
         GridView1.Columns[3].Visible=!GridView1.Columns[3].Visible;
         Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());
    }

注意：CheckBox1的AutoPostBack要True！

后台全部代码如下：

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.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom; 
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           ViewState["SortOrder"] = "身份证号码";
           ViewState["OrderDire"] = "ASC";
            bind();
                   }
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowDeleting(object sender,GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from 飞狐工作室 where 身份证号码='" +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcon = new SqlConnection(strCon);
        sqlcom = newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        bind();
    }
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 飞狐工作室 set 姓名='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',家庭住址='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where 身份证号码='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
        GridView1.Columns[3].Visible =false;
        CheckBox1.Checked = false;
    }
    protected void CheckBox1_CheckedChanged(object sender,EventArgs e)
    {
         GridView1.Columns[3].Visible=!GridView1.Columns[3].Visible;
         Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());
    }
}

前台代码：
<!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 runat="server">
    <title>GridView显示隐藏列 清清月儿http://blog.youkuaiyun.com/21aspnet </title>
</head>
<body style="font-size=12px">
    <form id="form1" runat="server">
    <div>
                  <asp:GridView ID="GridView1" runat="server"AutoGenerateColumns="False" CellPadding="3" OnRowDeleting="GridView1_RowDeleting"OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None"BorderWidth="1px" Font-Size="12px"  >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
        <asp:CheckBoxID="CheckBox1" runat="server" AutoPostBack="True"Font-Size="12px"
           OnCheckedChanged="CheckBox1_CheckedChanged" Text="显示隐藏家庭住址"/></div>
    </form>
</body>
</html>

 13.GridView弹出新页面/弹出制定大小位置新窗口：

效果图：

方案一：简单的方法，新窗口不固定大小
 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"CellPadding="3" OnRowDeleting="GridView1_RowDeleting"OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None"BorderWidth="1px" Font-Size="12px"  >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:HyperLinkField HeaderText="姓名" Text="姓名"DataNavigateUrlFields="姓名"DataNavigateUrlFormatString="Default6.aspx?GoodsID={0}"Target="mainframe" NavigateUrl="~/Default6.aspx"DataTextField="姓名" >
                   </asp:HyperLinkField>
                           <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
DataNavigateUrlFields是链接的字段名，DataNavigateUrlFormatString是路径。

方案二：精确控制弹出窗口大小位置
<asp:HyperLinkColumn DataNavigateUrlField="EmployeeID"DataNavigateUrlFormatString="javascript:varwin=window.open('detail.aspx?ID={0}',null,'width=300,height=200');window.Close();"
       DataTextField="LastName"HeaderText="LastName"></asp:HyperLinkColumn>

使用的是结合javascript的window.open方法，关于window.open的参数网上有很多帖子，本站也有许多参考
弹出窗口大全 http://blog.youkuaiyun.com/21aspnet/archive/2004/10/25/150231.aspx  即可！

  14.GridView固定表头(不用javascript只用CSS!，很好用)：

效果图：

代码：
<!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 runat="server">
    <title>GridView固定表头 清清月儿http://blog.youkuaiyun.com/21aspnet </title>
       <style>
.Freezing
   {
   
  position:relative ;
   table-layout:fixed;
   top:expression(this.offsetParent.scrollTop);  
   z-index: 10;
   }

.Freezingth{text-overflow:ellipsis;overflow:hidden;white-space: nowrap;padding:2px;}
</style>
</head>
<body style="font-size=12px">
    <form id="form1" runat="server">
    <div style="overflow-y: scroll; height:200px;width:300px" id="dvBody">
                  <asp:GridView ID="GridView1"runat="server"   AutoGenerateColumns="False" CellPadding="3"OnRowDeleting="GridView1_RowDeleting"OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"Font-Size="12px" OnRowCreated="GridView1_RowCreated" >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                           
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left"  CssClass="ms-formlabelDataGridFixedHeader"/>
                        <HeaderStyle BackColor="#006699"Font-Bold="True" ForeColor="White"CssClass="Freezing"/>
                   </asp:GridView>
        </div>

    </form>
</body>
</html>

用法：CSS设如上的样式，HeaderStyle加CssClass="Freezing，套住GridView的Div设置高度宽度 <div style="overflow-y: scroll;height: 200px;width:200px" >

 

设置流动条的样式

当在页面中显示大量信息时，为了不使整个页面太长，常常将这些内容放在一个层中，然后再为这个层加上滚动条。这样即显示了全部的信息，又使得页面更加美观。下面是一个简单的带滚动条的层实现(其中涉及的一些CSS样式最好是能够参考一下CSS手册，可以使得整个层更加漂亮)。

 

Html代码

  1. <html>  
  2.     <head>  
  3.     <title>Div Scroll</title>  
  4.        
  5.     <style type="text/css">  
  6.     .scroll {   
  7.         width: 50%;                                     /*宽度*/   
  8.         height: 200px;                                  /*高度*/   
  9.         color: ;                                        /*颜色*/   
  10.         font-family: ;                                  /*字体*/   
  11.         padding-left: 10px;                          /*层内左边距*/   
  12.         padding-right: 10px;                       /*层内右边距*/   
  13.         padding-top: 10px;                      /*层内上边距*/   
  14.         padding-bottom: 10px;                  /*层内下边距*/   
  15.  overflow-x: scroll;         /*横向滚动条(scroll:始终出现;auto:必要时出                                             现;具体参考CSS文档)*/   
  16.    overflow-y: scroll;                             /*竖向滚动条*/   
  17.            
  18.    scrollbar-face-color: #D4D4D4;                  /*滚动条滑块颜色*/   
  19.     scrollbar-hightlight-color: #ffffff; /*滚动条3D界面的亮边颜色*/   
  20.      scrollbar-shadow-color: #919192;  /*滚动条3D界面的暗边颜色*/   
  21.      scrollbar-3dlight-color: #ffffff;        /*滚动条亮边框颜色*/   
  22.       scrollbar-arrow-color: #919192;                 /*箭头颜色*/   
  23.      scrollbar-track-color: #ffffff;            /*滚动条底色*/   
  24.     scrollbar-darkshadow-color: #ffffff;     /*滚动条暗边框颜色*/   
  25.     }   
  26.     </style>  
  27.        
  28.     </head>  
  29.        
  30.     <body>  
  31.     <div align="center">  
  32.         <div class="scroll">  
  33.             <!--在此添加想要显示的内容 -->  
  34.         </div>  
  35.     </div>  
  36.        
  37.     </body>  
  38. </html>  

 

 

15.GridView合并表头多重表头无错完美版（以合并3列3行举例）

效果图：


后台代码：
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.Data.SqlClient;
using System.Drawing;
public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
           
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgse)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 飞狐工作室 set 姓名='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',家庭住址='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where 身份证号码='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=newSqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    public void bind()
    {
        string sqlstr = "select top 10* from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[]{ "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }

//这里就是解决方案
   protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        switch (e.Row.RowType)
        {
            caseDataControlRowType.Header:
               //第一行表头
               TableCellCollection tcHeader = e.Row.Cells;
               tcHeader.Clear();
               tcHeader.Add(new TableHeaderCell());
               tcHeader[0].Attributes.Add("rowspan", "3"); //跨Row
               tcHeader[0].Attributes.Add("bgcolor", "white");
               tcHeader[0].Text = "";
               tcHeader.Add(new TableHeaderCell());
               //tcHeader[1].Attributes.Add("bgcolor", "Red");
               tcHeader[1].Attributes.Add("colspan", "6"); //跨Column
               tcHeader[1].Text = "全部信息</th></tr><tr>";

               //第二行表头
               tcHeader.Add(new TableHeaderCell());
               tcHeader[2].Attributes.Add("bgcolor", "DarkSeaGreen");
               tcHeader[2].Text = "身份证号码";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[3].Attributes.Add("bgcolor", "LightSteelBlue");
               tcHeader[3].Attributes.Add("colspan", "2");
               tcHeader[3].Text = "基本信息";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[4].Attributes.Add("bgcolor", "DarkSeaGreen");
               tcHeader[4].Text = "福利";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[5].Attributes.Add("bgcolor", "LightSteelBlue");
               tcHeader[5].Attributes.Add("colspan", "2");
               tcHeader[5].Text = "联系方式</th></tr><tr>";

               //第三行表头
               tcHeader.Add(new TableHeaderCell());
               tcHeader[6].Attributes.Add("bgcolor", "Khaki");
               tcHeader[6].Text = "身份证号码";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[7].Attributes.Add("bgcolor", "Khaki");
               tcHeader[7].Text = "姓名";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[8].Attributes.Add("bgcolor", "Khaki");
               tcHeader[8].Text = "出生日期";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[9].Attributes.Add("bgcolor", "Khaki");
               tcHeader[9].Text = "薪水";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[10].Attributes.Add("bgcolor", "Khaki");
               tcHeader[10].Text = "家庭住址";
               tcHeader.Add(new TableHeaderCell());
               tcHeader[11].Attributes.Add("bgcolor", "Khaki");
               tcHeader[11].Text = "邮政编码";
               break;
        }
    }
}

前台：
<!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 runat="server">
    <title>GridView合并多重表头表头 清清月儿http://blog.youkuaiyun.com/21aspnet </title>
</head>
<body >
    <form id="form1" runat="server">
    <div  >
                  <asp:GridView ID="GridView1"runat="server"   AutoGenerateColumns="False" CellPadding="3" OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None"BorderWidth="1px" Font-Size="12px"OnRowCreated="GridView1_RowCreated"  >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                           <asp:BoundField DataField="出生日期" HeaderText="邮政编码"  />
                            <asp:BoundField DataField="起薪" HeaderText="起薪"  />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
                          
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left"  CssClass="ms-formlabelDataGridFixedHeader"/>
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
        </div>

    </form>
</body>
</html>

16.GridView突出显示某一单元格（例如金额低于多少，分数不及格等）

效果图：

解决方案：主要是绑定后过滤
 GridView1.DataBind();
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            DataRowViewmydrv = myds.Tables["飞狐工作室"].DefaultView[i];
            string score= Convert.ToString(mydrv["起薪"]);
            if(Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等
           {
               GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
            }
        }
        sqlcon.Close();

全部后台代码：

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

public partial class Default7 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();

        }
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 飞狐工作室 set 姓名='"
            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',家庭住址='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where 身份证号码='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom = new SqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    public void bind()
    {
        string sqlstr = "select top 10* from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        for (int i = 0; i <=GridView1.Rows.Count - 1; i++)
        {
            DataRowViewmydrv = myds.Tables["飞狐工作室"].DefaultView[i];
            string score= Convert.ToString(mydrv["起薪"]);
            if(Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等

            {
               GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
           }
        }
        sqlcon.Close();
    }
}

前台代码：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0Transitional//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>GridView突出显示某一单元格 清清月儿http://blog.youkuaiyun.com/21aspnet </title>
</head>
<body >
    <form id="form1" runat="server">
    <div  >
                  <asp:GridView ID="GridView1"runat="server"    AutoGenerateColumns="False"CellPadding="3"  OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"BorderColor="#CCCCCC" BorderStyle="None"BorderWidth="1px" Font-Size="12px"  >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                           <asp:BoundField DataField="出生日期" HeaderText="邮政编码"  />
                            <asp:BoundField DataField="起薪" HeaderText="起薪"  DataFormatString="{0:C}"HtmlEncode="false"/>
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
                          
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left"  CssClass="ms-formlabelDataGridFixedHeader"/>
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
        </div>

    </form>
</body>
</html>

 17.GridView加入自动求和求平均值小计

效果图：
解决方案：    
private double sum = 0;//取指定列的数据和，你要根据具体情况对待可能你要处理的是int
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       
        if (e.Row.RowIndex >= 0)
        {
            sum +=Convert.ToDouble(e.Row.Cells[6].Text);
        }
       else  if (e.Row.RowType== DataControlRowType.Footer)
        {
           e.Row.Cells[5].Text = "总薪水为：";
           e.Row.Cells[6].Text = sum.ToString();
           e.Row.Cells[3].Text = "平均薪水为：";
           e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();
           
        }
    }

后台全部代码：
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.Data.SqlClient;
using System.Drawing;

public partial class Default7 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();

        }
    }
    protected void GridView1_RowEditing(object sender,GridViewEditEventArgs e)
    {
        GridView1.EditIndex =e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        string sqlstr = "update 飞狐工作室 set 姓名='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+ "',家庭住址='"
            +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+ "' where 身份证号码='"
            +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom = new SqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }
    private double sum = 0;//取指定列的数据和
    protected void GridView1_RowDataBound(object sender,GridViewRowEventArgs e)
    {
       
        if (e.Row.RowIndex >= 0)
        {
            sum +=Convert.ToDouble(e.Row.Cells[6].Text);
        }
        else if (e.Row.RowType ==DataControlRowType.Footer)
        {
           e.Row.Cells[5].Text = "总薪水为：";
           e.Row.Cells[6].Text = sum.ToString();
           e.Row.Cells[3].Text = "平均薪水为：";
           e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();
           
        }
    }
}
前台：唯一的花头就是设置ShowFooter="True"，否则默认表头为隐藏的！
<asp:GridViewID="GridView1" runat="server"   AutoGenerateColumns="False" CellPadding="3" OnRowEditing="GridView1_RowEditing"
                       OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px"Font-Size="12px" OnRowDataBound="GridView1_RowDataBound"ShowFooter="True"  >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                           <asp:BoundField DataField="出生日期" HeaderText="邮政编码"  />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
                           <asp:BoundField DataField="起薪" HeaderText="起薪"  />
                          
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left"  CssClass="ms-formlabelDataGridFixedHeader"/>
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>

 

 18.GridView数据导入Excel/Excel数据读入GridView

效果图：

解决方案：
页面增加一个按钮，单击事件添加如下方法：
protected voidButton1_Click(object sender, EventArgs e)
    {
       Export("application/ms-excel", "学生成绩报表.xls");
    }

    private void Export(string FileType,string FileName)
    {
        Response.Charset ="GB2312";
        Response.ContentEncoding =System.Text.Encoding.UTF7;
       Response.AppendHeader("Content-Disposition","attachment;filename=" + HttpUtility.UrlEncode(FileName,Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = newStringWriter();
        HtmlTextWriter hw = newHtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }
//如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server的窗体标记内
    public override voidVerifyRenderingInServerForm(Control control)
    {
    }
还有由于是文件操作所以要引入名称空间IO和Text

后台代码：
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.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Text;
public partial class Default7 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();

        }
    }
   
    public void bind()
    {
        string sqlstr = "select top 5 *from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = newSqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = newstring[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }

    protected void Button1_Click(objectsender, EventArgs e)
    {
       Export("application/ms-excel", "学生成绩报表.xls");
    }

    private void Export(string FileType,string FileName)
    {
        Response.Charset ="GB2312";
        Response.ContentEncoding =System.Text.Encoding.UTF7;
       Response.AppendHeader("Content-Disposition","attachment;filename=" + HttpUtility.UrlEncode(FileName,Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = newHtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Controlcontrol)
    {
    }
   
}

前台：
<asp:GridView ID="GridView1"runat="server"   AutoGenerateColumns="False" CellPadding="3" 
                        BackColor="White" BorderColor="#CCCCCC"BorderStyle="None" BorderWidth="1px"Font-Size="12px"   >
                       <FooterStyle BackColor="White" ForeColor="#000066" />
                       <Columns>
                           <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                           <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                           <asp:BoundField DataField="出生日期" HeaderText="邮政编码"  />
                           <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                           <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
                           <asp:BoundField DataField="起薪" HeaderText="起薪"  />
                          
                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left"  CssClass="ms-formlabelDataGridFixedHeader"/>
                       <HeaderStyle BackColor="#006699" Font-Bold="True"ForeColor="White" />
                   </asp:GridView>
        <asp:ButtonID="Button1" runat="server"OnClick="Button1_Click" Text="导出" />

读取Excel数据的代码：这个很简单的
private DataSet CreateDataSource()
    {
        string strCon;
        strCon ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +Server.MapPath("excel.xls") + "; Extended Properties=Excel8.0;";
        OleDbConnection olecon = newOleDbConnection(strCon);
        OleDbDataAdapter myda = newOleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);
        DataSet myds = new DataSet();
        myda.Fill(myds);
        return myds;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GridView1.DataSource =CreateDataSource();
        GridView1.DataBind();
    } 

在对GridView编辑的时候实现自动计算（用Ajax比较好，但是比较麻烦，这里只要把其中一个TextBox设置成AutoPostBack即可。）

protected void Page_Load(object sender, EventArgs e)
    {
        int editIndex = YEARPLAN.EditIndex;
        if (editIndex != -1)
        {
            TextBoxSalesQty =
               ((TextBox)YEARPLAN.Rows[editIndex].FindControl("TextBox4"));
            TextBoxUprice =
               ((TextBox)YEARPLAN.Rows[editIndex].FindControl("TextBox7"));
            TextBoxAmount =
               ((TextBox)YEARPLAN.Rows[editIndex].FindControl("TextBox8"));

           try
            {
               Decimal decQty = 0;
               Decimal decUpr = 0;

               if (SalesQty.Text.Trim() != "" && Uprice.Text.Trim() !="")
               {
                   decQty = Decimal.Parse(SalesQty.Text.Trim());
                   decUpr = Decimal.Parse(Uprice.Text.Trim());
                   Amount.Text = Convert.ToString(decQty * decUpr);
               }
            }
            catch(Exception)
            {
               Date.MessageBox(this, "程序出错，请于开发人员联系！");
            }
        }

}

 

实现类似winform的点击行选中功能

    protected voidgvwRole_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType ==DataControlRowType.DataRow)
        {
           e.Row.Attributes.Add("onmouseover","if(this!=prev){c=this.style.backgroundColor;this.style.backgroundColor='#D8F3C6'}");//当鼠标停留时更改背景色
           e.Row.Attributes.Add("onmouseout","if(this!=prev){this.style.backgroundColor=c}");//当鼠标移开时还原背景色
           e.Row.Attributes["style"] = "Cursor:hand";//设置悬浮鼠标指针形状为"小手"

           DataRowView row = (DataRowView)e.Row.DataItem;
            string id =row["roleId"].ToString();
           e.Row.Attributes.Add("onclick", "select_" + id +".checked=true;selectx(this)");
        }
    }

在gridview中加入一列隐藏的单选控件。

<input id='<%#"select_" +DataBinder.Eval(Container, "dataitem.roleId")%>'name='radioRole' type="radio"value="<%#DataBinder.Eval(Container,"dataitem.roleId")%>" style="display:none;" />

 js:

 function selectx(row)   /*改变选中行的颜色还原为选中行的颜色*/
        {
           if(prev!=null)
            {
               prev.style.backgroundColor='#E4F7D8';
            }
           row.style.backgroundColor='#8EC26F';
            prev=row;
           
        }

GridView在编辑的时候控制编辑框的列宽。

protected void gvWKPL_RowEditing(objectsender, GridViewEditEventArgs e)

{

foreach (TableCell varcellingv.Rows[gv.EditIndex].Cells)

{

try

{

TextBox curText = (TextBox)varcell.Controls[0];

curText.Width = Unit.Pixel(50);

//对于不知道名字的就要用这种写法

//对于模版列也可以用、、//((TextBox)gv.Rows[editIndex].FindControl("TextBox4"));

}

catch

{

continue;

}

}

 

//再不行了就在这里搞

protected void gvWKPL_DataBound(objectsender, EventArgs e)

    {

        if(gvWKPL.EditIndex != -1)

        {

            foreach(TableCell varcellingvWKPL.Rows[gvWKPL.EditIndex].Cells)

            {

                try

                {

                    TextBox curText = (TextBox)varcell.Controls[0];

                    curText.Width = Unit.Pixel(50);

                }

                catch

                {

                    continue;

                }

 

            }

        }

       

    }

 

---------------给Gridview加入Tooltip的功能

在DataRowBound事件中写入

if(e.Row.RowType == DataControlRowType.Header)
{
   e.Row.Cells[1].Attributes.Add("Title", "testtest");
}

 

Asp.Net 控件 GridView
u010940770的专栏
11-14 1967
c#实现简单地界面的增删查改（用的mysql数据库），带你了解GridView控件
ASP.NET GridView入门
了凡
06-01 790
ASP.NET GridView入门基础知识格式化GridView格式化字段通过DataFormatString属性可以保证日期、货币或者其它数值以正确的格式显示 例如，设置如下的格式显示日期：<asp:BoundField DataField="BirthDate" HeaderText="Bith Date" DataFormatString="{0:MM/dd/yyyy}" />显示效果为：
dridview技术
费剑的博客
03-25 733
支持的字段类别GridView控件支持下列字段控件: BoundField控件：以字符串的方式显示该字段数据。 ButtonField控件：显示一个用户定义的按钮。 CheckField控件：字段值如果是布尔值，显示复选框（checkbox）。 CommandField控件：自动产生一个命令按钮，如编辑（Edit）、更新（Update），以及取
深入掌握ASP.NET GridView的经典操作与应用
最新发布
weixin_31176789的博客
03-11 867
本文还有配套的精品资源，点击获取 简介：GridView是ASP.NET Web Forms中的关键控件，用于展示和操作数据表，包括数据绑定、自定义列配置、支持排序和分页、编辑更新、插入和删除记录、自定义样式、模板字段、事件驱动编程、性能优化、自定义操作按钮、验证控件集成、异步更新以及国际化本地化。本主题深入探讨GridView的经典操作，旨在提升开发者在Web Forms...
Asp.net中GridView使用详解(很全，很经典)
weixin_30881367的博客
02-09 284
http://blog.csdn.net/hello_world_wusu/article/details/4052844 Asp.net中GridView使用详解 效果图参考：http://hi.baidu.com/hello%5Fworld%5Fws/album/asp%2Enet中以gv开头的图片 lGridView无代码分页排序 lGr...
ASP.NET中GridView使用详解
09-07
自己在刚刚开始学C#是收集的一些关于GridView的使用方法
ASP.NET——GridView
LiSiYaYa的博客
06-02 897
ASP.NET 工作半年之久，平时都是面向优快云编程，决定写一个大全，方便自行查询资料。话不多说，直接开搞！ 虽然本人大学时期学习MVC较多，不过目前工作接触的系统多为WebFrom，因此初期对于控件的用法，讲解等比较多。 ...
asp.net实现固定GridView标题栏的方法(冻结列功能)
10-22
1. GridView控件的基本使用方法。 ***中如何在服务器端设置GridView的列。 3. 使用前端JavaScript技术来控制GridView的显示效果。 4. 使用第三方JavaScript库来实现更为复杂的表格功能。 首先，我们来看***中...
ASP.NET中使用GridView实现分级显示的代码
01-01
在实际项目开发中，我找到了一种利用GridView实现分级效果的方法，最终效果图如下： 以下是实现代码： Aspx页面 代码如下: <asp ID=”GridView1″ SkinID=”GridView” runat=”server” AutoGenerateColumns=”...
ASP.NET 开发，GridView嵌套
12-23
ASP.NET 开发，GridView嵌套上课代码，简单的描述了两个GridView的嵌套使用。
如何动态地向ASP.NET中的Gridview添加行？
04-04
在ASP.NET中，GridView控件是一种非常常用的展示数据的组件，它允许用户以表格的形式查看、编辑和操作数据。在实际开发中，我们有时需要在运行时动态地向GridView添加行，以满足某些动态交互的需求。这篇教程将深入...
ASP.NET中为GridView添加删除提示框的方法
01-20
在ASP.NET开发中，GridView控件是用于展示数据表格的常用组件。为了提供更好的用户体验，尤其是在涉及删除操作时，通常需要添加删除提示框以避免意外的、不可逆的数据丢失。本文将详细介绍如何在ASP.NET的GridView中...
Asp.net中GridView使用详解(引)
热门推荐
语帆的专栏
01-31 3万+
GridView无代码分页排序 GridView选中，编辑，取消，删除 GridView正反双向排序 GridView和下拉菜单DropDownList结合 GridView和CheckBox结合 鼠标移到GridView某一行时改变该行的背景色方法一 鼠标移到GridView某一行时改变该行的背景色方法二 GridView实现删除时弹出确认对话框 GridView实现自动编号
ASP.NET GridView详解（简单易懂）
ganyonjie的博客
12-15 3445
1. 界面如下： 数据列的新增。 2.代码： using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; namespace HospitalManagementSystem.Patien
ASP.NET WEB 数据控件GridView
ba_wang_mao的专栏
06-23 1473
https://www.cnblogs.com/HuiTai/p/huitai_Net9.html https://www.cnblogs.com/HuiTai/p/huitai_Net9.html
asp.net Gridview用法大全 绝对原创
xxlovemf的专栏
05-05 1263
获取行列及单元格的数据集合: xx.Columns; xx.Rows; xx.Rows[行索引].Cells[列索引]; 获取行列数: xx.Rows.Count; xx.Columns.Count; 增删查改行和列: xx.SelectRow(索引); xx.UpdateRow(索引,true); xx.DeleteRow(索引); 获取页眉和脚注行： xx.Header
asp.net gridview 详解
水滴石穿！学习小积累！
10-31 123
  &lt;!--end: blogStats --&gt;&lt;!--end: navigator 博客导航栏 --&gt;&lt;!--done--&gt; Asp.net中GridView使用详解 GridView无代码分页排序GridView选中，编辑，取消，删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和...
ASP.NET的Gridview控件简单使用（分页、序号、选框、全选）（附源码）
My设计Road
12-21 4279
这次我们实现的功能是：全选，单选，可以提取一行的数据，分页，结合下拉列表筛选数据，显示序号。1.全选 //全选 protected void CheckBox2_CheckedChanged1(object sender, EventArgs e) { for (int i = 0; i <= GridView1.Rows.Count - 1; i++
ASP.Net GridView专题
满天星的博客
06-09 662
ASP.Net GridView 基础ASP.Net GridView 基础 属性和事件ASP.Net GridView 基础 绑定字段ASP.Net GridView 基础 Template模板
ASP.NET 3.5 MVC GridView控件自定义开发教程
在《ASP.NET 3.5 MVC体验与实战》一书中，作者龚赤兵探讨了在ASP.NET 3.5 MVC框架下的GridView控件开发，这是第四章的主要内容。GridView是用于显示和操作数据的重要组件，尤其是在Web应用中处理大量数据展示和交互...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值