01.using System;
02.using System.Data;
03.using System.Configuration;
04.using System.Collections;
05.using System.Web;
06.using System.Web.Security;
07.using System.Web.UI;
08.using System.Web.UI.WebControls;
09.using System.Web.UI.WebControls.WebParts;
10.using System.Web.UI.HtmlControls;
11.using System.Data.OracleClient;
12.
13.public partial class Repeater1 : System.Web.UI.Page
14.{
15. OracleConnection objConn;
16. OracleCommand objCmd;
17.
18. protected void Page_Load(object sender, EventArgs e)
19. {
20. String strConnString;
21. strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;";
22. objConn = new OracleConnection(strConnString);
23. objConn.Open();
24.
25. BindData();
26. }
27.
28. protected void BindData()
29. {
30. String strSQL;
31. strSQL = "SELECT * FROM customer";
32.
33. OracleDataReader dtReader;
34. objCmd = new OracleCommand(strSQL, objConn);
35. dtReader = objCmd.ExecuteReader();
36.
37.
38. myRepeater.DataSource = dtReader;
39. myRepeater.DataBind();
40.
41. dtReader.Close();
42. dtReader = null;
43. }
44.
45. protected void Page_UnLoad(object sender, System.EventArgs e)
46. {
47. objConn.Close();
48. objConn = null;
49. }
50.
51.}
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
