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

📄 datagrid.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 OleDbConnection = new OleDbConnection _
                     ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
                      "Data Source=H:\ASPNET\data\banking.mdb")

       'open connection
       dim myCommand as OleDbDataAdapter = 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.Tables("tblUsers"). _
       '   DefaultView
       DataGrid1.DataSource = ds
	   DataGrid1.DataMember = "tblUsers"
       DataGrid1.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_PageIndexChanged(obj as Object, e as DataGridPageChangedEventArgs)
       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-Name="Arial" 
         Font-Size="8pt" 
         ShowFooter="True" 
         HeaderStyle-BackColor="#cccc99"
         FooterStyle-BackColor="#cccc99"
         ItemStyle-BackColor="#ffffff"
         AlternatingItemStyle-Backcolor="#cccccc"
         AutoGenerateColumns="False"
         AllowSorting="true" 
         DataKeyField="UserID"
         AllowPaging="true"
         PageSize=2
         PagerStyle-Mode=NumericPages
         PagerStyle-PageButtonCount = 2
         OnEditCommand="DataGrid1_Edit"
         OnCancelCommand="DataGrid1_Cancel"
         OnUpdateCommand="DataGrid1_Update"
         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"
               HeaderStyle-Wrap="false"/>
            
         </COlumns>



      </asp:DataGrid>

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

⌨️ 快捷键说明

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