首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

gridview定义的dropdownlist控件如何绑定到字段,且GridView1_RowDeleting都没有效果

2012-05-21 
gridview定义的dropdownlist控件怎么绑定到字段,且GridView1_RowDeleting都没有效果,在线等gridview定义的

gridview定义的dropdownlist控件怎么绑定到字段,且GridView1_RowDeleting都没有效果,在线等
gridview定义的dropdownlist控件怎么绑定到字段

C# code
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" DataKeyNames="roomno" OnRowEditing="GridView1_RowEditing"  OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowUpdating="GridView1_RowUpdating" AutoGenerateColumns="False" >            <Columns>                <asp:BoundField HeaderText="房间号" DataField="roomno"  />                <asp:TemplateField HeaderText="房间类型" >        <%--//如何绑定到字段--%>               <ItemTemplate>                <asp:DropDownList ID="roomtype" runat="server"  >                <asp:ListItem  Value="1">豪华房</asp:ListItem>                  <asp:ListItem  Value="2">商务房</asp:ListItem>                  <asp:ListItem  Value="3">双人房</asp:ListItem>                  <asp:ListItem  Value="4">房型4</asp:ListItem>                  <asp:ListItem  Value="5">房型5</asp:ListItem>                  <asp:ListItem  Value="6">房型6</asp:ListItem>                </asp:DropDownList>                </ItemTemplate>                </asp:TemplateField>                <asp:BoundField DataField="roomstatu" HeaderText="房间状态" />                <asp:BoundField HeaderText="房价" DataField="unitprice" DataFormatString="{0:c}" />                <asp:CommandField HeaderText="编辑" ShowEditButton="True" />                <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />            </Columns>        </asp:GridView>.cs protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)    {        try        {            int index = e.RowIndex;//当前选择行索引值           string roomno = GridView1.DataKeys[index].Value.ToString();//获取主键房间号           string roomtype = ((TextBox)(GridView1.Rows[index].Cells[1].Controls[0])).Text.Trim();           string roomstatu = ((TextBox)(GridView1.Rows[index].Cells[2].Controls[0])).Text.Trim();           string unitprice = ((TextBox)(GridView1.Rows[index].Cells[3].Controls[0])).Text.Trim();           string sql = "update room set roomtype="+roomtype+",roomstatu="+roomstatu+",unitprice="+unitprice+"";//更新语句           SqlConnection conn = new SqlConnection(strCon);           conn.Open();           SqlCommand comm = new SqlCommand(sql, conn);           int ret = comm.ExecuteNonQuery();            if (ret>0)            {                //更新成功            }            else            {                //更新失败            }            GridView1.EditIndex = -1;            DataBind();        }        catch (Exception ex)        {         throw;        }    }     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)    {        int index = e.RowIndex;        string roomno = GridView1.DataKeys[index].Value.ToString();        string sql = "delete from room where roomno="+roomno+"";//删除语句        SqlConnection conn = new SqlConnection(strCon);        conn.Open();        SqlCommand comm = new SqlCommand(sql, conn);        conn.Close();        DataBind();    }


[解决办法]
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" CommandName="Delete" />
试试

热点排行