GridView Control in ASP.NET - Part 6
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 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.
Comments
Post a Comment