GridView Control in ASP.NET - Part 5


Using Fields with GridView Control

As to solve some of problems like enabling the GridView to render its columns automatically is that we give up any control over column formatting. For example, the BoxOfficeTotals column is displayed as a decimal amount without any currency formatting. The EnTRyDatecolumn always displays in short-date and long-time format. The solution to such problems is to specify explicitly the fields that a GridView displays. The GridView control supports the following types of fields:
·         BoundField Enables us to display the value of a data item as text.
·         CheckBoxField Enables us to display the value of a data item as a check box.
·         CommandField Enables us to display links for editing, deleting, and selecting rows.
·         ButtonField Enables us to display the value of a data item as a button (image button, link button, or push button).
·         HyperLinkField Enables us to display the value of a data item as a link.
·         ImageField Enables us to display the value of a data item as an image.
·         TemplateField Enables us to customize the appearance of a data item.

Using CommandFields

We use CommandField to customize the appearance of the Edit, Delete, Update, Cancel and Select buttons displayed by the GridView control by default. We can change these all control by own. Let’s take a look.



<%@ 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 runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:GridView
        ID="GridView1"
        runat="server"
        AutoGenerateColumns="False"
        DataSourceID="SqlDataSource1"
        EmptyDataText="There are no data records to display."
        Width="788px"
        DataKeyNames="ID">
            <Columns>
                <asp:BoundField
                DataField="ID"
                HeaderText="ID"
                SortExpression="ID" />
                <asp:BoundField
                DataField="NAME"
                HeaderText="NAME"
                SortExpression="NAME" />
                <asp:BoundField
                DataField="ADDRESS"
                HeaderText="ADDRESS"
                SortExpression="ADDRESS" />
                <asp:BoundField
                DataField="MOBILE"
                HeaderText="MOBILE"
                SortExpression="MOBILE" />
                <asp:CommandField
            ButtonType="Image"
            ShowEditButton="true"
            EditText="Edit Movie"
            EditImageUrl="~/images/edit.GIF"
            UpdateText="Update Movie"
            updateimageurl="~/images/update.GIF"
            ShowCancelButton="true"
            CancelText="Cancel Edit"
            cancelimageurl="~/images/cancel.GIF"
            ShowDeleteButton="true"
            DeleteText="Delete Movie"
            Deleteimageurl="~/images/delete.GIF"/>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
            DeleteCommand="DELETE FROM MYTB WHERE ID=@ID"
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
            SelectCommand="SELECT [ID], [NAME], [ADDRESS], [MOBILE] FROM [MYTB]"
            UpdateCommand="UPDATE MYTB SET ID =@ID, NAME =@NAME, ADDRESS =@ADDRESS, MOBILE =@MOBILE WHERE ID=@ID">
        </asp:SqlDataSource>
   
    </div>
    </form>
</body>
</html>


Notice that we do not enable the AutoGenerateEditButton or AutoGenerateDeleteButton properties when using a CommandField. Instead, we use the CommandField to set up the standard editing buttons explicitly.
The CommandField supports the following properties:
·         ButtonType Enables we to specify the type of button displayed by the CommandField. Possible values are Button, Image, andLink.
·         CancelImageUrl Enables we to specify an image to display for the Cancel button.
·         CancelText Enables we to specify the text to display for the Cancel button.
·         CausesValidation Enables we to disable validation when an edit button is clicked.
·         DeleteImageUrl Enables we to specify an image to display for the Delete button.
·         DeleteText Enables we to specify the text to display for the Delete button.
·         EditImageUrl Enables we to specify an image to display for the Edit button.
·         EditText Enables we to specify the text to display for the Edit button.
·         InsertImageUrl Enables we to specify an image to display for the Insert button.
·         InsertText Enables we to specify the text to display for the Insert button.
·         NewImageUrl Enables we to specify an image to display for the New button (does not apply to GridView).
·         NewText Enables we to specify the text to display for the New button.
·         SelectImageUrl Enables we to specify the image to display for the Select button.
·         SelectText Enables we to specify the text to display for the Select button.
·         ShowCancelButton Enables we to display the Cancel button.
·         ShowDeleteButton Enables we to display the Delete button.
·         ShowEditButton Enables we to display the Edit button.
·         ShowInsertButton Enables we to display the Insert button (does not apply to GridView).
·         ShowSelectButton Enables we to display the Select button.
·         UpdateImageUrl Enables we to specify the image to display for the Update button.
·         UpdateText Enables we to specify the text to display for the Update button.
·         ValidationGroup Enables we to associate the edit buttons with a validation group.

 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 »

Lambda two tables and three tables inner join code samples

In this blog post you will learn inner join using lambda queries. There will be two samples, in first sample you will see how you can join two tables and in second sample you will see how you can extend even further to join three tables and so on. I will sample in-memory data, but the same implementation will work with IQueryable (lazy query) too. Here's the code snippet:- namespace ConsoleApp1 {     class Program     {         static void Main()         {             var table1 = new List<Table1>();             table1.Add( new Table1 { Id = 1, Name = "Name 1" , Address = "Address 1" });             table1.Add( new Table1 { Id = 2, Name = "Name 2" , Address = "Address 2" });             table1.Add( new Table1 { Id = 3, Name = "Name 3" , Address = "Address 3" });             table1.Add( new Table1 { Id = 4, Name = "Name 4" , Address = "Address 4" });   
Read More »