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 + -
显示快捷键?