GridView绝技实现自动编号、自定义时间货币等字符串格式、用“...”代替超长字符串、一般换行与强制换行、显示隐藏某一列

9.GridView实现自动编号： 效果图：

实现方法：

双击GridView的OnRowDataBound事件；

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

 1 protected   void  GridView1_RowDataBound( object  sender, GridViewRowEventArgs e)

  2 ... {

 3    //如果是绑定数据行 //清清月儿http://blog.csdn.net/21aspnet 

 4    if (e.Row.RowType == DataControlRowType.DataRow)

 5    ...{

 6        ////鼠标经过时，行背景色变 

 7        //e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");

 8        ////鼠标移出时，行背景色变 

 9        //e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");

10        ////当有编辑列时，避免出错，要加的RowState判断 

11        //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

12        //{

13        //    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除："" + e.Row.Cells[1].Text + ""吗?')");

14        //}

15    }

16    if (e.Row.RowIndex != -1)

17    ...{

18        int id = e.Row.RowIndex + 1;

19        e.Row.Cells[0].Text = id.ToString();

20    }

21}

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

  1 < asp:GridView ID = " GridView1 "  runat = " server "  AutoGenerateColumns = " False "  CellPadding = " 3 "  OnRowDeleting = " GridView1_RowDeleting "  OnRowEditing = " GridView1_RowEditing "

  2     OnRowUpdating = " GridView1_RowUpdating "  OnRowCancelingEdit = " GridView1_RowCancelingEdit "  BackColor = " White "  BorderColor = " #CCCCCC "  BorderStyle = " None "  BorderWidth = " 1px "  Font - Size = " 12px "  OnRowDataBound = " GridView1_RowDataBound " >

  3      < FooterStyle BackColor = " White "  ForeColor = " #000066 "   />

  4      < Columns >

  5          < asp:BoundField DataField = " 身份证号码 "  HeaderText = " 编号 "  ReadOnly = " True "   />

  6          < asp:BoundField DataField = " 姓名 "  HeaderText = " 用户姓名 "   />

  7          < asp:BoundField DataField = " 员工性别 "  HeaderText = " 性别 "   />

  8          < asp:BoundField DataField = " 家庭住址 "  HeaderText = " 家庭住址 "   />

  9          < asp:CommandField HeaderText = " 选择 "  ShowSelectButton = " True "   />

10          < asp:CommandField HeaderText = " 编辑 "  ShowEditButton = " True "   />

11          < asp:CommandField HeaderText = " 删除 "  ShowDeleteButton = " True "   />

12      </ Columns >

13      < RowStyle ForeColor = " #000066 "   />

14      < SelectedRowStyle BackColor = " #669999 "  Font - Bold = " True "  ForeColor = " White "   />

15      < PagerStyle BackColor = " White "  ForeColor = " #000066 "  HorizontalAlign = " Left "   />

16      < HeaderStyle BackColor = " #006699 "  Font - Bold = " True "  ForeColor = " White "   />

17 </ asp:GridView >

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

图1-未格式化前  

图2-格式化后   解决方法：

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

1   < asp :BoundField DataField = " CreationDate "  

2  DataFormatString = " {0:M-dd-yyyy} "  

3  HeaderText = " CreationDate "   />

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

1 < asp:GridView ID = " GridView1 "  runat = " server " >

2      < columns >

3          < asp :BoundField DataField = " CreationDate "

4         DataFormatString = " {0:M-dd-yyyy} "  

5         HtmlEncode = " false "

6         HeaderText = " CreationDate "   />

7      </ columns >

8 </ asp:GridView >

</ asp:GridView > 将htmlencode设置为false即可 另外的解决方法为，使用模版列

  1 < asp:GridView ID = " GridView3 "  runat = " server "   >

  2   < columns >

  3    < asp:TemplateField HeaderText = " CreationDate "   >

  4     < itemtemplate >

  5      < asp:Label ID = " Label1 "  runat = " server "  Text = ' <%# Bind("CreationDate", "{0:M-dd-yyyy}") %> '   />

  6     </ itemtemplate >

  7     < edititemtemplate >

  8      < asp:Label ID = " Label1 "  runat = " server "  Text = ' <%# Eval("CreationDate", "{0:M-dd-yyyy}") %> '   />

  9     </ edititemtemplate >

10    </ asp:TemplateField >

11   </ columns >

12 </ asp:GridView >

前台代码：

  1 < asp:GridView ID = " GridView1 "  runat = " server "  AutoGenerateColumns = " False "  DataKeyNames = " 身份证号码 "

  2     DataSourceID = " SqlDataSource1 "  AllowSorting = " True "  BackColor = " White "  BorderColor = " #CCCCCC "  BorderStyle = " None "  BorderWidth = " 1px "  CellPadding = " 3 "  Font - Size = " 12px "  OnRowDataBound = " GridView1_RowDataBound " >

  3      < Columns >

  4          < asp:BoundField DataField = " 身份证号码 "  HeaderText = " 身份证号码 "  ReadOnly = " True "  SortExpression = " 身份证号码 "   />

  5          < asp:BoundField DataField = " 姓名 "  HeaderText = " 姓名 "  SortExpression = " 姓名 "   />

  6          < asp:BoundField DataField = " 邮政编码 "  HeaderText = " 邮政编码 "  SortExpression = " 邮政编码 "   />

  7          < asp:BoundField DataField = " 出生日期 "  HeaderText = " 出生日期 "  SortExpression = " 出生日期 "   />

  8          < asp:BoundField DataField = " 起薪 "  HeaderText = " 起薪 "  SortExpression = " 起薪 "   />

  9      </ Columns >

10      < FooterStyle BackColor = " White "  ForeColor = " #000066 "   />

11      < RowStyle ForeColor = " #000066 "   />

12      < SelectedRowStyle BackColor = " #669999 "  Font - Bold = " True "  ForeColor = " White "   />

13      < PagerStyle BackColor = " White "  ForeColor = " #000066 "  HorizontalAlign = " Left "   />

14      < HeaderStyle BackColor = " #006699 "  Font - Bold = " True "  ForeColor = " White "   />

15 </ asp:GridView >

16 < asp:SqlDataSource ID = " SqlDataSource1 "  runat = " server "  ConnectionString = " <%$ ConnectionStrings:北风贸易ConnectionString1 %> "

17     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实现用“...”代替超长字符串： 效果图：

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

 1 for  ( int  i  =   0 ; i  <=  GridView1.Rows.Count  -   1 ; i ++ )

  2 ... {

 3    DataRowView mydrv;

 4    string gIntro;

 5    if (GridView1.PageIndex == 0)

 6    ...{

 7        mydrv = myds.Tables["飞狐工作室"].DefaultView[i];//表名

 8        gIntro = Convert.ToString(mydrv["家庭住址"]);//所要处理的字段

 9        GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

10    }

11    else

12    ...{

13        mydrv = myds.Tables["飞狐工作室"].DefaultView[i + (5 * GridView1.PageIndex)];

14        gIntro = Convert.ToString(mydrv["家庭住址"]);

15        GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

16    }

17}

调用的方法：

 1 public   string  SubStr( string  sString,  int  nLeng)

  2 ... {

 3    if (sString.Length <= nLeng)

 4    ...{

 5        return sString;

 6    }

 7    string sNewStr = sString.Substring(0, nLeng);

 8    sNewStr = sNewStr + "";

 9    return sNewStr;

10}

后台全部代码：

  1 using  System;

  2 using  System.Data;

  3 using  System.Configuration;

  4 using  System.Web;

  5 using  System.Web.Security;

  6 using  System.Web.UI;

  7 using  System.Web.UI.WebControls;

  8 using  System.Web.UI.WebControls.WebParts;

  9 using  System.Web.UI.HtmlControls;

 10 using  System.Data.SqlClient;

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

  12 ... {

 13    SqlConnection sqlcon;

 14    SqlCommand sqlcom;

 15    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";

 16    protected void Page_Load(object sender, EventArgs e)

 17    ...{

 18        if (!IsPostBack)

 19        ...{

 20            ViewState["SortOrder"] = "身份证号码";

 21            ViewState["OrderDire"] = "ASC";

 22            bind();

 23        }

 24    }

 25    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

 26    ...{

 27        GridView1.EditIndex = e.NewEditIndex;

 28        bind();

 29    }

 30    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

 31    ...{

 32        string sqlstr = "delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

 33        sqlcon = new SqlConnection(strCon);

 34        sqlcom = new SqlCommand(sqlstr,sqlcon);

 35        sqlcon.Open();

 36        sqlcom.ExecuteNonQuery();

 37        sqlcon.Close();

 38        bind();

 39    }

 40    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

 41    ...{

 42        sqlcon = new SqlConnection(strCon);

 43        string sqlstr = "update 飞狐工作室 set 姓名='"

 44            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',家庭住址='"

 45            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where 身份证号码='" 

 46            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

 47        sqlcom=new SqlCommand(sqlstr,sqlcon);

 48        sqlcon.Open();

 49        sqlcom.ExecuteNonQuery();

 50        sqlcon.Close();

 51        GridView1.EditIndex = -1;

 52        bind();

 53    }

 54    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

 55    ...{

 56        GridView1.EditIndex = -1;

 57        bind();

 58    }

 59    public void bind()

 60    ...{

 61        string sqlstr = "select top 5 * from 飞狐工作室";

 62        sqlcon = new SqlConnection(strCon);

 63        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

 64        DataSet myds = new DataSet();

 65        sqlcon.Open();

 66        myda.Fill(myds, "飞狐工作室");

 67        GridView1.DataSource = myds;

 68        GridView1.DataKeyNames = new string[] ...{ "身份证号码" };

 69        GridView1.DataBind();

 70        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

 71        ...{

 72            DataRowView mydrv;

 73            string gIntro;

 74            if (GridView1.PageIndex == 0)

 75            ...{

 76                mydrv = myds.Tables["飞狐工作室"].DefaultView[i];

 77                gIntro = Convert.ToString(mydrv["家庭住址"]);

 78                GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

 79            }

 80            else

 81            ...{

 82                mydrv = myds.Tables["飞狐工作室"].DefaultView[i + (5 * GridView1.PageIndex)];

 83                gIntro = Convert.ToString(mydrv["家庭住址"]);

 84                GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

 85            }

 86        }

 87        

 88        sqlcon.Close();

 89    }

 90    public string SubStr(string sString, int nLeng)

 91    ...{

 92        if (sString.Length <= nLeng)

 93        ...{

 94            return sString;

 95        }

 96        string sNewStr = sString.Substring(0, nLeng);

 97        sNewStr = sNewStr + "";

 98        return sNewStr;

 99    }

100    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

101    ...{

102        //如果是绑定数据行 

103        if (e.Row.RowType == DataControlRowType.DataRow)

104        ...{

105            ////鼠标经过时，行背景色变 

106            //e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");

107            ////鼠标移出时，行背景色变 

108            //e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");

109            ////当有编辑列时，避免出错，要加的RowState判断 

110            //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

111            //{

112            //    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除："" + e.Row.Cells[1].Text + ""吗?')");

113            //}

114        }

115        if (e.Row.RowIndex != -1)

116        ...{

117            int id = e.Row.RowIndex + 1;

118            e.Row.Cells[0].Text = id.ToString();

119        }

120    }

121}

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

效果图：

  首先设置<asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  ItemStyle-Width="100" />

gridview里有一列绑定的数据很长，显示的时候在一行里面显示，页面拉得很宽。

原因是连续英文段为一个整体导致的，在RowDataBound中添加上了一句e.Row.Cells[2].Style.Add("word-break", "break-all")就可以。 如果要给所有的列增加此属性：

1 protected   void  Page_Load( object  sender, EventArgs e)

  2 ... {

 3    //正常换行

 4    GridView1.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");

 5    //下面这行是自动换行

 6    GridView1.Attributes.Add("style", "word-break:break-all;word-wrap:break-word");

 7    if (!IsPostBack)

 8    ...{

 9         bind();//调用数据绑定即可

10    }

11}

总之：善用CSS的word-break:break-all;word-wrap:break-word属性即可，这个属性是通用的对于顽固的南换行问题都可以解决，不局限于GridView。

 13.GridView显示隐藏某一列：

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

图1-开始  

图2-点击显示的CheckBox后

解决方案：

 1 public   void  bind()

  2 ... {

 3    string sqlstr = "select top 5 * from 飞狐工作室";

 4    sqlcon = new SqlConnection(strCon);

 5    SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

 6    DataSet myds = new DataSet();

 7    sqlcon.Open();

 8    myda.Fill(myds, "飞狐工作室");

 9    GridView1.DataSource = myds;

10    GridView1.DataKeyNames = new string[] ...{ "身份证号码" };

11    GridView1.DataBind();

12    sqlcon.Close();

13    GridView1.Columns[3].Visible = false;//一开始隐藏

14    CheckBox1.Checked = false;//如果不这样后面的代码会把他True

15}

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

1 protected   void  CheckBox1_CheckedChanged( object  sender, EventArgs e)

2 ... {

3         GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;

4         Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());

5}

注意：CheckBox1的AutoPostBack要True！ 后台全部代码如下：

 1 using  System;

 2 using  System.Data;

 3 using  System.Configuration;

 4 using  System.Web;

 5 using  System.Web.Security;

 6 using  System.Web.UI;

 7 using  System.Web.UI.WebControls;

 8 using  System.Web.UI.WebControls.WebParts;

 9 using  System.Web.UI.HtmlControls;

10 using  System.Data.SqlClient;

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

12 ... {

13    SqlConnection sqlcon;

14    SqlCommand sqlcom; 

15    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";

16    protected void Page_Load(object sender, EventArgs e)

17    ...{

18        if (!IsPostBack)

19        ...{

20            ViewState["SortOrder"] = "身份证号码";

21            ViewState["OrderDire"] = "ASC";

22            bind();

23                   }

24    }

25    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

26    ...{

27        GridView1.EditIndex = e.NewEditIndex;

28        bind();

29    }

30    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

31    ...{

32        string sqlstr = "delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

33        sqlcon = new SqlConnection(strCon);

34        sqlcom = new SqlCommand(sqlstr,sqlcon);

35        sqlcon.Open();

36        sqlcom.ExecuteNonQuery();

37        sqlcon.Close();

38        bind();

39    }

40    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

41    ...{

42        sqlcon = new SqlConnection(strCon);

43        string sqlstr = "update 飞狐工作室 set 姓名='"

44            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',家庭住址='"

45            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where 身份证号码='" 

46            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

47        sqlcom=new SqlCommand(sqlstr,sqlcon);

48        sqlcon.Open();

49        sqlcom.ExecuteNonQuery();

50        sqlcon.Close();

51        GridView1.EditIndex = -1;

52        bind();

53    }

54    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

55    ...{

56        GridView1.EditIndex = -1;

57        bind();

58    }

59    public void bind()

60    ...{

61        string sqlstr = "select top 5 * from 飞狐工作室";

62        sqlcon = new SqlConnection(strCon);

63        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

64        DataSet myds = new DataSet();

65        sqlcon.Open();

66        myda.Fill(myds, "飞狐工作室");

67        GridView1.DataSource = myds;

68        GridView1.DataKeyNames = new string[] ...{ "身份证号码" };

69        GridView1.DataBind();

70        sqlcon.Close();

71        GridView1.Columns[3].Visible = false;

72        CheckBox1.Checked = false;

73    }

74    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)

75    ...{

76         GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;

77         Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());

78    }

79}

前台代码：

1 <! DOCTYPE html PUBLIC  " -//W3C//DTD XHTML 1.0 Transitional//EN "   " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd " >

  2 < html xmlns = " http://www.w3.org/1999/xhtml "   >

  3 < head runat = " server " >

  4      < title > GridView显示隐藏列 清清月儿http: // blog.csdn.net/21aspnet </title>

  5 </ head >

  6 < body style = " font-size=12px " >

  7      < form id = " form1 "  runat = " server " >

  8      < div >

  9                     < asp:GridView ID = " GridView1 "  runat = " server "  AutoGenerateColumns = " False "  CellPadding = " 3 "  OnRowDeleting = " GridView1_RowDeleting "  OnRowEditing = " GridView1_RowEditing "

10                         OnRowUpdating = " GridView1_RowUpdating "  OnRowCancelingEdit = " GridView1_RowCancelingEdit "  BackColor = " White "  BorderColor = " #CCCCCC "  BorderStyle = " None "  BorderWidth = " 1px "  Font - Size = " 12px "    >

11                          < FooterStyle BackColor = " White "  ForeColor = " #000066 "   />

12                          < Columns >

13                              < asp:BoundField DataField = " 身份证号码 "  HeaderText = " 编号 "  ReadOnly = " True "   />

14                              < asp:BoundField DataField = " 姓名 "  HeaderText = " 用户姓名 "   />

15                              < asp:BoundField DataField = " 邮政编码 "  HeaderText = " 邮政编码 "  SortExpression = " 邮政编码 "   />

16                              < asp:BoundField DataField = " 家庭住址 "  HeaderText = " 家庭住址 "    />

17                              < asp:CommandField HeaderText = " 选择 "  ShowSelectButton = " True "   />

18                              < asp:CommandField HeaderText = " 编辑 "  ShowEditButton = " True "   />

19                              < asp:CommandField HeaderText = " 删除 "  ShowDeleteButton = " True "   />

20                          </ Columns >

21                          < RowStyle ForeColor = " #000066 "   />

22                          < SelectedRowStyle BackColor = " #669999 "  Font - Bold = " True "  ForeColor = " White "   />

23                          < PagerStyle BackColor = " White "  ForeColor = " #000066 "  HorizontalAlign = " Left "   />

24                          < HeaderStyle BackColor = " #006699 "  Font - Bold = " True "  ForeColor = " White "   />

25                      </ asp:GridView >

26          < asp:CheckBox ID = " CheckBox1 "  runat = " server "  AutoPostBack = " True "  Font - Size = " 12px "

27             OnCheckedChanged = " CheckBox1_CheckedChanged "  Text = " 显示隐藏家庭住址 "   /></ div >

28      </ form >

29 </ body >

30 </ html >