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.
· 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