不显示删除回复显示所有回复显示星级回复显示得分回复 DataGrid中如何操作ＤropDownList?[

windows2000 2010-05-15 09:48:54

<asp:datagrid id="st_dtg_class" runat="server" OnUpdateCommand="DataGrid_update" OnEditCommand="st_dtg_class_EditCommand" OnDeleteCommand="DataGrid_delete" OnCancelCommand="DataGrid_cancel"
OnPageIndexChanged="DataGrid_Page" AllowPaging="True" AutoGenerateColumns="False" DataKeyField="ST_Class_id" >
<Columns>
<asp:BoundColumn DataField="ST_Class_id" ReadOnly="True" HeaderText="班号"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Class_name" HeaderText="班名"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Class_department" HeaderText="系别"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Class_college" HeaderText="学院"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="班主任">
<ItemTemplate>
<asp:Label id="teacher_Name" Text='<%#Eval("ST_Teacher_name") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList id="ddl_teacher_ID_name" DataValueField="ST_Class_teacherid" dataTextField="ST_Teacher_name" runat="server"></asp:DropDownList>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
<asp:ButtonColumn Text="<div id="de" onclick="JavaScript:return confirm('确认删除？')">删除</div>" CommandName="Delete"></asp:ButtonColumn>
</Columns>
<PagerStyle NextPageText=" 下一页" Font-Size="12pt" PrevPageText="上一页" HorizontalAlign="Center"
ForeColor="DarkSlateBlue" BackColor="PaleGoldenrod" Mode="NumericPages"></PagerStyle>
</asp:datagrid>

我希望dropdownlist中的数据是绑定数据库中老师名单表，当用户点击修改的时候，教师用下拉框供用户选择，而不是文本框输入。

protected void st_dtg_class_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.EditItem)
{
st_sqlstr = "select ST_Teacher_id,ST_Teacher_name from ST_teacher";
SqlDataAdapter adapter = new SqlDataAdapter(st_sqlstr, st_conn);
DataSet ds = new DataSet();
adapter.Fill(ds);

DropDownList ddl_teacher_ID_name = (DropDownList)e.Item.FindControl("ddl_teacher_ID_name");
ddl_teacher_ID_name.DataSource = ds.Tables[0];
ddl_teacher_ID_name.DataValueField = "ST_Class_teacherid";
ddl_teacher_ID_name.DataTextField = "ST_Teacher_name";
ddl_teacher_ID_name.DataBind();
}
}

可惜，下拉框中没有数据

...全文