您现在的位置:首页 >> Asp.NET >> 内容

Asp.net中GridView使用详解

时间:2016-5-16 13:27:02 点击:

  核心提示:lGridView无代码分页排序lGridView选中,编辑,取消,删除lGridView正反双向排序lGridView和下拉菜单DropDownList结合lGridView和CheckBox结合l...

lGridView无代码分页排序

lGridView选中,编辑,取消,删除

lGridView正反双向排序

lGridView和下拉菜单DropDownList结合

lGridView和CheckBox结合

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

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

lGridView实现删除时弹出确认对话框

lGridView实现自动编号

lGridView实现自定义时间货币等字符串格式

lGridView实现用“...”代替超长字符串

lGridView一般换行与强制换行

lGridView显示隐藏某一列

lGridView弹出新页面/弹出新窗口

lGridView固定表头(不用JavaScript只用CSS,2行代码,很好用)

lGridView合并表头多重表头无错完美版(以合并3列3行举例)

lGridView突出显示某一单元格(例如金额低于多少,分数不及格等)

lGridView加入自动求和求平均值小计

lGridView数据导入Excel/Excel数据读入GridView

1.GridView简单代码分页排序:

1.AllowSorting设为True,aspx代码中是AllowSorting="True";

2.默认1页10条,如果要修改每页条数,修改PageSize即可,在aspx代码中是PageSize="12"。

3.默认的是单向排序的,右击GridView弹出“属性”,选择AllowSorting为True即可。

4.添加代码:

?
1
2
3
4
5
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
   {
       GridView1.PageIndex = e.NewPageIndex;
       Bind();
   }

2.GridView选中,编辑,取消,删除:

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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 = "delete from 表 where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand(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=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 * from 表";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "表");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "id" };//主键
        GridView1.DataBind();
        sqlcon.Close();
    }
}

前台主要代码:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" cellpadding="4" forecolor="#333333" gridlines="None" data-cke-pa-onrowdeleting="GridView1_RowDeleting" data-cke-pa-onrowediting="GridView1_RowEditing" data-cke-pa-onrowupdating="GridView1_RowUpdating" data-cke-pa-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">
                        </asp:commandfield></asp:commandfield></asp:commandfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></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">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

 

3.GridView正反双向排序:

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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["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 = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        DataView view = myds.Tables["飞狐工作室"].DefaultView;
        string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
        view.Sort = sort;
        GridView1.DataSource = view;
        GridView1.DataBind();
        sqlcon.Close();
    }
}

前台主要代码:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
<asp:gridview id="GridView1" runat="server" allowsorting="True" autogeneratecolumns="False" cellpadding="3" font-size="9pt" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" data-cke-pa-onsorting="GridView1_Sorting">
                        <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="家庭住址">                              
                        </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></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">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

 

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

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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)
        {
            string sqlstr = "select top 5 * from 飞狐工作室";
            sqlcon = new SqlConnection(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 = "select distinct 员工性别 from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();
        return sqlcom.ExecuteReader();
    }

前台主要代码:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<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="'<%#">' DataValueField="员工性别" DataTextField="员工性别">
                                    </asp:dropdownlist>
                                </itemtemplate>
                            </asp:templatefield>
                            <asp:boundfield datafield="家庭住址" headertext="家庭住址" sortexpression="家庭住址">
                                
                        </asp:boundfield></asp:boundfield></asp:boundfield></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">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

 

5.GridView和CheckBox结合:

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
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
{
    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++)
        {
            CheckBox cbox = (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++)
        {
            CheckBox cbox = (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++)
        {
            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            cbox.Checked = false;
        }
    }
    public void bind()
    {
        string sqlstr = "select top 5 * from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "tb_Member");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }
}
前台主要代码:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<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">
                                </asp:checkbox></itemtemplate>
                            </asp:templatefield>
                             <asp:boundfield datafield="身份证号码" headertext="用户ID" sortexpression="身份证号码">
                            <asp:boundfield datafield="姓名" headertext="用户姓名" sortexpression="姓名">
                            
                            <asp:boundfield datafield="家庭住址" headertext="家庭住址" sortexpression="家庭住址">
                                
                        </asp:boundfield></asp:boundfield></asp:boundfield></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">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>
                     <asp:checkbox id="CheckBox2" runat="server" autopostback="True" font-size="9pt" text="全选" data-cke-pa-oncheckedchanged="CheckBox2_CheckedChanged">
                    <asp:button id="Button1" runat="server" font-size="9pt" text="取消" data-cke-pa-onclick="Button1_Click">
                    <asp:button id="Button2" runat="server" font-size="9pt" text="删除" data-cke-pa-onclick="Button2_Click"></asp:button></asp:button></asp:checkbox>

 

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

做法:

双击GridView的OnRowDataBound事件;

在后台的GridView1_RowDataBound()方法添加代码,最后代码如下所示:

?
1
2
3
4
5
6
7
8
9
10
11
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
    //首先判断是否是数据行
            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");
            }
    }

前台代码:
?
1
2
3
<form id="form1" runat="server">
    <div><asp:gridview allowsorting="True" autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" datakeynames="身份证号码" datasourceid="SqlDataSource1" font-size="12px" id="GridView1" onrowdatabound="GridView1_RowDataBound" runat="server"> <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></asp:boundfield></asp:boundfield></asp:boundfield></columns> <footerstyle backcolor="White" forecolor="#000066"> <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"> </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview> <asp:sqldatasource connectionstring="&lt;%$ ConnectionStrings:北风贸易ConnectionString1 %&gt;" datasourcemode="DataReader" id="SqlDataSource1" runat="server" selectcommand="SELECT top 5 [身份证号码], [姓名], [员工性别], [家庭住址], [邮政编码] FROM [飞狐工作室]"></asp:sqldatasource></div>
</form>

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

做法:和上面的一样就是代码不同

?
1
2
3
4
5
6
7
8
9
10
11
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'");
        }
    }

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

实现方法:

双击GridView的OnRowDataBound事件;

在后台的GridView1_RowDataBound()方法添加代码,最后代码如下所示:

?
1
2
3
4
5
6
7
8
9
10
11
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()方法添加代码,最后代码如下所示:

?
1
2
3
4
5
6
7
8
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowIndex != -1)
    {
        int id = e.Row.RowIndex + 1;
        e.Row.Cells[0].Text = id.ToString();
    }
}

注意这时最好把前台的第一列的表头该为“编号”,因为以前的第一列被“吃掉”了。

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" runat="server" data-cke-pa-onrowcancelingedit="GridView1_RowCancelingEdit" data-cke-pa-onrowdatabound="GridView1_RowDataBound" data-cke-pa-onrowdeleting="GridView1_RowDeleting" data-cke-pa-onrowediting="GridView1_RowEditing" data-cke-pa-onrowupdating="GridView1_RowUpdating">
                        <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">
                        </asp:commandfield></asp:commandfield></asp:commandfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></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">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

 

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

解决方法:

在asp.net 2.0中,如果要在绑定列中显示比如日期格式等,如果用下面的方法是显示不了的

?
1
</asp>

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

1、

?
1
2
3
4
5
<asp :gridview="" id="GridView1" runat="server">
<columns>
<asp :boundfield="" datafield="CreationDate" dataformatstring="{0:M-dd-yyyy}" headertext="CreationDate" htmlencode="false">
</asp></columns>
</asp>

将htmlencode设置为false即可

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

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<asp :gridview="" id="GridView3" runat="server">
<columns>
<asp :templatefield="" headertext="CreationDate">
<edititemtemplate>
<asp :label="" id="Label1" runat="server" text="'<%#">'>
</asp>
</edititemtemplate>
<itemtemplate>
<asp :label="" id="Label1" runat="server" text="’<%#">'>
</asp>
</itemtemplate>
</asp>
</columns>
</asp>

前台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<asp:gridview allowsorting="True" autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" datakeynames="身份证号码" datasourceid="SqlDataSource1" font-size="12px" id="GridView1" runat="server" data-cke-pa-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="起薪">
            </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></columns>
            <footerstyle backcolor="White" forecolor="#000066">
            <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">
        </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>
        <asp:sqldatasource connectionstring="<%$ ConnectionStrings:北风贸易ConnectionString1 %>" datasourcemode="DataReader" id="SqlDataSource1" runat="server" selectcommand="SELECT top 5 [出生日期], [起薪], [身份证号码], [姓名], [家庭住址], [邮政编码] FROM [飞狐工作室]"></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实现用“...”代替超长字符串:

解决方法:数据绑定后过滤每一行即可

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {
            DataRowView mydrv;
            string gIntro;
            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);
            }
        }

调用的方法:

 

?
1
2
3
4
5
6
7
8
9
10
public string SubStr(string sString, int nLeng)
{
    if (sString.Length <= nLeng)
    {
        return sString;
    }
    string sNewStr = sString.Substring(0, nLeng);
    sNewStr = sNewStr + "...";
    return sNewStr;
}

12.GridView一般换行与强制换行:

首先设置gridview里有一列绑定的数据很长,显示的时候在一行里面显示,页面拉得很宽。原因是连续英文段为一个整体导致的,在RowDataBound中添加上了一句e.Row.Cells[2].Style.Add("word-break", "break-all")就可以。如果要给所有的列增加此属性:

?
1
2
3
4
5
6
7
8
9
10
11
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。

13.GridView显示隐藏某一列:

解决方案:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
public void bind()
    {
        string sqlstr = "select top 5 * from 飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
        GridView1.Columns[3].Visible = false;//一开始隐藏
        CheckBox1.Checked = false;//如果不这样后面的代码会把他True
    }

双击CheckBox1,在CheckedChanged方法里写上代码,最后代码如下:

 

?
1
2
3
4
5
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!

后台全部代码如下:

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
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 = new SqlCommand(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=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 = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        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());
    }
}
前台代码:
?
1
2
3
<form id="form1" runat="server">
    <div><asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" onrowcancelingedit="GridView1_RowCancelingEdit" onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" runat="server"> <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"> </asp:commandfield></asp:commandfield></asp:commandfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></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"> </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview> <asp:checkbox autopostback="True" font-size="12px" id="CheckBox1" oncheckedchanged="CheckBox1_CheckedChanged" runat="server" text="显示隐藏家庭住址"></asp:checkbox></div>
</form>

14.GridView弹出新页面:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" runat="server" data-cke-pa-onrowcancelingedit="GridView1_RowCancelingEdit" data-cke-pa-onrowdeleting="GridView1_RowDeleting" data-cke-pa-onrowediting="GridView1_RowEditing" data-cke-pa-onrowupdating="GridView1_RowUpdating">
                       <footerstyle backcolor="White" forecolor="#000066">
                       <columns>
                           <asp:boundfield datafield="身份证号码" headertext="编号" readonly="True">
                           <asp:boundfield datafield="邮政编码" headertext="邮政编码" sortexpression="邮政编码">
                           <asp:boundfield datafield="家庭住址" headertext="家庭住址">
                           <asp:hyperlinkfield datanavigateurlfields="姓名" datanavigateurlformatstring="Default6.aspx?GoodsID={0}" datatextfield="姓名" headertext="姓名" navigateurl="~/Default6.aspx" target="mainframe" text="姓名">
                   </asp:hyperlinkfield>
                           <asp:commandfield headertext="选择" showselectbutton="True">
                           <asp:commandfield headertext="编辑" showeditbutton="True">
                           <asp:commandfield headertext="删除" showdeletebutton="True">
                       </asp:commandfield></asp:commandfield></asp:commandfield></asp:boundfield></asp:boundfield></asp:boundfield></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">
                   </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

DataNavigateUrlFields是链接的字段名,DataNavigateUrlFormatString是路径。

15.GridView固定表头(不用javascript只用CSS!,很好用):

代码:
 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
<style type="text/css">
.Freezing
   {
    
   position:relative ;
   table-layout:fixed;
   top:expression(this.offsetParent.scrollTop); 
   z-index: 10;
   }
.Freezing th{text-overflow:ellipsis;overflow:hidden;white-space: nowrap;padding:2px;}</style>
<form id="form1" runat="server">
    <div id="dvBody" style="overflow-y: scroll; height: 200px;width:300px"><asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" onrowcancelingedit="GridView1_RowCancelingEdit" onrowcreated="GridView1_RowCreated" onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" runat="server"> <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="姓名"> </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></columns> <rowstyle forecolor="#000066"> <selectedrowstyle backcolor="#669999" font-bold="True" forecolor="White"> <pagerstyle backcolor="White" cssclass="ms-formlabel DataGridFixedHeader" forecolor="#000066" horizontalalign="Left"> <headerstyle backcolor="#006699" cssclass="Freezing" font-bold="True" forecolor="White"> </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview></div>
</form>
?
1
 

用法:CSS设如上的样式,HeaderStyle加CssClass="Freezing,套住GridView的Div设置高度宽度

 

16.GridView合并表头多重表头无错完美版(以合并3列3行举例)

后台代码:

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        switch (e.Row.RowType)
        {
            case DataControlRowType.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 = "全部信息";
                //第二行表头
                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 = "联系方式";
                //第三行表头
                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;
        }
    }
}
前台:

 

 

?
1
 

 

17.GridView突出显示某一单元格(例如金额低于多少,分数不及格等)

解决方案:主要是绑定后过滤

?
1
2
3
4
5
6
7
8
9
10
11
GridView1.DataBind();
       for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
       {
           DataRowView mydrv = 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();

全部后台代码:

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
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 = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        GridView1.DataBind();
        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {
            DataRowView mydrv = 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();
    }
}


 

前台代码:

?
1
2
3
<form id="form1" runat="server">
    <div><asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" onrowcancelingedit="GridView1_RowCancelingEdit" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" runat="server"> <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="起薪" dataformatstring="{0:C}" headertext="起薪" htmlencode="false"> <asp:boundfield datafield="家庭住址" headertext="家庭住址"> <asp:boundfield datafield="邮政编码" headertext="邮政编码"> </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:commandfield></columns> <rowstyle forecolor="#000066"> <selectedrowstyle backcolor="#669999" font-bold="True" forecolor="White"> <pagerstyle backcolor="White" cssclass="ms-formlabel DataGridFixedHeader" forecolor="#000066" horizontalalign="Left"> <headerstyle backcolor="#006699" font-bold="True" forecolor="White"> </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview></div>
</form>

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

解决方案

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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();
            
        }
    }

后台全部代码:

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
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 = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        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",否则默认表头为隐藏的!

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" runat="server" showfooter="True" data-cke-pa-onrowcancelingedit="GridView1_RowCancelingEdit" data-cke-pa-onrowdatabound="GridView1_RowDataBound" data-cke-pa-onrowediting="GridView1_RowEditing" data-cke-pa-onrowupdating="GridView1_RowUpdating">
                        <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="起薪">
                           
                        </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:commandfield></columns>
                        <rowstyle forecolor="#000066">
                        <selectedrowstyle backcolor="#669999" font-bold="True" forecolor="White">
                        <pagerstyle backcolor="White" cssclass="ms-formlabel DataGridFixedHeader" forecolor="#000066" horizontalalign="Left">
                        <headerstyle backcolor="#006699" font-bold="True" forecolor="White">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>

 

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

解决方案:

页面增加一个按钮,单击事件添加如下方法:

?
1
 
protected void Button2_Click(object sender, EventArgs e) { //Response.Clear(); //Response.AddHeader("content-disposition", "attachment;filename=MES.xls"); //Response.ContentType = "application/vnd.ms-excel"; //Response.ContentEncoding = System.Text.Encoding.Default; //System.IO.StringWriter sw = new System.IO.StringWriter(); //System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw); //GridView1.RenderControl(hw); //Response.Write(sw.ToString()); //Response.Flush(); //Response.End();//这段会出现乱码,一般使用下面的方法转换一下 Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=Message.xls"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.GridView1.RenderControl(oHtmlTextWriter); Response.Output.Write(oStringWriter.ToString()); Response.Flush(); Response.End(); } public override void VerifyRenderingInServerForm(Control control) { //此段必须要,否则会报错,数据不能导入到EXCEL。 }


?
1
 
//如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有runat=server的窗体标记内

 

?
1
2
3
public override void VerifyRenderingInServerForm(Control control)
{
}

 

还有由于是文件操作所以要引入名称空间IO和Text

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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 = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "飞狐工作室");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }
    protected void Button1_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 = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
    }
    
}
前台:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<asp:gridview autogeneratecolumns="False" backcolor="White" bordercolor="#CCCCCC" borderstyle="None" borderwidth="1px" cellpadding="3" font-size="12px" id="GridView1" runat="server">
                        <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="起薪">
                           
                        </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></columns>
                        <rowstyle forecolor="#000066">
                        <selectedrowstyle backcolor="#669999" font-bold="True" forecolor="White">
                        <pagerstyle backcolor="White" cssclass="ms-formlabel DataGridFixedHeader" forecolor="#000066" horizontalalign="Left">
                        <headerstyle backcolor="#006699" font-bold="True" forecolor="White">
                    </headerstyle></pagerstyle></selectedrowstyle></rowstyle></footerstyle></asp:gridview>
        <asp:button id="Button1" runat="server" text="导出" data-cke-pa-onclick="Button1_Click"></asp:button>
读取Excel数据的代码:这个很简单的
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
private DataSet CreateDataSource()
    {
        string strCon;
        strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("excel.xls") + "; Extended Properties=Excel 8.0;";
        OleDbConnection olecon = new OleDbConnection(strCon);
        OleDbDataAdapter myda = new OleDbDataAdapter("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();
    }

 

作者:不详 来源:网络
共有评论 0相关评论
发表我的评论
  • 大名:
  • 内容:
  • 青春网络编程技术(www.qcfupo.com) © 2020 版权所有 All Rights Reserved.
  • Powered by qcfupo! V3.0sp1
  • 百度友情链接: 百家乐[www.chinawestnews.net/aomenbaijiale/] 赌博网[www.chinawestnews.net/amdbwz/] 海立方[www.bjl.gov.cn/bjgylc/] 娱乐城[www.gtxrmzf.gov.cn/mapai/] 娱乐城[www.hfsf.gov.cn/yfgj/] 威尼斯人[www.hllinkou.gov.cn/baijile/] 澳门威尼斯[www.jjwgj.gov.cn/wnsr/] 888真人[www.lagm.gov.cn/888zhenren/] 百乐坊[www.laoling.gov.cn/blfylc/] 现金网[www.longyu.gov.cn/xjw/] 百家乐[www.chinawestnews.net/ambjl/] 新葡京娱乐场[www.sjzedu.gov.cn/jsylc/] 时时彩[www.snjw.gov.cn/ssc/] 赌博[www.chinawestnews.net/aomendubo/]