001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.OleDb"%>
003.<%@ Page Language="C#" Debug="true" %>
004.<script runat="server">
005.
006. OleDbConnection objConn;
007. OleDbCommand objCmd;
008.
009. void Page_Load(object sender,EventArgs e)
010. {
011. String strConnString;
012. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
013. Server.MapPath("database/mydatabase.mdb") + ";";
014. objConn = new OleDbConnection(strConnString);
015. objConn.Open();
016.
017. BindData();
018. }
019.
020. void BindData()
021. {
022. String strSQL;
023. strSQL = "SELECT * FROM customer";
024.
025. OleDbDataReader dtReader;
026. objCmd = new OleDbCommand(strSQL, objConn);
027. dtReader = objCmd.ExecuteReader();
028.
029.
030. myListView.DataSource = dtReader;
031. myListView.DataBind();
032.
033. dtReader.Close();
034. dtReader = null;
035.
036. }
037.
038. void Page_UnLoad()
039. {
040. objConn.Close();
041. objConn = null;
042. }
043.
044.</script>
045.<html>
046.<head>
047.<title>ThaiCreate.Com ASP.NET - ListView</title>
048.</head>
049.<body>
050. <form id="form1" runat="server">
051. <asp:ListView ID="myListView" runat="server" DataKeyNames="CustomerID">
052.
053. <LayoutTemplate>
054. <table>
055. <tr>
056. <td>
057. <table runat="server" border="1">
058. <tr>
059. <th runat="server">
060. CustomerID</th>
061. <th runat="server">
062. Name</th>
063. <th runat="server">
064. Email</th>
065. <th runat="server">
066. CountryCode</th>
067. <th runat="server">
068. Budget</th>
069. <th runat="server">
070. Used</th>
071. </tr>
072. <tr ID="itemPlaceholder" runat="server">
073. </tr>
074. </table>
075. </td>
076. </tr>
077. </table>
078. </LayoutTemplate>
079.
080. <ItemTemplate>
081. <tr>
082. <td>
083. <asp:Label ID="CustomerIDLabel" runat="server" Text='<%# Eval("CustomerID") %>' />
084. </td>
085. <td>
086. <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
087. </td>
088. <td>
089. <asp:Label ID="EmailLabel" runat="server" Text='<%# Eval("Email") %>' />
090. </td>
091. <td>
092. <asp:Label ID="CountryCodeLabel" runat="server" Text='<%# Eval("CountryCode") %>' />
093. </td>
094. <td>
095. <asp:Label ID="BudgetLabel" runat="server" Text='<%# Eval("Budget") %>' />
096. </td>
097. <td>
098. <asp:Label ID="UsedLabel" runat="server" Text='<%# Eval("Used") %>' />
099. </td>
100. </tr>
101. </ItemTemplate>
102.
103. </asp:ListView>
104. </form>
105.</body>
106.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
