<%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.OleDb"%> <%@ Page Language="VB" %> <script runat="server"> Dim objConn As OleDbConnection Dim objCmd As OleDbCommand Sub Page_Load(sender As Object, e As EventArgs) Dim strConnString As String strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/mydatabase.mdb")&";" objConn = New OleDbConnection(strConnString) objConn.Open() BindData() End Sub Sub BindData() Dim strSQL As String strSQL = "SELECT * FROM customer" Dim dtReader As OleDbDataReader objCmd = New OleDbCommand(strSQL, objConn) dtReader = objCmd.ExecuteReader() '*** BindData to ListView ***' myListView.DataSource = dtReader myListView.DataBind() dtReader.Close() dtReader = Nothing End Sub Sub Page_UnLoad() objConn.Close() objConn = Nothing End Sub </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="lblCustomerID" runat="server" Text='<%# Eval("CustomerID") %>' /> </td> <td> <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="lblEmail" runat="server" Text='<%# Eval("Email") %>' /> </td> <td> <asp:Label ID="lblCountryCode" runat="server" Text='<%# Eval("CountryCode") %>' /> </td> <td> <asp:Label ID="lblBudget" runat="server" Text='<%# Eval("Budget") %>' /> </td> <td> <asp:Label ID="lblUsed" runat="server" Text='<%# Eval("Used") %>' /> </td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr style="background-color: #FAFAD2;color: #284775;"> <td> <asp:Label ID="lblCustomerID" runat="server" Text='<%# Eval("CustomerID") %>' /> </td> <td> <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="lblEmail" runat="server" Text='<%# Eval("Email") %>' /> </td> <td> <asp:Label ID="lblCountryCode" runat="server" Text='<%# Eval("CountryCode") %>' /> </td> <td> <asp:Label ID="lblBudget" runat="server" Text='<%# Eval("Budget") %>' /> </td> <td> <asp:Label ID="lblUsed" runat="server" Text='<%# Eval("Used") %>' /> </td> </tr> </AlternatingItemTemplate> </asp:ListView> </form> </body> </html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท
VB.NET || 
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
Load balance : Server 05
