无法将下拉框的值,更新到数据库。请帮忙看一下
html:
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>
</asp:ListItem>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
UpdateCommand="UPDATE [bsperson] SET [kb] = @kb, [jz] = @jz, [xm] = @xm, [jb] = @jb, [zw] = @zw, [rsr] = @rsr, [xb] = @xb, [csnyr] = @csnyr, [lb] = @lb, [dlrq] = @dlrq, [sszz] = @sszz, [ssbz] = @ssbz, [gwm] = @gwm, [gw] = @gw WHERE [gh] = @gh">
cs:
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
if (!IsPostBack)
{
for (int i = 0; i < DetailsView1.Rows.Count; i++)
{
string ddlstr = string.Empty;
DropDownList ddl = this.DetailsView1.Rows[i].FindControl("DropDownList1") as DropDownList;
ddlstr = ddl.SelectedValue.ToString();
} }
}
html:
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>
</asp:ListItem>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
UpdateCommand="UPDATE [bsperson] SET [kb] = @kb, [jz] = @jz, [xm] = @xm, [jb] = @jb, [zw] = @zw, [rsr] = @rsr, [xb] = @xb, [csnyr] = @csnyr, [lb] = @lb, [dlrq] = @dlrq, [sszz] = @sszz, [ssbz] = @ssbz, [gwm] = @gwm, [gw] = @gw WHERE [gh] = @gh">
cs:
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
if (!IsPostBack)
{
for (int i = 0; i < DetailsView1.Rows.Count; i++)
{
string ddlstr = string.Empty;
DropDownList ddl = this.DetailsView1.Rows[i].FindControl("DropDownList1") as DropDownList;
ddlstr = ddl.SelectedValue.ToString();
} }
}
解决方案 »
- 如何在gridview 中的单元格添加一个按钮,点击按钮进行条件选择? 急!!!
- 100求助 分不够 可以加!! VS2005下怎么给水晶报表rpt文件添加 .cs 文件??
- FCKEditor添加工具菜单
- 框架中指定页面的刷新问题
- C#中使用 OleDb 访问 ACCESS 数据库能读不能写
- 关于webform_postbackoptions未定义的错误
- 请教一个表单验证的问题,个人认为有难度
- 请问在.NET中直接用代码能生成窗体吗???
- help !!!!!!!!!!!!help me !!!!!how can help me
- XDE安装完后怎样用呀
- 基于asp.net mvc3的简单联运示例
- 关于从数据库datatime中读取年月日
DropDownList1.items(DropDownList1.selectedindex).Text这样子的 如果你是这样子的话
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem >
</asp:ListItem>
<asp:ListItem Value="1">1</asp:ListItem>
<asp:ListItem Value="2">2</asp:ListItem>
</asp:DropDownList> 这样就对了
在更新时.ddlstr 的值会等于@xb吗?UpdateCommand="UPDATE [bsperson] SET [kb] = @kb, [jz] = @jz, [xm] = @xm, [jb] = @jb, [zw] = @zw, [rsr] = @rsr, [xb] = @xb, [csnyr] = @csnyr, [lb] = @lb, [dlrq] = @dlrq, [sszz] = @sszz, [ssbz] = @ssbz, [gwm] = @gwm, [gw] = @gw WHERE [gh] = @gh">protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
if (!IsPostBack)
{
for (int i = 0; i < DetailsView1.Rows.Count; i++)
{
string ddlstr = string.Empty;
DropDownList ddl = this.DetailsView1.Rows[i].FindControl("DropDownList1") as DropDownList;
ddlstr = ddl.SelectedValue.ToString();
} }
}
求解答.