DetailsView Control in ASP.NET - Part 1


Introduction

The DetailsView Control enable us to work with a single data item at a time. This control enable us to display, edit, insert, and delete data items such as database records. Furthermore, it also enable us to page forward and backward through a set of data items. TheDetailsView control always renders each field in a separate HTML table row.


Displaying Data in DetailsView

A DetailsView control renders an HTML table that displays the contents of a single database record. The DetailsView supports both declarative and programmatic databinding.


Declarative Databinding

The example given below displays a record from the PRO_LIST database table, using declarative databinding.




<%@ Page Language="VB" AutoEventWireup="false" CodeFile="DetailsView (Declarative).aspx.vb" Inherits="_Default"%>

<!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">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">

    <div>

    <asp:DetailsView
        id="dtlProducts"
        DataSourceID="SqlDataSource1"
        Runat="server" />

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
            SelectCommand="SELECT [ID], [TITLE], [COMPANY], [PRICE], [AVAILABLITY] FROM [PRO_LIST]">
        </asp:SqlDataSource>

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


In above example, the SQL Select statement associated with the SqlDataSource control retrieves the first product from the PRO_LIST database table. The DetailsView control is bound to the SqlDataSource control through its DataSourceID property.


Programmatically Databinding

We also can bind a DetailsView control programmatically to a data source. The page given below contains a DetailsView that is bound to a collection of products.

<%@ 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">

    Public Class Product
        Public id As String
        Public name As String
        Public company As Boolean

        Public ReadOnly Property id_id() As String
            Get
                Return id
            End Get
        End Property

        Public ReadOnly Property name_name() As String
            Get
                Return name
            End Get
        End Property

        Public ReadOnly Property company_company() As String
            Get
                Return company
            End Get
        End Property

        Public Sub New(ByVal id_id As String, ByVal name_name As String, ByVal company_company As String)
            id = id_id
            name = name_name
            company = company_company
        End Sub
    End Class

    Private Sub Page_Load()
       
        Dim NewProducts As New Product("1", "HDD", "Intel")
        Dim pro As New ListBox(Of Product)()
        pro.Add(NewProducts)

        dtlProducts.DataSource = pro
        dtlProducts.DataBind()
    End Sub

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
    <asp:DetailsView
        id="dtlProducts"
        Runat="server" />

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


In above example, an Product class is defined, which contains properties for the product  like id, name and company. In thePage_Load() method, a new product is created and added to a generic collection. This collection is bound to the DetailsView control. 

Note: Continue in Next Part. 

Comments

Post a Comment

Popular posts from this blog

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 »

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 »