newaspnet.aspx

来自「东软内部材料(四)asp等相关的教学案例 」· ASPX 代码 · 共 60 行

ASPX
60
字号
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
<head>

<script language="C#" runat="server">

	void Page_Load(Object Source, EventArgs E)
	{
		if (!Page.IsPostBack)
		{
			SqlConnection	myConnection;
			SqlCommand		myCommand;
			SqlDataReader	myReader;
			String			Sql;
			String			ConnStr;

			Sql = "SELECT * FROM Shippers";
			ConnStr = ConfigurationSettings.AppSettings["DsnNorthwind"];
			myConnection = new SqlConnection(ConnStr);
			myConnection.Open();

			myCommand = new SqlCommand(Sql, myConnection);

			myReader = myCommand.ExecuteReader();

			ShipMethod.DataSource = myReader;
			ShipMethod.DataBind();
		}
	}

	void PlaceOrder_Click(Object Source, EventArgs E)
	{
		YouSelected.Text = "Your order will be delivered via " +
			ShipMethod.SelectedItem.Text;
	}

</script>

<form runat="server">

   Please select your delivery method:

   <asp:DropDownList id="ShipMethod"
      DataTextField="CompanyName" DataValueField="ShipperID"
      runat="server"/>

   <br/>

   <asp:button id="PlaceOrder" Text="Place Order"
      onClick="PlaceOrder_Click"
      runat="server"/>

   <br/>

   <asp:Label id="YouSelected" runat="server"/>
</form>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?