传导性听力损失手术:GridView 使用方法总结(二)
来源:百度文库 编辑:中财网 时间:2024/05/15 00:50:23
11.GridView实现用“...”代替超长字符串: 代码 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 );
}
}
代码 public string SubStr(string sString, int nLeng)
{
if (sString.Length <= nLeng)
{
return sString;
}
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;
publicpartial 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();
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 );
}
}
sqlcon.Close();
}
public string SubStr(string sString, int nLeng)
{
if (sString.Length <= nLeng)
{
return sString;
}
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();
}
}
}
代码 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();//调用数据绑定即可
}
}
代码 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
}
代码 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());
}
代码 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;
publicpartial 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());
}
}
代码 html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
xmlns="http://www.w3.org/1999/xhtml">
runat="server">
GridView显示隐藏列 清清月儿http://blog.csdn.net/21aspnet
s="font-size=12px">
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" >
BackColor="White" ForeColor="#000066" />
DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
DataField="姓名" HeaderText="用户姓名" />
DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
DataField="家庭住址" HeaderText="家庭住址" />
HeaderText="选择" ShowSelectButton="True" />
HeaderText="编辑" ShowEditButton="True" />
HeaderText="删除" ShowDeleteButton="True" />
ForeColor="#000066" />
BackColor="#669999" Font-Bold="True" ForeColor="White" />
BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
BackColor="#006699" Font-Bold="True" ForeColor="White" />
ID="CheckBox1" runat="server" AutoPostBack="True" Font-Size="12px"
OnCheckedChanged ="CheckBox1_CheckedChanged" Text="显示隐藏家庭住址" />
代码 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" >
BackColor="White" ForeColor="#000066" />
DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
DataField="家庭住址" HeaderText="家庭住址" />
HeaderText="姓名" Text="姓名" DataNavigateUrlFields="姓名" DataNavigateUrlFormatString="Default6.aspx?GoodsID={0}" Target="mainframe" NavigateUrl="~/Default6.aspx" DataTextField="姓名" >
HeaderText="选择" ShowSelectButton="True" />
HeaderText="编辑" ShowEditButton="True" />
HeaderText="删除" ShowDeleteButton="True" />
ForeColor="#000066" />
BackColor="#669999" Font-Bold="True" ForeColor="White" />
BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
BackColor="#006699" Font-Bold="True" ForeColor="White" />
代码 DataNavigateUrlField="EmployeeID" DataNavigateUrlFormatString="javascript:varwin=window.open('detail.aspx?ID={0}',null,'width=300,height=200');window.Close();"
DataTextField ="LastName" HeaderText="LastName"> 弹出窗口大全 http://blog.csdn.net/21aspnet/archive/2004/10/25/150231.aspx 代码 html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
xmlns="http://www.w3.org/1999/xhtml">
runat="server">
GridView固定表头 清清月儿http://blog.csdn.net/21aspnet
s="font-size=12px">
解决方法:数据绑定后过滤每一行即可
调用的方法:
后台全部代码:
using
using
using
using
using
using
using
using
using
public
{
}
11.GridView一般换行与强制换行:
如果要给所有的列增加此属性:
总之:善用CSS的word-break:break-all;word-wrap:break-word属性即可,这个属性是通用的对于顽固的南换行问题都可以解决,不局限于GridView。
12.GridView显示隐藏某一列:
本方案为月儿独创,不同于网上其他方式,我觉得用一个CheckBox更人性化,这样可以隐藏不必要的列,让用户自己选择需要出现的列,在处理多列时这是一个很好的解决方案!
效果图:
图1-开始
图2-点击显示的CheckBox后
解决方案
双击CheckBox1,在CheckedChanged方法里写上代码,最后代码如下:
注意:CheckBox1的AutoPostBack要True!
后台全部代码如下:
using
using
using
using
using
using
using
using
using
public
{
}
前台代码如下:
xmlns="http://www.w3.org/1999/xhtml"
runat="server">
s="font-size=12px">
13.GridView弹出新页面/弹出制定大小位置新窗口:
方案一:简单的方法,新窗口不固定大小
DataNavigateUrlFields是链接的字段名,DataNavigateUrlFormatStr
方案二:精确控制弹出窗口大小位置
这里是怎么实现确认对话框的:
http://www.cnblogs.com/sufei/archive/2009/06/10/1500254.html
14.GridView固定表头(不用javascript只用CSS!,很好用):
前台代码解决方法:
xmlns="http://www.w3.org/1999/xhtml"
runat="server">
s="font-size=12px">