01.<%@ Import Namespace="System.Data"%>
02.<%@ Import Namespace="System.Data.OleDb"%>
03.<%@ Page Language="C#" Debug="true" %>
04.<script runat="server">
05. OleDbConnection objConn;
06. OleDbCommand objCmd;
07.
08. void Page_Load(object sender,EventArgs e)
09. {
10. String strConnString;
11. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
12. Server.MapPath("database/mydatabase.mdb") + ";";
13. objConn = new OleDbConnection(strConnString);
14. objConn.Open();
15.
16. BindData();
17. }
18.
19. void BindData()
20. {
21. String strSQL;
22. strSQL = "SELECT * FROM category";
23.
24. OleDbDataReader dtReader;
25. objCmd = new OleDbCommand(strSQL, objConn);
26. dtReader = objCmd.ExecuteReader();
27.
28.
29. myDataList.DataSource = dtReader;
30. myDataList.DataBind();
31.
32. dtReader.Close();
33. dtReader = null;
34. }
35.
36. void Page_UnLoad()
37. {
38. objConn.Close();
39. objConn = null;
40. }
41.
42.</script>
43.<html>
44.<head>
45.<title>ThaiCreate.Com ASP.NET - DataList</title>
46.</head>
47.<body>
48. <form id="form1" runat="server">
49. <asp:DataList id="myDataList" RepeatColumns="2" runat="server">
50. <HeaderTemplate>
51. <b>My Category</b>
52. </HeaderTemplate>
53. <ItemTemplate>
54. <div style="width:100px" align="center">
55. <img src="<%# DataBinder.Eval(Container.DataItem, "Picture") %>">
56. <br />
57. <%# DataBinder.Eval(Container.DataItem, "CategoryName") %>
58. </div>
59. </ItemTemplate>
60. <SeparatorTemplate>
61. <hr />
62. </SeparatorTemplate>
63. </asp:DataList>
64. </form>
65.</body>
66.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
Load balance : Server 00
