📄 sqldataadapter.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat=server>
void Page_Load(Object sender , EventArgs e)
{
DataSet dstAuthors;
SqlConnection conPubs;
SqlDataAdapter dadAuthors;
dstAuthors = new DataSet();
conPubs = new SqlConnection( @"Server=localhost;Database=Pubs;Integrated Security=SSPI" );
dadAuthors = new SqlDataAdapter( "Select * From Authors", conPubs );
dadAuthors.Fill( dstAuthors, "Authors" );
Response.Write("Authors table added to DataSet!");
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -