Use of repeater

        Imports System.Data
        Imports System.Data.SqlClient          
                    
        Dim conn As New System.Data.SqlClient.SqlConnection( _
            ConfigurationManager.ConnectionStrings("myconnectstring").ConnectionString)

        Dim sqlDataAdapter1 As System.Data.SqlClient.SqlDataAdapter
        Dim dsMyDataset1 As System.Data.DataSet
        sqlDataAdapter1 = New System.Data.SqlClient.SqlDataAdapter(sqltext, conn)
        dsMyDataset1 = New System.Data.DataSet()

        Repeater1.HeaderTemplate = New MyTemplate(ListItemType.Header)
        Repeater1.ItemTemplate = New MyTemplate(ListItemType.Item)
        Repeater1.AlternatingItemTemplate = New MyTemplate(ListItemType.AlternatingItem)
        Repeater1.FooterTemplate = New MyTemplate(ListItemType.Footer)
        sqlDataAdapter1.Fill(dsMyDataset1, "MySqlTable")
        Repeater1.DataSource = dsDirectory1.Tables("MySqlTable")
        Repeater1.DataBind()