c12-02.aspx
来自「一本很好的教材.C#开发者必备.内容全面,很难得哦.」· ASPX 代码 · 共 30 行
ASPX
30 行
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Html>
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
<B><%# DataBinder.Eval(Container.DataItem,"au_id") %></B>
<blockquote>
address: <%# DataBinder.Eval(Container.DataItem,"address") %>,
<br>phone: <%# DataBinder.Eval(Container.DataItem,"phone") %>,
<br>city: <%# DataBinder.Eval(Container.DataItem,"city") %>
</blockquote>
</ItemTemplate>
</asp:Repeater>
<script language="c#" runat="server">
void Page_Load(Object sender, EventArgs E)
{
DataSet ds = new DataSet() ;
String ConnStr = "Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User ID=sa;Initial Catalog=pubs;Data Source=localhost" ;
OleDbConnection Conn = new OleDbConnection(ConnStr) ;
Conn.Open() ;
String SQL = "Select * from authors" ;
OleDbCommand Cmd = new OleDbCommand( SQL, Conn ) ;
OleDbDataAdapter Adapter = new OleDbDataAdapter ( ) ;
Adapter.SelectCommand = Cmd ;
Adapter.Fill(ds, "authors") ;
Repeater1.DataSource=ds.Tables["authors"].DefaultView ;
Repeater1.DataBind() ;
}
</script>
</Html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?