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 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 value of a data item as an image.
-
TemplateField
Enables us to customize the appearance of a data item.
Using HyperLinkField
Introduction & Demonstration
We use a HyperLinkField to create a link to another page. Assume an example;
we have two database tables named MAIN and DETAILS. MAIN table consist only
fields like ID, NAME, ADDRESS, CONTACT and DETAILS. DETAILS table consist
fields like ID, MONEY and SALARY. Now we have two forms named MAIN.aspx and
DETAILS.aspx. MAIN.aspx will display MAIN table's data and DETAILS.aspx will
display DETAILS table's data. Now we want a HyperLink in each record in
MAIN.aspx form and when use will click on that link it will redirect to
DETAILS.aspx page and it will only consist the data based on the ID what you
have clicked on MAIN.aspx page. If you run directly DETAILS.aspx page it
will not show you any data because it has no parameter passed. Take a look
on development.
Here is MAIN.aspx Page:
<%@ 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="653px">
<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="CONTACT"
HeaderText="CONTACT"
SortExpression="CONTACT" />
<asp:HyperLinkField
HeaderText="DETAILS"
DataTextField="DETAILS"
DataNavigateUrlFields="ID"
DataNavigateUrlFormatString="DETAILS.aspx?id={0}" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
SelectCommand="SELECT
[ID], [NAME], [ADDRESS], [CONTACT], [DETAILS] FROM [MAIN]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
Here is DETAILS.aspx Page:
<%@ 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"
DataSourceID="SqlDataSource1"
EmptyDataText="There
are no data records to display."
Width="248px">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
SelectCommand="SELECT
[ID], [MONEY], [SALARY] FROM [DETAILS] WHERE ID=@ID">
<SelectParameters>
<asp:QueryStringParameter
Name="ID"
QueryStringField="ID" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
Note: Continue
in Next Part.
HAVE A GREAT CODING!