1、GridView突出显示某一单元格(例如金额低于多少,分数不及格等)GridView加入自动求和求平均值小计GridView数据导入Excel/Excel数据读入GridView=如果你喜欢GridView 72般绝技这个博客帖子,那么你应该喜欢我的新书我的新书开发技巧精讲 2011.12.12日,写在我的新书开印之前 1.GridView无代码分页排序:效果图:1.AllowSorting设为True,aspx代码中是AllowSorting=True;2.默认1页10条,如果要修改每页条数,修改PageSize即可,在aspx代码中是PageSize=12。3.默认的是单向排序的,右击Gr
2、idView弹出“属性”,选择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
3、.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 GridView
4、1_RowEditing(object sender, GridViewEditEventArgs e)GridView1.EditIndex = e.NewEditIndex;/删除protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)string sqlstr = delete from 表 where id= + GridView1.DataKeyse.RowIndex.Value.ToString() + sqlcon = new SqlConnection(strCon);sqlco
5、m = new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();/更新protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)update 表 set 字段1=+ (TextBox)(GridView1.Rowse.RowIndex.Cells1.Controls0).Text.ToString().Trim() + ,字段2=+ (TextBox)(GridView1.Rowse.R
6、owIndex.Cells2.Controls0).Text.ToString().Trim() + ,字段3=+ (TextBox)(GridView1.Rowse.RowIndex.Cells3.Controls0).Text.ToString().Trim() + where id= + GridView1.DataKeyse.RowIndex.Value.ToString() + sqlcom=new SqlCommand(sqlstr,sqlcon);GridView1.EditIndex = -1;/取消protected void GridView1_RowCancelingEd
7、it(object sender, GridViewCancelEditEventArgs e)/绑定public void bind()select * from 表SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();myda.Fill(myds, 表);GridView1.DataSource = myds;GridView1.DataKeyNames = new string id ;/主键GridView1.DataBind();前台主要代码:. .FooterSty
8、le BackColor=#990000 Font-Bold= ForeColor=White /ColumnsBoundField DataField=身份证号码 HeaderText=用户ID ReadOnly=姓名用户姓名员工性别性别家庭住址CommandField HeaderText=选择 ShowSelectButton=编辑 ShowEditButton=删除 ShowDeleteButton=/ColumnsRowStyle ForeColor=#000066SelectedRowStyle BackColor=#669999PagerStyle BackColor= Hori
9、zontalAlign=LeftHeaderStyle BackColor=#006699/asp:GridView3.GridView正反双向排序:点姓名各2次的排序,点其他也一样可以。using System.Collections;public partial class Default3 : System.Web.UI.Page/清清月儿的博客 Database=北风贸易;Uid=sa;Pwd=ViewStateSortOrder = OrderDireASCprotected void GridView1_Sorting(object sender, GridViewSortEven
10、tArgs e)string sPage = e.SortExpression;if (ViewState.ToString() = sPage).ToString() = Desc)else = e.SortExpression;select top 5 * from 飞狐工作室飞狐工作室DataView view = myds.Tables.DefaultView;string sort = (string)ViewState + + (string)ViewState;view.Sort = sort;GridView1.DataSource = view; AllowSorting=C
11、ellPadding=3 Font-Size=9pt OnSorting=GridView1_Sorting BackColor= BorderColor=#CCCCCC BorderStyle= BorderWidth=1px SortExpression=/4.GridView和下拉菜单DropDownList结合:public partial class Default4 :Pwd=saDropDownList ddl;for (int i = 0; i DropDownList ID= DataSource=%# ddlbind()% DataValueField= DataTextField=DropDownList/ItemTemplateTemplateField5.GridView和CheckBox结合:public partial class Default5 :protecte