listing2304.aspx

asp入门到精通的源代码

<%@ Page Inherits="System.Web.UI.MobileControls.MobilePage" Language="VB" %>
<%@ Register TagPrefix="Mobile" Namespace="System.Web.UI.MobileControls" Assembly="System.Web.Mobile" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
   sub Page_Load(obj as Object, e as EventArgs)
      
   end sub
   
   sub NamePick(obj as Object, e as ListCommandEventArgs)
      lblName.Text = e.ListItem.Text
      lblPhone.Text = e.ListItem.Value
      ActiveForm = frmPrice
   end Sub
   
   sub LoadList(obj as Object, e as LoadItemsEventArgs)
      dim intStart as integer = e.ItemIndex + 1
      dim i as integer 
      dim objConn as new OleDbConnection _
         ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source=C:\ASPNET\data\banking.mdb")

      Dim objReader as OleDbDataReader
      Dim objCmd As New OleDbCommand("select * from tblUsers", objConn)
      
      objConn.Open
      objReader = objCmd.ExecuteReader
      
      for i = 0 to e.ItemCount - 1
         if objReader.Read then
            lNames.Items.Add(new MobileListItem(objReader.GetString(0)))
         end if
      next

      objReader.Close
      objConn.Close
   end sub
</script>

<Mobile:Form id="frmMenu" BackColor="#ccddcc" runat="server" Paginate="true"
   PagerStyle-Font-Size="Small" 
            PagerStyle-Font-Bold="True" 
            PagerStyle-NextPageText="Forward to Page {0}" 
            PagerStyle-PreviousPageText="Back to Page {0}">
   <Mobile:Label runat="server" StyleReference="title" 
      Text="Names" />
   <Mobile:List id="lNames" runat="server"
      OnItemCommand="NamePick" 
      DataTextField="FirstName"
      DataValueField="Phone"
      ItemCount="20"
      OnLoadItems="LoadList" />
</Mobile:Form>

<Mobile:Form id="frmPrice" BackColor="#ccddcc" runat="server">
    <Mobile:Label id="lblName" runat="server"/>
    <Mobile:Label id="lblPhone" runat="server"/>
</Mobile:Form>