01.<%@ Import Namespace="System.Data"%>
02.<%@ Import Namespace="System.Data.SqlClient"%>
03.<%@ Page Language="C#" Debug="true" %>
04.<script runat="server">
05.
06. System.Data.SqlClient.SqlConnection objConn;
07. System.Data.SqlClient.SqlCommand objCmd;
08.
09. void Page_Load(object sender, EventArgs e)
10. {
11. String strConnString;
12. strConnString = "Server=localhost;UID=sa;PASSWORD=;database=mydatabase;Max Pool Size=400;Connect Timeout=600;";
13.
14. objConn = new System.Data.SqlClient.SqlConnection(strConnString);
15. objConn.Open();
16.
17. BindData();
18. }
19.
20. void BindData()
21. {
22. String strSQL;
23. strSQL = "SELECT * FROM customer";
24.
25. System.Data.SqlClient.SqlDataReader dtReader;
26. objCmd = new System.Data.SqlClient.SqlCommand(strSQL, objConn);
27. dtReader = objCmd.ExecuteReader();
28.
29.
30. myRepeater.DataSource = dtReader;
31. myRepeater.DataBind();
32.
33. dtReader.Close();
34. dtReader = null;
35.
36. }
37.
38. void Page_UnLoad()
39. {
40. objConn.Close();
41. objConn = null;
42. }
43.
44.</script>
45.<html>
46.<head>
47.<title>ThaiCreate.Com ASP.NET - System.Data.Odbc</title>
48.</head>
49.<body>
50. <form id="form1" runat="server">
51. <asp:Repeater id="myRepeater" runat="server">
52. <HeaderTemplate>
53. <table border="1">
54. <tr>
55. <th>CustomerID</th>
56. <th>Name</th>
57. <th>Email</th>
58. <th>CountryCode</th>
59. <th>Budget</th>
60. <th>Used</th>
61. </tr>
62. </HeaderTemplate>
63. <ItemTemplate>
64. <tr>
65. <td align="center"><%# DataBinder.Eval(Container.DataItem, "CustomerID") %></td>
66. <td><%# DataBinder.Eval(Container.DataItem, "Name") %></td>
67. <td><%# DataBinder.Eval(Container.DataItem, "Email") %></td>
68. <td align="center"><%# DataBinder.Eval(Container.DataItem, "CountryCode") %></td>
69. <td align="right"><%# DataBinder.Eval(Container.DataItem, "Budget") %></td>
70. <td align="right"><%# DataBinder.Eval(Container.DataItem, "Used") %></td>
71. </tr>
72. </ItemTemplate>
73. </asp:Repeater>
74. </form>
75.</body>
76.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
