001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.OleDb"%>
003.<%@ Page Language="C#" Debug="true" %>
004.<script runat="server">
005.
006. void Page_Load(object sender,EventArgs e)
007. {
008. if(!Page.IsPostBack)
009. {
010. BindData();
011. }
012. }
013.
014. void BindData()
015. {
016. OleDbConnection objConn = new OleDbConnection();
017. OleDbCommand objCmd = new OleDbCommand();
018. OleDbDataAdapter dtAdapter = new OleDbDataAdapter();
019. DataSet ds = new DataSet();
020. String strConnString,strSQL;
021.
022. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
023. Server.MapPath("database/mydatabase.mdb") + ";";
024. strSQL = "SELECT * FROM customer";
025.
026. objConn.ConnectionString = strConnString;
027. objCmd.Connection = objConn;
028. objCmd.CommandText = strSQL;
029. objCmd.CommandType = CommandType.Text;
030.
031. dtAdapter.SelectCommand = objCmd;
032.
033. dtAdapter.Fill(ds);
034.
035.
036. myDetailsView.DataSource = ds;
037. myDetailsView.DataBind();
038.
039. dtAdapter = null;
040. objConn.Close();
041. objConn = null;
042.
043. }
044.
045. void ShowPageCommand(Object sender, DetailsViewPageEventArgs e)
046. {
047. myDetailsView.PageIndex = e.NewPageIndex;
048. BindData();
049. }
050.
051.</script>
052.<html>
053.<head>
054.<title>ThaiCreate.Com ASP.NET - DetailsView</title>
055.</head>
056.<body>
057. <form id="form1" runat="server">
058. <asp:DetailsView id="myDetailsView" runat="server"
059. AutoGenerateRows="False" AllowPaging="True"
060. OnPageIndexChanging="ShowPageCommand">
061.
062. <Fields>
063. <asp:TemplateField HeaderText="CustomerID">
064. <ItemTemplate>
065. <asp:Label id="lblCustomerID" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CustomerID") %>'></asp:Label>
066. </ItemTemplate>
067. </asp:TemplateField>
068.
069. <asp:TemplateField HeaderText="Name">
070. <ItemTemplate>
071. <asp:Label id="lblName" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Name") %>'></asp:Label>
072. </ItemTemplate>
073. </asp:TemplateField>
074.
075. <asp:TemplateField HeaderText="Email">
076. <ItemTemplate>
077. <asp:Label id="lblEmail" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Email") %>'></asp:Label>
078. </ItemTemplate>
079. </asp:TemplateField>
080.
081. <asp:TemplateField HeaderText="CountryCode">
082. <ItemTemplate>
083. <asp:Label id="lblCountryCode" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CountryCode") %>'></asp:Label>
084. </ItemTemplate>
085. </asp:TemplateField>
086.
087. <asp:TemplateField HeaderText="Budget">
088. <ItemTemplate>
089. <asp:Label id="lblBudget" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Budget") %>'></asp:Label>
090. </ItemTemplate>
091. </asp:TemplateField>
092.
093. <asp:TemplateField HeaderText="Used">
094. <ItemTemplate>
095. <asp:Label id="lblUsed" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Used") %>'></asp:Label>
096. </ItemTemplate>
097. </asp:TemplateField>
098.
099. </Fields>
100.
101. </asp:DetailsView>
102. </form>
103.</body>
104.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
