Untuk membuat tabel seperti gambar di atas, biasanya pada ASP .NET menggunakan komponen datagrid atau viewgrid. Saya akan menjelaskan secara lengkap urutan pembuatannya mulai dari desain dan code-nya. Dalam hal ini, saya masih menggunakan tools developer Ms Visual Studio Team Suite 2008. Agar tabel berisi data-data yang memiliki banyak record, maka data-data tersebut diambil dari tabel yang ada dalam database. Dalam hal ini, saya menggunakan Oracle 10g XE sebagai database-nya. Perhatikan dengan seksama setiap langkah-langkah di bawah ini :
Jika Anda tidak mau mengunduh file query-nya, bisa copy paste query di bawah ini :
CREATE TABLE tb_countries
(
id_countries INT PRIMARY KEY NOT NULL,
country_code char(2) NOT NULL,
country_name varchar(100) NOT NULL
);
BEGIN
INSERT INTO tb_countries VALUES (1, 'US', 'United States');
INSERT INTO tb_countries VALUES (2, 'CA', 'Canada');
INSERT INTO tb_countries VALUES (3, 'AF', 'Afghanistan');
INSERT INTO tb_countries VALUES (4, 'AL', 'Albania');
INSERT INTO tb_countries VALUES (5, 'DZ', 'Algeria');
INSERT INTO tb_countries VALUES (6, 'DS', 'American Samoa');
INSERT INTO tb_countries VALUES (7, 'AD', 'Andorra');
INSERT INTO tb_countries VALUES (8, 'AO', 'Angola');
INSERT INTO tb_countries VALUES (9, 'AI', 'Anguilla');
INSERT INTO tb_countries VALUES (10, 'AQ', 'Antarctica');
INSERT INTO tb_countries VALUES (11, 'AG', 'Antigua and/or Barbuda');
INSERT INTO tb_countries VALUES (12, 'AR', 'Argentina');
INSERT INTO tb_countries VALUES (13, 'AM', 'Armenia');
INSERT INTO tb_countries VALUES (14, 'AW', 'Aruba');
INSERT INTO tb_countries VALUES (15, 'AU', 'Australia');
INSERT INTO tb_countries VALUES (16, 'AT', 'Austria');
INSERT INTO tb_countries VALUES (17, 'AZ', 'Azerbaijan');
INSERT INTO tb_countries VALUES (18, 'BS', 'Bahamas');
INSERT INTO tb_countries VALUES (19, 'BH', 'Bahrain');
INSERT INTO tb_countries VALUES (20, 'BD', 'Bangladesh');
INSERT INTO tb_countries VALUES (21, 'BB', 'Barbados');
INSERT INTO tb_countries VALUES (22, 'BY', 'Belarus');
INSERT INTO tb_countries VALUES (23, 'BE', 'Belgium');
INSERT INTO tb_countries VALUES (24, 'BZ', 'Belize');
INSERT INTO tb_countries VALUES (25, 'BJ', 'Benin');
INSERT INTO tb_countries VALUES (26, 'BM', 'Bermuda');
INSERT INTO tb_countries VALUES (27, 'BT', 'Bhutan');
INSERT INTO tb_countries VALUES (28, 'BO', 'Bolivia');
INSERT INTO tb_countries VALUES (29, 'BA', 'Bosnia and Herzegovina');
INSERT INTO tb_countries VALUES (30, 'BW', 'Botswana');
INSERT INTO tb_countries VALUES (31, 'BV', 'Bouvet Island');
INSERT INTO tb_countries VALUES (32, 'BR', 'Brazil');
INSERT INTO tb_countries VALUES (33, 'IO', 'British lndian Ocean Territory');
INSERT INTO tb_countries VALUES (34, 'BN', 'Brunei Darussalam');
INSERT INTO tb_countries VALUES (35, 'BG', 'Bulgaria');
INSERT INTO tb_countries VALUES (36, 'BF', 'Burkina Faso');
INSERT INTO tb_countries VALUES (37, 'BI', 'Burundi');
INSERT INTO tb_countries VALUES (38, 'KH', 'Cambodia');
INSERT INTO tb_countries VALUES (39, 'CM', 'Cameroon');
INSERT INTO tb_countries VALUES (40, 'CV', 'Cape Verde');
INSERT INTO tb_countries VALUES (41, 'KY', 'Cayman Islands');
INSERT INTO tb_countries VALUES (42, 'CF', 'Central African Republic');
INSERT INTO tb_countries VALUES (43, 'TD', 'Chad');
INSERT INTO tb_countries VALUES (44, 'CL', 'Chile');
INSERT INTO tb_countries VALUES (45, 'CN', 'China');
INSERT INTO tb_countries VALUES (46, 'CX', 'Christmas Island');
INSERT INTO tb_countries VALUES (47, 'CC', 'Cocos (Keeling) Islands');
INSERT INTO tb_countries VALUES (48, 'CO', 'Colombia');
INSERT INTO tb_countries VALUES (49, 'KM', 'Comoros');
INSERT INTO tb_countries VALUES (50, 'CG', 'Congo');
INSERT INTO tb_countries VALUES (51, 'CK', 'Cook Islands');
INSERT INTO tb_countries VALUES (52, 'CR', 'Costa Rica');
INSERT INTO tb_countries VALUES (53, 'HR', 'Croatia (Hrvatska)');
INSERT INTO tb_countries VALUES (54, 'CU', 'Cuba');
INSERT INTO tb_countries VALUES (55, 'CY', 'Cyprus');
INSERT INTO tb_countries VALUES (56, 'CZ', 'Czech Republic');
INSERT INTO tb_countries VALUES (57, 'DK', 'Denmark');
INSERT INTO tb_countries VALUES (58, 'DJ', 'Djibouti');
INSERT INTO tb_countries VALUES (59, 'DM', 'Dominica');
INSERT INTO tb_countries VALUES (60, 'DO', 'Dominican Republic');
INSERT INTO tb_countries VALUES (61, 'TP', 'East Timor');
INSERT INTO tb_countries VALUES (62, 'EC', 'Ecudaor');
INSERT INTO tb_countries VALUES (63, 'EG', 'Egypt');
INSERT INTO tb_countries VALUES (64, 'SV', 'El Salvador');
INSERT INTO tb_countries VALUES (65, 'GQ', 'Equatorial Guinea');
INSERT INTO tb_countries VALUES (66, 'ER', 'Eritrea');
INSERT INTO tb_countries VALUES (67, 'EE', 'Estonia');
INSERT INTO tb_countries VALUES (68, 'ET', 'Ethiopia');
INSERT INTO tb_countries VALUES (69, 'FK', 'Falkland Islands (Malvinas)');
INSERT INTO tb_countries VALUES (70, 'FO', 'Faroe Islands');
INSERT INTO tb_countries VALUES (71, 'FJ', 'Fiji');
INSERT INTO tb_countries VALUES (72, 'FI', 'Finland');
INSERT INTO tb_countries VALUES (73, 'FR', 'France');
INSERT INTO tb_countries VALUES (74, 'FX', 'France, Metropolitan');
INSERT INTO tb_countries VALUES (75, 'GF', 'French Guiana');
INSERT INTO tb_countries VALUES (76, 'PF', 'French Polynesia');
INSERT INTO tb_countries VALUES (77, 'TF', 'French Southern Territories');
INSERT INTO tb_countries VALUES (78, 'GA', 'Gabon');
INSERT INTO tb_countries VALUES (79, 'GM', 'Gambia');
INSERT INTO tb_countries VALUES (80, 'GE', 'Georgia');
INSERT INTO tb_countries VALUES (81, 'DE', 'Germany');
INSERT INTO tb_countries VALUES (82, 'GH', 'Ghana');
INSERT INTO tb_countries VALUES (83, 'GI', 'Gibraltar');
INSERT INTO tb_countries VALUES (84, 'GR', 'Greece');
INSERT INTO tb_countries VALUES (85, 'GL', 'Greenland');
INSERT INTO tb_countries VALUES (86, 'GD', 'Grenada');
INSERT INTO tb_countries VALUES (87, 'GP', 'Guadeloupe');
INSERT INTO tb_countries VALUES (88, 'GU', 'Guam');
INSERT INTO tb_countries VALUES (89, 'GT', 'Guatemala');
INSERT INTO tb_countries VALUES (90, 'GN', 'Guinea');
INSERT INTO tb_countries VALUES (91, 'GW', 'Guinea-Bissau');
INSERT INTO tb_countries VALUES (92, 'GY', 'Guyana');
INSERT INTO tb_countries VALUES (93, 'HT', 'Haiti');
INSERT INTO tb_countries VALUES (94, 'HM', 'Heard and Mc Donald Islands');
INSERT INTO tb_countries VALUES (95, 'HN', 'Honduras');
INSERT INTO tb_countries VALUES (96, 'HK', 'Hong Kong');
INSERT INTO tb_countries VALUES (97, 'HU', 'Hungary');
INSERT INTO tb_countries VALUES (98, 'IS', 'Iceland');
INSERT INTO tb_countries VALUES (99, 'IN', 'India');
INSERT INTO tb_countries VALUES (100, 'ID', 'Indonesia');
INSERT INTO tb_countries VALUES (101, 'IR', 'Iran (Islamic Republic of)');
INSERT INTO tb_countries VALUES (102, 'IQ', 'Iraq');
INSERT INTO tb_countries VALUES (103, 'IE', 'Ireland');
INSERT INTO tb_countries VALUES (104, 'IL', 'Israel');
INSERT INTO tb_countries VALUES (105, 'IT', 'Italy');
INSERT INTO tb_countries VALUES (106, 'CI', 'Ivory Coast');
INSERT INTO tb_countries VALUES (107, 'JM', 'Jamaica');
INSERT INTO tb_countries VALUES (108, 'JP', 'Japan');
INSERT INTO tb_countries VALUES (109, 'JO', 'Jordan');
INSERT INTO tb_countries VALUES (110, 'KZ', 'Kazakhstan');
INSERT INTO tb_countries VALUES (111, 'KE', 'Kenya');
INSERT INTO tb_countries VALUES (112, 'KI', 'Kiribati');
INSERT INTO tb_countries VALUES (113, 'KP', 'Korea, Democratic People''s Republic of');
INSERT INTO tb_countries VALUES (114, 'KR', 'Korea, Republic of');
INSERT INTO tb_countries VALUES (115, 'KW', 'Kuwait');
INSERT INTO tb_countries VALUES (116, 'KG', 'Kyrgyzstan');
INSERT INTO tb_countries VALUES (117, 'LA', 'Lao People''s Democratic Republic');
INSERT INTO tb_countries VALUES (118, 'LV', 'Latvia');
INSERT INTO tb_countries VALUES (119, 'LB', 'Lebanon');
INSERT INTO tb_countries VALUES (120, 'LS', 'Lesotho');
INSERT INTO tb_countries VALUES (121, 'LR', 'Liberia');
INSERT INTO tb_countries VALUES (122, 'LY', 'Libyan Arab Jamahiriya');
INSERT INTO tb_countries VALUES (123, 'LI', 'Liechtenstein');
INSERT INTO tb_countries VALUES (124, 'LT', 'Lithuania');
INSERT INTO tb_countries VALUES (125, 'LU', 'Luxembourg');
INSERT INTO tb_countries VALUES (126, 'MO', 'Macau');
INSERT INTO tb_countries VALUES (127, 'MK', 'Macedonia');
INSERT INTO tb_countries VALUES (128, 'MG', 'Madagascar');
INSERT INTO tb_countries VALUES (129, 'MW', 'Malawi');
INSERT INTO tb_countries VALUES (130, 'MY', 'Malaysia');
INSERT INTO tb_countries VALUES (131, 'MV', 'Maldives');
INSERT INTO tb_countries VALUES (132, 'ML', 'Mali');
INSERT INTO tb_countries VALUES (133, 'MT', 'Malta');
INSERT INTO tb_countries VALUES (134, 'MH', 'Marshall Islands');
INSERT INTO tb_countries VALUES (135, 'MQ', 'Martinique');
INSERT INTO tb_countries VALUES (136, 'MR', 'Mauritania');
INSERT INTO tb_countries VALUES (137, 'MU', 'Mauritius');
INSERT INTO tb_countries VALUES (138, 'TY', 'Mayotte');
INSERT INTO tb_countries VALUES (139, 'MX', 'Mexico');
INSERT INTO tb_countries VALUES (140, 'FM', 'Micronesia, Federated States of');
INSERT INTO tb_countries VALUES (141, 'MD', 'Moldova, Republic of');
INSERT INTO tb_countries VALUES (142, 'MC', 'Monaco');
INSERT INTO tb_countries VALUES (143, 'MN', 'Mongolia');
INSERT INTO tb_countries VALUES (144, 'MS', 'Montserrat');
INSERT INTO tb_countries VALUES (145, 'MA', 'Morocco');
INSERT INTO tb_countries VALUES (146, 'MZ', 'Mozambique');
INSERT INTO tb_countries VALUES (147, 'MM', 'Myanmar');
INSERT INTO tb_countries VALUES (148, 'NA', 'Namibia');
INSERT INTO tb_countries VALUES (149, 'NR', 'Nauru');
INSERT INTO tb_countries VALUES (150, 'NP', 'Nepal');
INSERT INTO tb_countries VALUES (151, 'NL', 'Netherlands');
INSERT INTO tb_countries VALUES (152, 'AN', 'Netherlands Antilles');
INSERT INTO tb_countries VALUES (153, 'NC', 'New Caledonia');
INSERT INTO tb_countries VALUES (154, 'NZ', 'New Zealand');
INSERT INTO tb_countries VALUES (155, 'NI', 'Nicaragua');
INSERT INTO tb_countries VALUES (156, 'NE', 'Niger');
INSERT INTO tb_countries VALUES (157, 'NG', 'Nigeria');
INSERT INTO tb_countries VALUES (158, 'NU', 'Niue');
INSERT INTO tb_countries VALUES (159, 'NF', 'Norfork Island');
INSERT INTO tb_countries VALUES (160, 'MP', 'Northern Mariana Islands');
INSERT INTO tb_countries VALUES (161, 'NO', 'Norway');
INSERT INTO tb_countries VALUES (162, 'OM', 'Oman');
INSERT INTO tb_countries VALUES (163, 'PK', 'Pakistan');
INSERT INTO tb_countries VALUES (164, 'PW', 'Palau');
INSERT INTO tb_countries VALUES (165, 'PA', 'Panama');
INSERT INTO tb_countries VALUES (166, 'PG', 'Papua New Guinea');
INSERT INTO tb_countries VALUES (167, 'PY', 'Paraguay');
INSERT INTO tb_countries VALUES (168, 'PE', 'Peru');
INSERT INTO tb_countries VALUES (169, 'PH', 'Philippines');
INSERT INTO tb_countries VALUES (170, 'PN', 'Pitcairn');
INSERT INTO tb_countries VALUES (171, 'PL', 'Poland');
INSERT INTO tb_countries VALUES (172, 'PT', 'Portugal');
INSERT INTO tb_countries VALUES (173, 'PR', 'Puerto Rico');
INSERT INTO tb_countries VALUES (174, 'QA', 'Qatar');
INSERT INTO tb_countries VALUES (175, 'RE', 'Reunion');
INSERT INTO tb_countries VALUES (176, 'RO', 'Romania');
INSERT INTO tb_countries VALUES (177, 'RU', 'Russian Federation');
INSERT INTO tb_countries VALUES (178, 'RW', 'Rwanda');
INSERT INTO tb_countries VALUES (179, 'KN', 'Saint Kitts and Nevis');
INSERT INTO tb_countries VALUES (180, 'LC', 'Saint Lucia');
INSERT INTO tb_countries VALUES (181, 'VC', 'Saint Vincent and the Grenadines');
INSERT INTO tb_countries VALUES (182, 'WS', 'Samoa');
INSERT INTO tb_countries VALUES (183, 'SM', 'San Marino');
INSERT INTO tb_countries VALUES (184, 'ST', 'Sao Tome and Principe');
INSERT INTO tb_countries VALUES (185, 'SA', 'Saudi Arabia');
INSERT INTO tb_countries VALUES (186, 'SN', 'Senegal');
INSERT INTO tb_countries VALUES (187, 'SC', 'Seychelles');
INSERT INTO tb_countries VALUES (188, 'SL', 'Sierra Leone');
INSERT INTO tb_countries VALUES (189, 'SG', 'Singapore');
INSERT INTO tb_countries VALUES (190, 'SK', 'Slovakia');
INSERT INTO tb_countries VALUES (191, 'SI', 'Slovenia');
INSERT INTO tb_countries VALUES (192, 'SB', 'Solomon Islands');
INSERT INTO tb_countries VALUES (193, 'SO', 'Somalia');
INSERT INTO tb_countries VALUES (194, 'ZA', 'South Africa');
INSERT INTO tb_countries VALUES (195, 'GS', 'South Georgia South Sandwich Islands');
INSERT INTO tb_countries VALUES (196, 'ES', 'Spain');
INSERT INTO tb_countries VALUES (197, 'LK', 'Sri Lanka');
INSERT INTO tb_countries VALUES (198, 'SH', 'St. Helena');
INSERT INTO tb_countries VALUES (199, 'PM', 'St. Pierre and Miquelon');
INSERT INTO tb_countries VALUES (200, 'SD', 'Sudan');
INSERT INTO tb_countries VALUES (201, 'SR', 'Suriname');
INSERT INTO tb_countries VALUES (202, 'SJ', 'Svalbarn and Jan Mayen Islands');
INSERT INTO tb_countries VALUES (203, 'SZ', 'Swaziland');
INSERT INTO tb_countries VALUES (204, 'SE', 'Sweden');
INSERT INTO tb_countries VALUES (205, 'CH', 'Switzerland');
INSERT INTO tb_countries VALUES (206, 'SY', 'Syrian Arab Republic');
INSERT INTO tb_countries VALUES (207, 'TW', 'Taiwan');
INSERT INTO tb_countries VALUES (208, 'TJ', 'Tajikistan');
INSERT INTO tb_countries VALUES (209, 'TZ', 'Tanzania, United Republic of');
INSERT INTO tb_countries VALUES (210, 'TH', 'Thailand');
INSERT INTO tb_countries VALUES (211, 'TG', 'Togo');
INSERT INTO tb_countries VALUES (212, 'TK', 'Tokelau');
INSERT INTO tb_countries VALUES (213, 'TO', 'Tonga');
INSERT INTO tb_countries VALUES (214, 'TT', 'Trinidad and Tobago');
INSERT INTO tb_countries VALUES (215, 'TN', 'Tunisia');
INSERT INTO tb_countries VALUES (216, 'TR', 'Turkey');
INSERT INTO tb_countries VALUES (217, 'TM', 'Turkmenistan');
INSERT INTO tb_countries VALUES (218, 'TC', 'Turks and Caicos Islands');
INSERT INTO tb_countries VALUES (219, 'TV', 'Tuvalu');
INSERT INTO tb_countries VALUES (220, 'UG', 'Uganda');
INSERT INTO tb_countries VALUES (221, 'UA', 'Ukraine');
INSERT INTO tb_countries VALUES (222, 'AE', 'United Arab Emirates');
INSERT INTO tb_countries VALUES (223, 'GB', 'United Kingdom');
INSERT INTO tb_countries VALUES (224, 'UM', 'United States minor outlying islands');
INSERT INTO tb_countries VALUES (225, 'UY', 'Uruguay');
INSERT INTO tb_countries VALUES (226, 'UZ', 'Uzbekistan');
INSERT INTO tb_countries VALUES (227, 'VU', 'Vanuatu');
INSERT INTO tb_countries VALUES (228, 'VA', 'Vatican City State');
INSERT INTO tb_countries VALUES (229, 'VE', 'Venezuela');
INSERT INTO tb_countries VALUES (230, 'VN', 'Vietnam');
INSERT INTO tb_countries VALUES (231, 'VG', 'Virigan Islands (British)');
INSERT INTO tb_countries VALUES (232, 'VI', 'Virgin Islands (U.S.)');
INSERT INTO tb_countries VALUES (233, 'WF', 'Wallis and Futuna Islands');
INSERT INTO tb_countries VALUES (234, 'EH', 'Western Sahara');
INSERT INTO tb_countries VALUES (235, 'YE', 'Yemen');
INSERT INTO tb_countries VALUES (236, 'YU', 'Yugoslavia');
INSERT INTO tb_countries VALUES (237, 'ZR', 'Zaire');
INSERT INTO tb_countries VALUES (238, 'ZM', 'Zambia');
INSERT INTO tb_countries VALUES (239, 'ZW', 'Zimbabwe');
end;
SELECT * FROM tb_countriesLangkah #2, Membuat File Project
Sebelum memulai penulisan code script programnya, alangkah baiknya kita membuat suatu file project. Saya membuat suatu solution yang diberi nama TestProject. Kemudian, buat 3 buah project pada solution Testproject tadi yang diberi nama WebApp, BussinessLayer, dan DataAccessLayer. Pada project WebApp tadi pilih ASP .NET Web Application yang berekstensikan *.ASPX dengan code behind yang berkestensikan *.CS. Sedangkan pada project BussinessLayer dan DataAccessLayer pilih Class Library dengan code behind yang berkestensikan *.CS. Untuk lebih jelasnya mengenai ini, Anda bisa lihat artikel saya tentang
Bagaimana Bekerja dengan Ms Visual Studio ?.
Langkah #3, Membuat Template Halaman Web
Pada project WebApp, klik saja file Default.ASPX dan isi dengan code html berikut :
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApp._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Test Datagrid Paging</title>
<link href="../Include/Css/Styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div class="lbltext">
<table width="100%">
<tbody>
<tr>
<td align="left" style="width:10%"><asp:Label ID="lblSearch" runat="server" Text="Search By"></asp:Label></td>
<td align="left" style="width:15%">
<asp:DropDownList ID="ddlSearchBy" runat="server" Width="100%">
</asp:DropDownList>
</td>
<td align="left" style="width:25%"><asp:TextBox ID="txtSearchBy" runat="server" Width="90%"></asp:TextBox></td>
<td align="left" style="width:55%"></td>
</tr>
</tbody>
</table>
<asp:Button ID="btnReset" runat="server" Text="Reset"/>
<asp:Button ID="btnSearch" runat="server" Text="Search"/>
<table width="100%">
<tbody>
<tr>
<th align="center" colspan="3" class="headertable" >
<asp:Label ID="lblHeader" runat="server" Text="COUNTRIES"></asp:Label>
</th>
</tr>
<tr>
<td>
<asp:DataGrid ID="dtgData" runat="server" Width="100%" AutoGenerateColumns="False"
CssClass="auto-style2" HeaderStyle-BackColor="#eaf9df" ItemStyle-CssClass="tdganjil"
AlternatingItemStyle-CssClass="tdgenap" AllowPaging="true">
<AlternatingItemStyle CssClass="tdgenap" />
<ItemStyle CssClass="tdganjil" />
<Columns>
<asp:TemplateColumn HeaderText="No">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:Label ID="lblNum" runat="server"
Text='<%# DataBinder.Eval(Container.DataItem,"No") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Code">
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:Label ID="lblCode" runat="server"
Text='<%# DataBinder.Eval(Container.DataItem,"Code") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Countries Name">
<HeaderStyle HorizontalAlign="Center" Width="60%" />
<ItemStyle HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblCountries" runat="server"
Text='<%# DataBinder.Eval(Container.DataItem,"Countries Name") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<HeaderStyle CssClass="atmSubHeader" />
</asp:DataGrid>
</td>
</tr>
<tr>
<td class="footerTable"></td>
</tr>
<tr>
<td>
<table width="100%">
<tbody>
<tr>
<td align="center" width="4%">
<asp:ImageButton ID="ImgFirst" runat="server"
ImageUrl="../Images/ForwardPrev_icon.png" onclick="ImgFirst_Click" />
</td>
<td align="center" width="4%">
<asp:ImageButton ID="ImgPrev" runat="server" ImageUrl="../Images/prev_icon.png"
onclick="ImgPrev_Click"/>
</td>
<td align="center" width="4%">
<asp:ImageButton ID="ImgNext" runat="server" ImageUrl="../Images/next_icon.png"
onclick="ImgNext_Click"/>
</td>
<td align="center" width="4%">
<asp:ImageButton ID="ImgLast" runat="server"
ImageUrl="../Images/ForwardNext_icon.png" onclick="ImgLast_Click"/>
</td>
<td align="center" width="5%">
<asp:Label ID="lblPage" runat="server" Text="Page"></asp:Label>
</td>
<td align="left" width="3%">
<asp:TextBox ID="txtPage" runat="server" Width="30px"></asp:TextBox>
</td>
<td align="center" width="3%">
<asp:Button ID="btnGo" runat="server" Text="GO" onclick="btnGo_Click" ></asp:Button>
</td>
<td align="left" width="15%">
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtPage" ValidationExpression="^[0-9]+$"
ErrorMessage="Only Number" Display="Dynamic"></asp:RegularExpressionValidator>
</td>
<td align="right" width="59%">
<asp:Label ID="txtInfoTable" runat="server" Text=""></asp:Label>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</form>
</body>
</html>
cari folder TestProject dimana project kamu disimpan, kemudian pada folder WebApp, buat folder baru dengan nama Include. Dan didalam folder Include tadi buat folder Css. Kembali ke Ms Visual Studio pada project webApp tambahkan item stylesheet atau css dan simpan dalam folder Css tadi. Jangan lupa menambahkan References untuk folder tersebut agar dikenali. Isi dengan Script css berikut :
body
{
}
td
{
border-color : #e8e3e9;
}
th.headertable
{
background-color:#90bbf6;
-moz-border-radius-topleft: 10px;
-moz-border-radius-topright: 10px;
-webkit-border-top-left-radius: 10px;
-webkit-border-top-right-radius: 10px;
-khtml-border-radius-topleft: 10px;
-khtml-border-radius-topright: 10px;
border-top-left-radius: 10px;
border-top-right-radius: 10px;
font-family: Verdana, Arial, Tahoma, sans-serif;
font-size: 11px;
height:20px;
}
td.footerTable
{
background-color:#90bbf6;
-moz-border-radius-bottomleft: 10px;
-moz-border-radius-bottomright: 10px;
-webkit-border-bottom-left-radius: 10px;
-webkit-border-bottom-right-radius: 10px;
-khtml-border-radius-bottomleft: 10px;
-khtml-border-radius-bottomright: 10px;
border-bottom-left-radius: 10px;
border-bottom-right-radius: 10px;
height : 10px;
}
td.leftcolumn
{
background-color:#F4F4F4;
}
tr.style1
{
height:25px;
padding: 10px;
border:solid 1px #E7E3E7;
}
.lbltext
{
font-family: Verdana, Arial, Tahoma, sans-serif;
font-size: 11px;
}
td .rowdate
{
display:inline;
}
#btnSearch
{
margin-right:10px;
}
#btnReset, #btnSearch
{
float:right;
font: Bold 12px Cal Black;
padding:5px;
margin-top:20px;
margin-bottom:20px;
width:80px;
}
.atmHeader {
font: bold 10pt Tahoma,Verdana ;
color: #FFFFFF;
}
.atmSubheader
{
font: bold 10pt Tahoma,Verdana ;
background-color:#C5DBE6;
}
.tdganjil {
background: #FFFFFF;
}
.tdgenap {
background: #C5DBE6;
}
.auto-style1 {
background: #f4faff;
text-align: left;
font: Arial;
}
.auto-style2 {
border-collapse : collapse;
border: 1px solid #e7e3e7;
background: #FFFFFF;
font: 9pt Arial, Helvetica, sans-serif;
color: #000000;
}
.auto-style3 {
background: #eaf9df;
text-align: left;
color: #000000;
border-collapse : collapse;
border: 1px solid #e7e3e7;
font: bold 9pt Arial, Helvetica, sans-serif;
}
Langkah #4, Koneksi ke database Oracle 10g XE
Hal yang paling penting adalah bagaimana membuat suatu koneksi ke database
