001.<%@ Page Language="C#" Debug="true" %>
002.<%@ import Namespace="System.Data" %>
003.<%@ import Namespace="System.Data.OleDb" %>
004.<script runat="server">
005. OleDbConnection objConn;
006. OleDbCommand objCmd;
007.
008. void Page_Load(object sender,EventArgs e)
009. {
010. String strConnString;
011. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
012. Server.MapPath("database/mydatabase.mdb") + ";";
013. objConn = new OleDbConnection(strConnString);
014. objConn.Open();
015.
016. BindData();
017. }
018.
019. void BindData()
020. {
021. String strSQL;
022. strSQL = "SELECT * FROM customer";
023.
024. OleDbDataReader dtReader;
025. objCmd = new OleDbCommand(strSQL, objConn);
026. dtReader = objCmd.ExecuteReader();
027.
028.
029. myGridView.DataSource = dtReader;
030. myGridView.DataBind();
031.
032. dtReader.Close();
033. dtReader = null;
034.
035. }
036.
037. void Page_UnLoad()
038. {
039. objConn.Close();
040. objConn = null;
041. }
042.
043. void myGridView_RowDataBound(Object s, GridViewRowEventArgs e)
044. {
045.
046. Label lblCustomerID = (Label)(e.Row.FindControl("lblCustomerID"));
047. if (lblCustomerID != null)
048. {
049. lblCustomerID.Text = (string)DataBinder.Eval(e.Row.DataItem, "CustomerID");
050. }
051.
052.
053. Label lblName = (Label)(e.Row.FindControl("lblName"));
054. if (lblName != null)
055. {
056. lblName.Text = (string)DataBinder.Eval(e.Row.DataItem, "Name");
057. }
058.
059.
060. Label lblEmail = (Label)(e.Row.FindControl("lblEmail"));
061. if (lblEmail != null)
062. {
063. lblEmail.Text = (string)DataBinder.Eval(e.Row.DataItem, "Email");
064. }
065.
066.
067. Label lblCountryCode = (Label)(e.Row.FindControl("lblCountryCode"));
068. if (lblCountryCode != null)
069. {
070. lblCountryCode.Text = (string)DataBinder.Eval(e.Row.DataItem, "CountryCode");
071. }
072.
073.
074. Label lblBudget = (Label)(e.Row.FindControl("lblBudget"));
075. if (lblBudget != null)
076. {
077. lblBudget.Text = DataBinder.Eval(e.Row.DataItem, "Budget").ToString();
078. }
079.
080.
081. Label lblUsed = (Label)(e.Row.FindControl("lblUsed"));
082. if (lblUsed != null)
083. {
084. lblUsed.Text = DataBinder.Eval(e.Row.DataItem, "Used").ToString();
085. }
086.
087.
088. Label hplEdit = (HyperLink)(e.Row.FindControl("hplEdit"));
089. if (hplEdit != null)
090. {
091. hplEdit.Text = "Edit";
092. hplEdit.NavigateUrl = "WebPage.aspx?CustomerID=" + (string)DataBinder.Eval(e.Row.DataItem, "CustomerID");
093. }
094. }
095.
096.</script>
097.<html>
098.<head>
099. <title>ThaiCreate.Com ASP.NET - GridView</title>
100.</head>
101.<body>
102.<form id="form1" runat="server">
103.<asp:GridView id="myGridView" runat="server" AutoGenerateColumns="False"
104.onRowDataBound="myGridView_RowDataBound">
105.
106. <Columns>
107.
108. <asp:TemplateField HeaderText="CustomerID">
109. <ItemTemplate>
110. <asp:Label id="lblCustomerID" runat="server"></asp:Label>
111. </ItemTemplate>
112. </asp:TemplateField>
113.
114. <asp:TemplateField HeaderText="Name">
115. <ItemTemplate>
116. <asp:Label id="lblName" runat="server"></asp:Label>
117. </ItemTemplate>
118. </asp:TemplateField>
119.
120. <asp:TemplateField HeaderText="Email">
121. <ItemTemplate>
122. <asp:Label id="lblEmail" runat="server"></asp:Label>
123. </ItemTemplate>
124. </asp:TemplateField>
125.
126. <asp:TemplateField HeaderText="CountryCode">
127. <ItemTemplate>
128. <asp:Label id="lblCountryCode" runat="server"></asp:Label>
129. </ItemTemplate>
130. </asp:TemplateField>
131.
132. <asp:TemplateField HeaderText="Budget">
133. <ItemTemplate>
134. <asp:Label id="lblBudget" runat="server"></asp:Label>
135. </ItemTemplate>
136. </asp:TemplateField>
137.
138. <asp:TemplateField HeaderText="Used">
139. <ItemTemplate>
140. <asp:Label id="lblUsed" runat="server"></asp:Label>
141. </ItemTemplate>
142. </asp:TemplateField>
143.
144. <asp:TemplateField HeaderText="Edit">
145. <ItemTemplate>
146. <asp:Hyperlink id="hplEdit" runat="server"></asp:Hyperlink>
147. </ItemTemplate>
148. </asp:TemplateField>
149.
150. </Columns>
151.</asp:GridView>
152.</form>
153.</body>
154.</html>
