会员
周边
众包
新闻
博问
闪存
赞助商
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
.NET钉子户
反复学习-实践-领会-再实践
博客园
首页
新随笔
联系
管理
订阅
gridview实现下拉框功能
Code
//
把编辑列设模板列,然后dropdownlist绑定数据源
//
然后在databinding里把selectedvalue的值绑定到要更新的列名上
<
tr
>
<
td
><
asp:GridView ID
=
"
GridView1
"
runat
=
"
server
"
AutoGenerateColumns
=
False DataKeyNames
=
"
id
"
DataSourceID
=
"
SqlDataSource1
"
Width
=
"
292px
"
>
<
Columns
>
<
asp:BoundField DataField
=
"
id
"
HeaderText
=
"
id
"
ReadOnly
=
"
True
"
SortExpression
=
"
id
"
/>
<
asp:TemplateField HeaderText
=
"
roles
"
SortExpression
=
"
roles
"
>
<
EditItemTemplate
>
&
nbsp;
<
asp:DropDownList ID
=
"
DropDownList1
"
runat
=
"
server
"
DataSourceID
=
"
SqlDataSource1
"
DataTextField
=
"
power_id
"
DataValueField
=
"
power_id
"
SelectedValue
=
'
<%# Bind("roles") %>
'
>
</
asp:DropDownList
><
asp:SqlDataSource ID
=
"
SqlDataSource1
"
runat
=
"
server
"
ConnectionString
=
"
<%$ ConnectionStrings:cmssConnectionString %>
"
SelectCommand
=
"
SELECT [power_id] FROM [power]
"
></
asp:SqlDataSource
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label1
"
runat
=
"
server
"
Text
=
'
<%# Bind("roles") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:CommandField ShowEditButton
=
"
True
"
/>
</
Columns
>
</
asp:GridView
>
</
td
>
</
tr
>
<
tr
>
<
td style
=
"
width: 73px
"
>
</
td
>
<
td style
=
"
width: 100px
"
>
&
nbsp;
<
asp:SqlDataSource ID
=
"
SqlDataSource1
"
runat
=
"
server
"
UpdateCommand
=
"
update admin set roles=@roles where id=@original_id
"
OldValuesParameterFormatString
=
"
original_id
"
ConnectionString
=
"
<%$ ConnectionStrings:cmssConnectionString %>
"
SelectCommand
=
"
SELECT [roles], [id] FROM [admin]
"
></
asp:SqlDataSource
>
</
td
>
</
tr
>
posted @
2008-12-19 11:10
.NET钉子户
阅读(
1078
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
公告