62,047
社区成员
发帖
与我相关
我的任务
分享
<asp:TemplateField HeaderText="医院状态" SortExpression="Hos_State">
<EditItemTemplate>
<asp:DropDownList ID="ddlstate1" runat="server" AutoPostBack="true"></asp:DropDownList>
<asp:HiddenField ID="fhstate1" runat="server" Value='<%# Eval("Hos_State")%>' />
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="ddlstate2" runat="server" AutoPostBack="true"></asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblstate" runat="server" Text='<%# Bind("Hos_State") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="医院简介" SortExpression="Hos_Present">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Hos_Present") %>' TextMode="MultiLine"></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Hos_Present") %>' TextMode="MultiLine"></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblpre" runat="server" Text='<%# Bind("Hos_Present") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:reserveConnectionString %>"
SelectCommand="SELECT * FROM T_GH_Hospital WHERE Hos_ID=@Hos_ID "
>
<SelectParameters>
<asp:ControlParameter Name="Hos_ID" ControlID="GridView1" />
</SelectParameters>
</asp:SqlDataSource>
protected void DetailsView1_PreRender(object sender, EventArgs e)
{
if (IsPostBack)
{
DetailsView detailsView = (DetailsView)sender;
if (detailsView.CurrentMode == DetailsViewMode.Edit)
{
DropDownList dropDownList = (DropDownList)detailsView.FindControl("ddlstate1");
dropDownList.Items.Clear();
dropDownList.Items.Add(new ListItem("正常", "0"));
dropDownList.Items.Add(new ListItem("暂停", "1"));
dropDownList.Items.Add(new ListItem("冻结", "2"));
switch (((HiddenField)detailsView.FindControl("fhstate1")).Value.ToString())
{
case "正常":
dropDownList.SelectedIndex = 0;
break;
case "暂停":
dropDownList.SelectedIndex = 1;
break;
case "冻结":
dropDownList.SelectedIndex = 2;
break;
default:
break;
}
}
}
}
<EditItemTemplate>
<asp:DropDownList ID="ddlstate1" runat="server" AutoPostBack="true"></asp:DropDownList>
<asp:HiddenField ID="fhstate1" runat="server" Value='<%# Eval("Hos_State")%>' />
</EditItemTemplate>
<asp:sqlDataSource ID="EmployeeDetailsSqlDataSource"
SelectCommand="SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID"
InsertCommand="INSERT INTO Employees(LastName, FirstName) VALUES (@LastName, @FirstName);
SELECT @EmpID = SCOPE_IDENTITY()"
UpdateCommand="UPDATE Employees SET LastName=@LastName, FirstName=@FirstName
WHERE EmployeeID=@EmployeeID"
DeleteCommand="DELETE Employees WHERE EmployeeID=@EmployeeID"
ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
OnInserted="EmployeeDetailsSqlDataSource_OnInserted"
RunAt="server">
<SelectParameters>
<asp:Parameter Name="EmpID" Type="Int32" DefaultValue="0" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="EmpID" Direction="Output" Type="Int32" DefaultValue="0" />
</InsertParameters>
</asp:sqlDataSource>