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.
08. void Page_Load(object sender,EventArgs e)
09. {
10. String strConnString;
11. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
12. Server.MapPath("database/mydatabase.mdb") + ";";
13. objConn = new OleDbConnection(strConnString);
14. objConn.Open();
15.
16. BindData();
17. }
18.
19. void BindData()
20. {
21. String strSQL;
22. strSQL = "SELECT * FROM customer";
23.
24. OleDbDataReader dtReader;
25. objCmd = new OleDbCommand(strSQL, objConn);
26. dtReader = objCmd.ExecuteReader();
27.
28.
29. myGridView.DataSource = dtReader;
30. myGridView.DataBind();
31.
32. dtReader.Close();
33. dtReader = null;
34.
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 - GridView</title>
47.</head>
48.<body>
49. <form id="form1" runat="server" >
50. <asp:GridView id="myGridView" runat="server">
51. <HeaderStyle BackColor="#cccccc"></HeaderStyle>
52. <AlternatingRowStyle BackColor="#F7F7F7" />
53. </asp:GridView>
54. </form>
55.</body>
56.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
