GridView Control in ASP.NET - Part 4
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
CheckBoxFields
A CheckBoxField, as we can
probably guess, displays a check box. When a row is not in edit mode, the check
box is displayed but it is disabled.
<%@ 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">
<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="709px">
<Columns>
<asp:CommandField ShowEditButton="True" />
<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:CheckBoxField DataField="MALE_FEMALE" HeaderText="MALE_FEMALE"
SortExpression="MALE_FEMALE" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
SelectCommand="SELECT [ID],
[NAME], [ADDRESS], [MOBILE], [MALE_FEMALE] FROM [MYTB]"
UpdateCommand="UPDATE MYTB
SET ID =@ID, NAME =@NAME, ADDRESS =@ADDRESS, MOBILE =@MOBILE, MALE_FEMALE
=@MALE_FEMALE WHERE ID=@ID">
</asp:SqlDataSource>
</div>
</div>
</form>
</body>
</html>
Note: Continue in Next Part.
Comments
Post a Comment