<%@ Import Namespace= "System.Data.SqlClient" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E)
{
{
SqlConnection myConnection = new SqlConnection("server=(local);" + "database =hospital; Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT " + " * FROM SickInfo", myConnection);
DataSet ds =new DataSet();
myCommand.Fill(ds);
DataView source = new DataView(ds.Tables[0]);
DropDownList1.DataSource= source;
DropDownList1.DataBind();
}
}
</script>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body>
<h4><font face="Verdana">病种信息</font>
</h4>
<form id="Form1" method="post" runat="server">
选择病种 <FONT face="宋体">
<asp:dropdownlist id=DropDownList1 runat="server" AutoPostBack="True" DataTextField="病种名" width="120" >
</asp:dropdownlist></FONT></form>
</body>
