ti do un esempio tratto dal libro apogeo asp.net...
spero ti sia di aiuto...codice:<%@ Page Language="VB" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> <script 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 'Repeater1.DataSource = ds.Tables("tblUsers").DefaultView Repeater1.DataSource = ds Repeater1.DataMember = "tblUsers" DataBind() end sub </script> <html><body> <ASP:Repeater id="Repeater1" runat="server" > <HeaderTemplate> <table> <tr> <td bgcolor="#cccc99" width="200">Name</td> <td bgcolor="#cccc99" width="200">Phone</td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td> <%# Container.DataItem("FirstName") %> <%# Container.DataItem("LastName") %> </td> <td> <%# Container.DataItem("Phone") %> </td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr> <td bgcolor="#cccc99""> <%# Container.DataItem("FirstName") %> <%# Container.DataItem("LastName") %> </td> <td bgcolor="#cccc99"> <%# Container.DataItem("Phone") %> </td> </tr> </AlternatingItemtemplate> <SeparatorTemplate> <tr> <td colspan="2" align="center"> - - - </td> </tr> </SeparatorTemplate> <FooterTemplate> </table> </FooterTemplate> </ASP:Repeater> </body></html>


Rispondi quotando