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. int strGalleryID = 2;
08.
09. void Page_Load(object sender,EventArgs e)
10. {
11. String strConnString;
12. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
13. Server.MapPath("database/mydatabase.mdb") + ";";
14. objConn = new OleDbConnection(strConnString);
15. objConn.Open();
16.
17. BindData();
18. }
19.
20. void BindData()
21. {
22. String strSQL;
23. strSQL = "SELECT * FROM gallery WHERE GalleryID = " + strGalleryID;
24.
25. OleDbDataReader dtReader;
26. objCmd = new OleDbCommand(strSQL, objConn);
27. dtReader = objCmd.ExecuteReader();
28.
29.
30. myFormView.DataSource = dtReader;
31. myFormView.DataBind();
32.
33. dtReader.Close();
34. dtReader = null;
35. }
36.
37. void Page_UnLoad()
38. {
39. objConn.Close();
40. objConn = null;
41. }
42.
43.</script>
44.<html>
45.<head>
46.<title>ThaiCreate.Com ASP.NET - FormView</title>
47.</head>
48.<body>
49. <form id="form1" runat="server">
50. <asp:FormView id="myFormView" runat="server">
51. <ItemTemplate>
52. <table width="500" cellpadding="5" border="0">
53. <tr>
54. <td valign="top" align="center">
55. <asp:Image id="Image1" runat="server" ImageUrl='<%# Eval("Picture", "images/{0}") %>' />
56. <br />
57. <h2><%# DataBinder.Eval(Container.DataItem, "GalleryName") %></h2>
58. </td>
59. </tr>
60. </table>
61. </ItemTemplate>
62. </asp:FormView>
63. </form>
64.</body>
65.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
