📄 newaspnet.aspx
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -