01.<%@ Import Namespace="System.Data"%>
02.<%@ Import Namespace="System.Data.OleDb"%>
03.<%@ Page Language="C#" Debug="true" %>
04.<script runat="server">
05.
06. void Page_Load(object sender, EventArgs e)
07. {
08. Sample1();
09. }
10.
11. void Sample1()
12. {
13. System.Data.OleDb.OleDbConnection objConn;
14. System.Data.OleDb.OleDbCommand objCmd;
15. String strConnString,strSQL;
16.
17. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
18. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
19.
20. objConn = new System.Data.OleDb.OleDbConnection(strConnString);
21. objConn.Open();
22.
23.
24. strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " +
25. "VALUES (@sCustomerID,@sName,@sEmail,@sCountryCode,@sBudget,@sUsed)";
26.
27. objCmd = new System.Data.OleDb.OleDbCommand(strSQL,objConn);
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40. objCmd.Parameters.Add(new OleDbParameter("@sCustomerID","C005"));
41. objCmd.Parameters.Add(new OleDbParameter("@sName","Weerachai Nukitram"));
42. objCmd.Parameters.Add(new OleDbParameter("@sEmail","webmaster@thaicreate.com"));
43. objCmd.Parameters.Add(new OleDbParameter("@sCountryCode","TH"));
44. objCmd.Parameters.Add(new OleDbParameter("@sBudget","2000000"));
45. objCmd.Parameters.Add(new OleDbParameter("@sUsed","1000000"));
46.
47.
48. objCmd.ExecuteNonQuery();
49.
50. lblText.Text = lblText.Text + "- Record Inserted";
51.
52.
53. /*
54. strSQL = "UPDATE customer SET Budget = @sBudget " +
55. " WHERE CustomerID = @sCustomerID ";
56.
57. objCmd = new System.Data.OleDb.OleDbCommand(strSQL,objConn);
58. objCmd.Parameters.Add(new OleDbParameter("@sBudget","4000000"));
59. objCmd.Parameters.Add(new OleDbParameter("@sCustomerID","C005"));
60. objCmd.ExecuteNonQuery();
61. */
62.
63.
64.
65. /*
66. strSQL = "DELETE FROM customer " +
67. " WHERE CustomerID = @sCustomerID ";
68.
69. objCmd = new System.Data.OleDb.OleDbCommand(strSQL,objConn);
70. objCmd.Parameters.Add(new OleDbParameter("@sCustomerID","C005"));
71.
72. objCmd.ExecuteNonQuery();
73. */
74.
75. objCmd = null;
76. objConn.Close();
77. objConn = null;
78. }
79.
80.
81.</script>
82.<html>
83.<head>
84.<title>ThaiCreate.Com ASP.NET - System.Data.OleDb</title>
85.</head>
86.<body>
87. <form id="form1" runat="server">
88. <asp:Label id="lblText" runat="Server"></asp:Label>
89. </form>
90.</body>
91.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
