001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.OracleClient"%>
003.<%@ Page Language="C#" Debug="true" %>
004.<script runat="server">
005. void Page_Load(object sender,EventArgs e)
006. {
007. if(!Page.IsPostBack)
008. {
009. BindData();
010. }
011. }
012.
013. void BindData()
014. {
015. OracleConnection objConn = new OracleConnection();
016. OracleCommand objCmd = new OracleCommand();
017. OracleDataAdapter dtAdapter = new OracleDataAdapter();
018. DataSet ds = new DataSet();
019. String strConnString,strSQL;
020.
021. strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;";
022. strSQL = "SELECT * FROM customer";
023.
024. objConn.ConnectionString = strConnString;
025. objCmd.Connection = objConn;
026. objCmd.CommandText = strSQL ;
027. objCmd.CommandType = CommandType.Text;
028.
029. dtAdapter.SelectCommand = objCmd;
030.
031. dtAdapter.Fill(ds);
032.
033.
034. myGridView.DataSource = ds;
035. myGridView.DataBind();
036.
037. dtAdapter = null;
038. objConn.Close();
039. objConn = null;
040.
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. void ShowPageCommand(Object s, GridViewPageEventArgs e)
089. {
090. myGridView.PageIndex = e.NewPageIndex;
091. BindData();
092. }
093.
094.</script>
095.<html>
096.<head>
097.<title>ThaiCreate.Com ASP.NET - Oracle</title>
098.</head>
099.<body>
100. <form id="form1" runat="server">
101. <asp:GridView id="myGridView" PageSize="2"
102. OnPageIndexChanging="ShowPageCommand"
103. onRowDataBound="myGridView_RowDataBound"
104. AutoGenerateColumns="False" AllowPaging="True" runat="server">
105. <HeaderStyle BackColor="#cccccc"></HeaderStyle>
106. <AlternatingRowStyle BackColor="#e8e8e8"></AlternatingRowStyle>
107.
108. <Columns>
109.
110. <asp:TemplateField HeaderText="CustomerID">
111. <ItemTemplate>
112. <asp:Label id="lblCustomerID" runat="server"></asp:Label>
113. </ItemTemplate>
114. </asp:TemplateField>
115.
116. <asp:TemplateField HeaderText="Name">
117. <ItemTemplate>
118. <asp:Label id="lblName" runat="server"></asp:Label>
119. </ItemTemplate>
120. </asp:TemplateField>
121.
122. <asp:TemplateField HeaderText="Email">
123. <ItemTemplate>
124. <asp:Label id="lblEmail" runat="server"></asp:Label>
125. </ItemTemplate>
126. </asp:TemplateField>
127.
128. <asp:TemplateField HeaderText="CountryCode">
129. <ItemTemplate>
130. <asp:Label id="lblCountryCode" runat="server"></asp:Label>
131. </ItemTemplate>
132. </asp:TemplateField>
133.
134. <asp:TemplateField HeaderText="Budget">
135. <ItemTemplate>
136. <asp:Label id="lblBudget" runat="server"></asp:Label>
137. </ItemTemplate>
138. </asp:TemplateField>
139.
140. <asp:TemplateField HeaderText="Used">
141. <ItemTemplate>
142. <asp:Label id="lblUsed" runat="server"></asp:Label>
143. </ItemTemplate>
144. </asp:TemplateField>
145.
146. </Columns>
147.
148. </asp:GridView>
149. </form>
150.</body>
151.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
