📄 datareader.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<body>
<SCRIPT language="C#" runat="Server">
SqlDataReader dr;
SqlConnection conn;
void Page_Load(object Src, EventArgs E)
{
SqlCommand cmdAuthors;
conn = new SqlConnection("data source=(local)\\NETSDK;initial catalog=pubs;integrated security=SSPI;persist security info=True");
conn.Open();
cmdAuthors = new SqlCommand ("select * from Authors", conn);
dr = cmdAuthors.ExecuteReader();
//output the first name
dr.Read();
lblname.Text = dr.GetString(1) + ", " + dr.GetString(2);
}
//close the datareader and connection in the Page_UnLoad event procedure
void Page_UnLoad(object s, EventArgs e)
{
dr.Close();
conn.Close();
}
</SCRIPT>
<form runat="server">
Author Name: <asp:label id="lblname" runat="server"/>
<P>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -