GridView无代码分页排序GridView选中,编辑,取消,删除GridView正反双向排序GridView和下拉菜单DropDow
List结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“”代替超长字符串GridView一般换行与强制换行GridView显示隐藏某一列GridView弹出新页面弹出新窗口GridView固定表头不用javascript只用CSS,2行代码,很好用GridView合并表头多重表头无错完美版(以合并3列3行举例)GridView突出显示某一单元格(例如金额低于多少,分数不及格等)GridView加入自动求和求平均值小计GridView数据导入ExcelExcel数据读入GridView1GridView无代码分页排序:效果图:
1AllowSorti
g设为True,aspx代码中是AllowSorti
gTrue;2默认1页10条,如果要修改每页条数,修改PageSize即可,在aspx代码中是PageSize12。3默认的是单向排序的,右击GridView弹出“属性”,选择AllowSorti
g为True即可。
2GridView选中,编辑,取消,删除:
f效果图:
后台代码:你可以使用sqlhelper本文没用。代码如下:usi
gSystemusi
gSystemDatausi
gSystemCo
figuratio
usi
gSystemWebusi
gSystemWebSecurityusi
gSystemWebUIusi
gSystemWebUIWebCo
trolsusi
gSystemWebUIWebCo
trolsWebPartsusi
gSystemWebUIHtmlCo
trolsusi
gSystemDataSqlClie
tpublicpartialclass_DefaultSystemWebUIPage清清月儿httpblogcsd
et21asp
etSqlCo
ectio
sqlco
SqlComma
dsqlcomstri
gstrCo
DataSourcelocalDatabase数据库名Uid帐号Pwd密码protectedvoidPage_Loadobjectse
derEve
tArgseifIsPostBackbi
dprotectedvoidGridView1_RowEditi
gobjectse
derGridViewEditEve
tArgseGridView1EditI
dexeNewEditI
dexbi
d
f删除protectedvoidGridView1_RowDeleti
gobjectse
derGridViewDeleteEve
tArgsestri
gsqlstrdeletefrom表whereidGridView1DataKeyseRowI
dexValueToStri
gsqlco
ewSqlCo
ectio
strCo
sqlcom
ewSqlComma
dsqlstrsqlco
sqlco
Ope
sqlcomExecuteNo
Querysqlco
Closebi
d更新protectedvoidGridView1_RowUpdati
gobjectse
derGridViewUpdateEve
tArgsesqlco
ewSqlCo
ectio
strCo
stri
gsqlstrupdate表set字段1TextBoxGridView1RowseRowI
dexCells1Co
trols0TextToStri
gTrim字段2TextBoxGridView1RowseRowI
dexCells2Co
trols0TextToStri
gTrim字段3TextBoxGridView1RowseRowI
dexCells3Co
trols0TextToStri
gTrimwhereidGridView1DataKeyseRowI
dexValueToStri
gsqlcom
ewSqlComma
dsqlstrsqlco
sqlco
Ope
sqlcomExer