DataList Control in ASP.NET - Part 2


Introduction

In Part 1 of this article series we have discussed how to simply Display Data with DataList Control but now in this article we will discuss how to Display Data in Multiple Columns with DataList Control.


Displaying Data in Multiple Columns with DataList Control

It is very simple to render the contents of a DataList control into a multi-column table in which each data item occupies a separate table cell. Two properties modify the layout of the HTML table rendered by the DataList control:

·         RepeatColumns: The number of columns to display.
·         RepeatDirection: The direction to render the cells. Possible values are Horizontal and Vertical.

Here is the example given below to display the contents of the Movies database table in a three-column layout.



<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
   
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">

    <style type="text/css">
       
    </style>

    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div class="content">
   
    <asp:DataList
        id="dlstMovies"
        DataSourceID="SqlDataSource1"
        RepeatColumns="3"
        GridLines="Both"
        Runat="server">
        <ItemTemplate>
        <br />
        <b><%#Eval("Title")%></b>
        <br />
        Directed by:
        <%#Eval("Director") %>
        <br />
        Box Office Totals:
        <%# Eval("BoxOfficeTotal")%>
        <br />
        </ItemTemplate>
    </asp:DataList>

    </div>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
        ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
        SelectCommand="SELECT Id,Title,Director,BoxOfficeTotal FROM Movies">
    </asp:SqlDataSource>

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


Notice that the DataList control in above example includes a RepeatColumns property that has the value 3. If we set the RepeatDirection property to the value Horizontal and do not assign a value to the RepeatColumns property, then the DataList renders its data items horizontally without end. We can display data items in multiple columns when the DataList is in Flow layout mode. In that case, <br> tags are used to create the row breaks. 

Note: Continue in Next Part.

Comments

Post a Comment

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Image
As you know ASP.NET Core Identity (table structure) is different from what we had earlier in ASP.NET Identity. Actually the identity system which we have today with .NET Core is very mature and continuously evolved be it ASP.NET Membership, ASP.NET Identity 1, ASP.NET Identity 2 and now ASP.NET Core Identity. Recently I had to migrate few application to ASP.NET Core and similar its identity database. Because the table schema is changed, i had to re-think and create migration script which I would like to share with you today. It is very simple and easy, just three step and I had everything ready: STEP 1 : Change name of existing tables STEP 2 : Create ASP.NET Core Identity tables STEP 3 : Migrate data from old tables (ASP.NET Identity) to new tables (ASP.NET Core Identity) Script:  https://gist.github.com/itorian/c699e8534b392a6c726ec66c48100072 You should also watch my video, where I demoed migration.
Read More »

Customize User's Profile in ASP.NET Identity System

Image
Note: You should read this post instead, I found below walkthrough will not work on ASP.NET Identity 2. I will re-work on this post soon. In this post you will learn how to customize User’s Profile and add some more fields like FirstName, LastName, EmailID etc with ASP.NET Identity System. In my last post I listed some of the great new features introduced with Identity system .
Read More »