<asp:TemplateField HeaderText="修改催收结果">
<ItemTemplate>
<%--<asp:Label ID="lbl_CSJG" Text='<%# Eval("催收结果") %>' runat="server"></asp:Label>--%>
<asp:DropDownList ID="drp_CSJG" AutoPostBack="True" runat="server" OnSelectedIndexChanged="drp_CSJG_SelectedIndexChanged">
<asp:ListItem Text="N无人应门" Value="1"></asp:ListItem>
<asp:ListItem Text="F邻居应门-本人不在场" Value="2"></asp:ListItem>
<asp:ListItem Text="F家人应门-本人不在场" Value="3"></asp:ListItem>
<asp:ListItem Text="A持卡人应门-本人在场" Value="4"></asp:ListItem>
<asp:ListItem Text="A联系到本人-本人在场" Value="B"></asp:ListItem>
<asp:ListItem Text="F联系到家属-本人不在场" Value="J"></asp:ListItem>
<asp:ListItem Text="F联系到其他-本人不在场" Value="T"></asp:ListItem>
<asp:ListItem Text="Z地址无效" Value="Z"></asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Width="80px" />
</asp:TemplateField>
/// <summary>
/// 修改催收结果
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void drp_CSJG_SelectedIndexChanged(object sender, EventArgs e)
{
//行号
int row = ((GridViewRow)((DropDownList)sender).NamingContainer).RowIndex;
string ID = ((Label)gvVisitandCasePFData.Rows[row].FindControl("lbl_ID")).Text;
string drp_CSJG = ((DropDownList)gvVisitandCasePFData.Rows[row].FindControl("drp_CSJG")).SelectedValue;
string drp_CSJG_text = ((DropDownList)gvVisitandCasePFData.Rows[row].FindControl("drp_CSJG")).SelectedItem.Text;
sql = string.Format(@" update VIsit set State ='{0}' where RecordID='{1}' ", drp_CSJG, ID);
//执行sql语句
这里就是执行修改语句的代码,此处省略
}
//页面加载时将数据库数据绑定到下拉框
protected void gvVisitandCasePFData_RowDataBound(object sender, GridViewRowEventArgs e)
{ if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView rowItem = (DataRowView)e.Row.DataItem;
DropDownList drp_CSJG = (DropDownList)e.Row.FindControl("drp_CSJG");
if (rowItem["修改催收结果"] != DBNull.Value)
{
drp_CSJG.SelectedValue = rowItem["修改催收结果"].ToString();
//clsName.Items.FindByText(rowItem["催收结果"].ToString()).Selected = true;
//clsName.SelectedValue = ((Label)e.Row.FindControl("lbl_CSQD")).Text;
}
}
}