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

解决方案:主要是绑定后过滤
1GridView1.DataBind();
2for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

3...{
4 DataRowView mydrv = myds.Tables["飞狐工作室"].DefaultView[i];
5 string score = Convert.ToString(mydrv["起薪"]);
6 if (Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等

7 ...{
8 GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
9 }
10}
11sqlcon.Close();
全部后台代码:
1using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11using System.Drawing;
12public partial class Default7 : System.Web.UI.Page

13...{
14 SqlConnection sqlcon;
15 SqlCommand sqlcom;
16 string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
17 protected void Page_Load(object sender, EventArgs e)

18 ...{
19 if (!IsPostBack)

20 ...{
21 bind();
22 }
23 }
24 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

25 ...{
26 GridView1.EditIndex = e.NewEditIndex;
27 bind();
28 }
29 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

30 ...{
31 sqlcon = new SqlConnection(strCon);
32 string sqlstr = "update 飞狐工作室 set 姓名='"
33 + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',家庭住址='"
34 + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where 身份证号码='"
35 + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
36 sqlcom = new SqlCommand(sqlstr, sqlcon);
37 sqlcon.Open();
38 sqlcom.ExecuteNonQuery();
39 sqlcon.Close();
40 GridView1.EditIndex = -1;
41 bind();
42 }
43 protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

44 ...{
45 GridView1.EditIndex = -1;
46 bind();
47 }
48 public void bind()

49 ...{
50 string sqlstr = "select top 10 * from 飞狐工作室";
51 sqlcon = new SqlConnection(strCon);
52 SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
53 DataSet myds = new DataSet();
54 sqlcon.Open();
55 myda.Fill(myds, "飞狐工作室");
56 GridView1.DataSource = myds;

57 GridView1.DataKeyNames = new string[] ...{ "身份证号码" };
58 GridView1.DataBind();
59 for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

60 ...{
61 DataRowView mydrv = myds.Tables["飞狐工作室"].DefaultView[i];
62 string score = Convert.ToString(mydrv["起薪"]);
63 if (Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等

64 ...{
65 GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
66 }
67 }
68 sqlcon.Close();
69 }
70}
前台代码:






























































































































17.GridView加入自动求和求平均值小计
效果图:

解决方案:






























































































































18.GridView数据导入Excel/Excel数据读入GridView
效果图:

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

























后台代码:
1using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11using System.Drawing;
12using System.IO;
13using System.Text;
14public partial class Default7 : System.Web.UI.Page

15...{
16 SqlConnection sqlcon;
17 SqlCommand sqlcom;
18 string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
19 protected void Page_Load(object sender, EventArgs e)

20 ...{
21 if (!IsPostBack)

22 ...{
23 bind();
24 }
25 }
26
27 public void bind()

28 ...{
29 string sqlstr = "select top 5 * from 飞狐工作室";
30 sqlcon = new SqlConnection(strCon);
31 SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
32 DataSet myds = new DataSet();
33 sqlcon.Open();
34 myda.Fill(myds, "飞狐工作室");
35 GridView1.DataSource = myds;

36 GridView1.DataKeyNames = new string[] ...{ "身份证号码" };
37 GridView1.DataBind();
38 sqlcon.Close();
39 }
40 protected void Button1_Click(object sender, EventArgs e)

41 ...{
42 Export("application/ms-excel", "学生成绩报表.xls");
43 }
44 private void Export(string FileType, string FileName)

45 ...{
46 Response.Charset = "GB2312";
47 Response.ContentEncoding = System.Text.Encoding.UTF7;
48 Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
49 Response.ContentType = FileType;
50 this.EnableViewState = false;
51 StringWriter tw = new StringWriter();
52 HtmlTextWriter hw = new HtmlTextWriter(tw);
53 GridView1.RenderControl(hw);
54 Response.Write(tw.ToString());
55 Response.End();
56 }
57 public override void VerifyRenderingInServerForm(Control control)

58 ...{
59 }
60}
前台:






































































































