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. void Page_UnLoad()
37. {
38. objConn.Close();
39. objConn = null;
40. }
41.</script>
42.<html>
43.<head>
44.<title>ThaiCreate.Com ASP.NET - GridView</title>
45.</head>
46.<body>
47. <form id="form1" runat="server">
48. <asp:GridView id="myGridView" runat="server"></asp:GridView>
49. </form>
50.</body>
51.</html>
