⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 listing0914.aspx

📁 asp入门到精通的源代码
💻 ASPX
字号:
🔍 
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="VB" runat="server">
   sub Page_Load(obj as Object, e as EventArgs) 

      'set up connection
      dim myConnection as new OleDbConnection _
         ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source=H:\ASPNET\data\banking.mdb")

      'open connection
      dim myCommand as new OleDbDataAdapter _
         ("select * from tblUsers", myConnection)

      'fill dataset
      dim ds as DataSet = new DataSet()
      myCommand.Fill(ds, "tblUsers")

      'select data view and bind to server control
      DataGrid1.DataSource = ds
      DataGrid1.DataMember = "tblUsers"
      DataBind()
   end sub
   
   sub DataGrid1_Edit(obj as object, e as DataGridCommandEventArgs)
      DataGrid1.EditItemIndex = e.Item.ItemIndex
      DataGrid1.DataBind()
   end sub

   sub DataGrid1_Update(obj as object, e as DataGridCommandEventArgs)
      'do updates
      DataGrid1.DataBind()
   end sub

   sub DataGrid1_Cancel(obj as object, e as DataGridCommandEventArgs)
      DataGrid1.EditItemIndex = -1
      DataGrid1.DataBind()
   end sub
   
   sub DataGrid1_SortCommand(obj as Object, _
                 e as DataGridSortCommandEventArgs)
      ' sort the data using the SortField property
      ' of the eventargs
      DataGrid1.DataBind()
   End Sub

   sub DataGrid1_PageIndexChanged(obj as Object, e as DataGridPageChangedEventArgs)
      DataGrid1.CurrentPageIndex = e.NewPageIndex
      DataGrid1.DataBind()
   end sub


</script>

<body>

   <form runat="server">
      <asp:DataGrid id="DataGrid1" runat="server"
	      BorderColor="black"
	      GridLines="Vertical"
	      cellpadding="4"
	      cellspacing="0"
	      width="450"
	      Font-NameFont-Names="Arial"
	      Font-Size="8pt"
	      ShowFooter="True"
	      HeaderStyle-BackColor="#cccc99"
	      FooterStyle-BackColor="#cccc99"
	      ItemStyle-BackColor="#ffffff"
	      AlternatingItemStyle-Backcolor="#cccccc"
	      AutoGenerateColumns="false"
	      AllowSorting=true
	      OnEditCommand="DataGrid1_Edit"
	      OnCancelCommand="DataGrid1_Cancel"
	      OnUpdateCommand="DataGrid1_Update"
	      AllowPaging="True"
	      PageSize=2
	      PagerStyle-Mode=NumericPages
	      PagerStyle-PageButtonCount = 2
	      OnPageIndexChanged="DataGrid1_PageIndexChanged" >
	
	      <Columns>
	
	            <asp:TemplateColumn HeaderText="Name">
	                  <ItemTemplate>
	                        <asp:Label id="Name" runat="server"
	                              Text='<%# Container.DataItem("FirstName")& _
                                " " & Container.DataItem("LastName") %>'/>
	                  </ItemTemplate>
               </asp:TemplateColumn>
	
	            <asp:BoundColumn HeaderText="Address"
	                  DataField="Address"/>
	
	            <asp:BoundColumn HeaderText="City" DataField="City"/>
	
	            <asp:BoundColumn HeaderText="State"
	                  DataField="State" />
	
	            <asp:BoundColumn HeaderText="Zip" DataField="Zip" />
	
	            <asp:EditCommandColumn
	               EditText="Edit"
	               CancelText="Cancel"
	               UpdateText="Update"
	               ItemStyle-Wrap="false"
	               HeaderText="Edit" />

	
	      </Columns>
	
	</asp:DataGrid>

   </form>
   
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -