GridView Control in ASP.NET: Part 3

Posted by Abhimanyu K Vatsa Articles | Visual Basic .NET November 10, 2012
In this article we will discuss how to use BoundField in GridView.
Reader Level:
Download Files:
 

Please you do read earlier parts of this article for complete understanding in GridView.

Part - 2

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 EnTRyDate column 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 valueof a data item as an image.
  • TemplateField Enables us to customize the appearance of a data item. 

Using BoundField

A BoundField always displays the value of a data item as text when a row is in normal display mode. When a row is selected for editing, a BoundField displays the value of a data item in a single line text field. The most important three properties of the BoundField class are the DataField, DataFormatString, and HeaderText properties.

GridView1.gif

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

        <asp:GridView ID="GridView1" 
        runat="server" 
        AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1" 
        EmptyDataText="There are no data records to display." 
        Width="495px">
            <Columns>
                <asp:BoundField 
                DataField="ID" 
                HeaderText="Serial Number" 
                SortExpression="ID"/>
                <asp:BoundField 
                DataField="NAME" 
                HeaderText="Name of Candidate" 
                SortExpression="NAME" />
                <asp:BoundField 
                DataField="ADDRESS" 
                HeaderText="Address of Candidate" 
                SortExpression="ADDRESS" />
                <asp:BoundField 
                DataField="MOBILE" 
                HeaderText="MOBILE" 
                SortExpression="MOBILE" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>" 
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>" 
            SelectCommand="SELECT [ID], [NAME], [ADDRESS], [MOBILE] FROM [MYTB]">
        </asp:SqlDataSource>

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

Notice that the GridView control includes an AutoGenerateColumns property that is assigned the value False. If we don't disable automatically generated columns, then both columns represented by the BoundFields and all the columns from the data source are displayed redundantly. BoundFields also supports several useful properties as listed below.

  • AccessibleHeaderText Enables we to add an HTML abbr attribute to the column header.
  • ApplyFormatInEditMode Enables us to apply the DataFormatString to the field when the row is in edit display mode.
  • ConvertEmptyStringToNull Enables we to convert an empty string "" into the value Nothing (null) when editing a column.
  • DataField Enables we to specify the name of the field that the BoundField displays.
  • DataFormatString Enables we to use a format string to format a data item.
  • FooterStyle Enables we to format the column footer.
  • FooterText Enables we to display text in the column footer.
  • HeaderImageUrl Enables we to display an image in the column header.
  • HeaderStyle Enables we to format the column header.
  • HeaderText Enables we to display text in the column header.
  • HtmlEncode Enables we to HTML-encode the value of a data item, which enables you to avoid script injection attacks.
  • InsertVisible Enables we to not display a column when inserting a new record (does not apply to the GridView control).
  • ItemStyle Enables we to format a data item.
  • NullDisplayText Enables we to specify textthat is displayed when a data item has the value Nothing (null).
  • ReadOnly Enables we to prevent the data item from being edited in edit mode.
  • ShowHeader Enables we to display the column header.
  • SortExpression Enables we to associate a sort expression with the column.
  • Visible Enables we to hide a column.

Note: Continue in Next Part.

HAVE A GREAT CODING!

COMMENT USING

Trending up