01.<%@ Import Namespace="System.Data"%>
02.<%@ Import Namespace="MySql.Data.MySqlClient"%>
03.<%@ Page Language="C#" Debug="true" %>
04.<script runat="server">
05.
06. MySqlConnection objConn;
07. MySqlCommand objCmd;
08.
09. void Page_Load(object sender,EventArgs e)
10. {
11. String strConnString;
12. strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false";
13. objConn = new MySqlConnection(strConnString);
14. objConn.Open();
15.
16. BindData();
17. }
18.
19. void BindData()
20. {
21. String strSQL;
22. strSQL = "SELECT * FROM customer";
23.
24. MySqlDataReader dtReader;
25. objCmd = new MySqlCommand(strSQL, objConn);
26. dtReader = objCmd.ExecuteReader();
27.
28.
29. myRepeater.DataSource = dtReader;
30. myRepeater.DataBind();
31.
32. dtReader.Close();
33. dtReader = null;
34.
35. }
36.
37. void Page_UnLoad()
38. {
39. objConn.Close();
40. objConn = null;
41. }
42.
43.</script>
44.<html>
45.<head>
46.<title>ThaiCreate.Com ASP.NET - MySql</title>
47.</head>
48.<body>
49. <form id="form1" runat="server">
50. <asp:Repeater id="myRepeater" runat="server">
51. <HeaderTemplate>
52. <table border="1">
53. <tr>
54. <th>CustomerID</th>
55. <th>Name</th>
56. <th>Email</th>
57. <th>CountryCode</th>
58. <th>Budget</th>
59. <th>Used</th>
60. </tr>
61. </HeaderTemplate>
62. <ItemTemplate>
63. <tr>
64. <td align="center"><asp:Label id="lblCustomerID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerID") %>'></asp:Label></td>
65. <td><asp:Label id="lblName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Name") %>'></asp:Label></td>
66. <td><asp:Label id="lblEmail" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Email") %>'></asp:Label></td>
67. <td align="center"><asp:Label id="lblCountryCode" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CountryCode") %>'></asp:Label></td>
68. <td align="right"><asp:Label id="lblBudget" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Budget") %>'></asp:Label></td>
69. <td align="right"><asp:Label id="lblUsed" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Used") %>'></asp:Label></td>
70. </tr>
71. </ItemTemplate>
72. <AlternatingItemTemplate>
73. <tr bgcolor="#e8e8e8">
74. <td align="center"><asp:Label id="lblCustomerID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerID") %>'></asp:Label></td>
75. <td><asp:Label id="lblName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Name") %>'></asp:Label></td>
76. <td><asp:Label id="lblEmail" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Email") %>'></asp:Label></td>
77. <td align="center"><asp:Label id="lblCountryCode" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CountryCode") %>'></asp:Label></td>
78. <td align="right"><asp:Label id="lblBudget" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Budget") %>'></asp:Label></td>
79. <td align="right"><asp:Label id="lblUsed" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Used") %>'></asp:Label></td>
80. </tr>
81. </AlternatingItemTemplate>
82. </asp:Repeater>
83. </form>
84.</body>
85.</html>
Load balance : Server 03
