📄 repeater.aspx

📁 聊天聊天聊天聊天聊天聊天

💻 ASPX

字号:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
    <script language="VB" runat="server">
	Dim myConnection As OleDbConnection
	Dim myCommand    As OleDbDataAdapter
	Dim ds           As New DataSet
	Dim ConnStr      As String
	Dim SQL          As String
	Sub Page_Load(Source As Object, E As EventArgs) 
	   ConnStr = "Provider=SQLOLEDB; Data Source=(local); Initial Catalog=ASPNET;User ID=sa;"
	   myConnection = New OleDbConnection(ConnStr)      
	    if NOT (isPostBack)
	    	rebind
	    end if	
  	End Sub
    	Sub ReBind()
	    'DataSetCommand
	    SQL = "select * from Groups"
	    myCommand = New OleDbDataAdapter(SQL, myConnection)
	    'use Fill method of DataSetCommand to populate dataset
	    myCommand.Fill(ds, "Groups")
	    'Binding a Grid	
	    DataGrid1.DataSource=ds.Tables("Groups").DefaultView
	    DataGrid1.DataBind()
    	End Sub
    </script>
    <body>
       <h3><font face="Verdana"> Data Repeater</font></h3>
     <form  runat=server>
   	<asp:Repeater id="DataGrid1" runat="server">
	  <HeaderTemplate>
	    <table border = 1>
	      <tr>
		<td><b>Name</b></td>
		<td><b>Group</b></td>
		<td><b>Type</b></td>
	      </tr>
	  </HeaderTemplate>
	  <ItemTemplate>
	     <tr>
	           <td> <%# Container.DataItem("code_display") %></td>
	           <td><%# Container.DataItem("code_category") %></td>
	           <td><%# Container.DataItem("type") %></td>
	    </tr>
	  </ItemTemplate>
	  <AlternatingItemTemplate>
	    <tr style="background-color: silver"> 
		   <td> <%# Container.DataItem("code_display") %></td>
		   <td><%# Container.DataItem("code_category") %></td>
		   <td><%# Container.DataItem("type") %></td>
	    </tr>
	  </AlternatingItemTemplate>
	  <FooterTemplate>
	    </table>
	  </FooterTemplate>
	</asp:Repeater>
       </form>
    </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -