gridview嵌套用法.docVIP

GridView用法 2007-08-29 15:04 GridView无代码分页排序GridView选中，编辑，取消，删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“...”代替超长字符串GridView一般换行与强制换行GridView显示隐藏某一列GridView弹出新页面/弹出新窗口GridView固定表头(不用javascript只用CSS，2行代码，很好用)GridView合并表头多重表头无错完美版（以合并3列3行举例）GridView突出显示某一单元格（例如金额低于多少，分数不及格等）GridView加入自动求和求平均值小计GridView数据导入Excel/Excel数据读入GridView 1.GridView无代码分页排序： 效果图：1.AllowSorting设为True，aspx代码中是AllowSorting=True；2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize=12。3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。 2.GridView选中，编辑，取消，删除： 效果图： 后台代码：你可以使用sqlhelper,本文没用。代码如下：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 SqlC