📄 c12-03.aspx

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

💻 ASPX

字号:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Html><Body BgColor="White"><Form runat="server">
<asp:DataList id="DataList1" runat="server"
     Border="1" BorderColor="Black"
     CellPadding="2" CellSpacing="0"
     HeaderStyle-BackColor="#aaaadd"
     AlternatingItemStyle-BackColor="lightgray"
SelectedItemStyle-BackColor="yellow" 
     OnItemCommand="DataList_ItemCommand"
     OnSelectedCommand="DataList_SelectedCommand" >
<HeaderTemplate>id</HeaderTemplate>
<ItemTemplate>
  <%# DataBinder.Eval(Container.DataItem,"au_id")%>
  <asp:LinkButton id="Detail" runat="server" Text="query" CommandName="query"/>
</ItemTemplate>
     <SelectedItemTemplate>
  address: <%# DataBinder.Eval(Container.DataItem,"address")%><BR>phone: <%# DataBinder.Eval(Container.DataItem,"phone")%><BR>city: <%# DataBinder.Eval(Container.DataItem,"city")%><BR>
  <asp:LinkButton id="Title" runat="server" />
</SelectedItemTemplate>
</asp:DataList></Form><hr></Body></Html>
<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");
     DataList1.DataSource=ds.Tables["authors"].DefaultView ;
     DataList1.DataBind();
     Conn.Close();
   }
   void DataList_ItemCommand(Object sender ,DataListCommandEventArgs e )
   {
     DataList1.SelectedIndex = e.Item.ItemIndex ;
     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") ;
     DataList1.DataSource=ds.Tables["authors"].DefaultView ;
     DataList1.DataBind() ;   
     Conn.Close() ;
   } 
</script>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -