📄 datareadersp.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<body>
<SCRIPT language="C#" runat="Server">
void Page_Load(Object src, EventArgs E)
{
SqlConnection conn;
SqlCommand cmd;
SqlDataReader dr;
SqlParameter workParam;
conn = new SqlConnection("data source=(local);initial catalog=Conf;integrated security=SSPI;persist security info=True");
//call the ProductCategoryList stored procedure that returns a set of records
cmd = new SqlCommand("ProductCategoryList", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
dr = cmd.ExecuteReader();
//loop through the datareader and display all records
spnCategories.InnerHtml = "";
while(dr.Read())
{
spnCategories.InnerHtml = spnCategories.InnerHtml + dr.GetString(1) + "<BR>";
}
//close the DataReader and connection when you're all done
dr.Close();
conn.Close();
}
</SCRIPT>
<H2>Product categories</H2>
<span id="spnCategories" runat="server"></span>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -