Question

急！GridView和下拉菜单DropDownList结合的问题，改变某一行DropDownList的值，数据库里的数据为什么不更

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList Type = sender as DropDownList;
TableCell cell = (TableCell)Type.Parent;
GridViewRow item = (GridViewRow)cell.Parent;
string sqlstr = "Update assignment set LL='" + Type.SelectedValue + "' where ID='"+item.Cells[0].Text+"'";
sqlcon = new MySqlConnection(strCon);
sqlcom = new MySqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
//sqlcon.Close();
}
<asp:TemplateField HeaderText="LL">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="LL" DataTextField="LL" AutoPostBack="True">

</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
我的目的就是在gridview中，直接修改dropdownlist的值，能更新到数据库。

Answer 1

1、GridView1_SelectedIndexChanged这个方法根本就进不去的
2、你可以把前台的下拉框改一下<asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="LL" DataTextField="LL" AutoPostBack="True" OnSelectedIndexChanged=”方法名”>，然后在后台编写这个方法就好了

Answer 2

设置个断点 然后看程序运行了冒