📄 c12-02.aspx

📁 一本很好的教材.C#开发者必备.内容全面,很难得哦.

💻 ASPX

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -