<%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.OleDb"%> <%@ Page Language="C#" Debug="true" %> <script runat="server"> OleDbConnection objConn; OleDbCommand objCmd; void Page_Load(object sender,EventArgs e) { String strConnString; strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("database/mydatabase.mdb") + ";"; objConn = new OleDbConnection(strConnString); objConn.Open(); BindData(); } void BindData() { String strSQL; strSQL = "SELECT * FROM customer"; OleDbDataReader dtReader; objCmd = new OleDbCommand(strSQL, objConn); dtReader = objCmd.ExecuteReader(); //*** BindData to ListView ***// myListView.DataSource = dtReader; myListView.DataBind(); dtReader.Close(); dtReader = null; } void Page_UnLoad() { objConn.Close(); objConn = null; } </script> <html> <head> <title>ThaiCreate.Com ASP.NET - ListView</title> </head> <body> <form id="form1" runat="server"> <asp:ListView ID="myListView" runat="server" DataKeyNames="CustomerID"> <LayoutTemplate> <table> <tr> <td> <table runat="server" border="1"> <tr> <th runat="server"> CustomerID</th> <th runat="server"> Name</th> <th runat="server"> Email</th> <th runat="server"> CountryCode</th> <th runat="server"> Budget</th> <th runat="server"> Used</th> </tr> <tr ID="itemPlaceholder" runat="server"> </tr> </table> </td> </tr> </table> </LayoutTemplate> <ItemTemplate> <tr> <td> <asp:Label ID="CustomerIDLabel" runat="server" Text='<%# Eval("CustomerID") %>' /> </td> <td> <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="EmailLabel" runat="server" Text='<%# Eval("Email") %>' /> </td> <td> <asp:Label ID="CountryCodeLabel" runat="server" Text='<%# Eval("CountryCode") %>' /> </td> <td> <asp:Label ID="BudgetLabel" runat="server" Text='<%# Eval("Budget") %>' /> </td> <td> <asp:Label ID="UsedLabel" runat="server" Text='<%# Eval("Used") %>' /> </td> </tr> </ItemTemplate> </asp:ListView> </form> </body> </html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท