GridView使用大全（下）

最新推荐文章于 2024-04-22 15:28:53 发布

linxi27

最新推荐文章于 2024-04-22 15:28:53 发布

阅读量662

点赞数

文章标签： textbox 工作 database javascript asp button

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

效果图：

首先设置 < asp:BoundField DataField = " 家庭住址 " 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。

13 .GridView显示隐藏某一列：

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

效果图：

图1 - 开始

图2 - 点击显示的CheckBox后

解决方案：

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方法里写上代码，最后代码如下：

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 = 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());

}

前台代码：

<! 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.csdn.net/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:CheckBox ID = " 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 "

< 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.163.com/fulei.20030727@126/blog/static/30066221200822864930786/ 即可！

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.csdn.net/21aspnet </title>

< style >

.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 >

</ 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 "

< 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-formlabel DataGridFixedHeader " />

< 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 " >

16 .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, 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();

sqlcon.Close();

}

//这里就是解决方案

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)

{

switch (e.Row.RowType)

{

case DataControlRowType.Header:

//第一行表头

TableCellCollection tcHeader = e.Row.Cells;

tcHeader.Clear();