01.<%@ Import Namespace="System.Data"%>
02.<%@ Import Namespace="System.Data.OracleClient"%>
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.OracleClient.OracleConnection objConn;
14. System.Data.OracleClient.OracleCommand objCmd;
15. String strConnString,strSQL;
16.
17. strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;";
18.
19. objConn = new System.Data.OracleClient.OracleConnection(strConnString);
20. objConn.Open();
21.
22.
23. strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " +
24. "VALUES (:sCustomerID,:sName,:sEmail,:sCountryCode,:sBudget,:sUsed)";
25.
26. objCmd = new System.Data.OracleClient.OracleCommand(strSQL,objConn);
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39. objCmd.Parameters.Add(new OracleParameter(":sCustomerID","C005"));
40. objCmd.Parameters.Add(new OracleParameter(":sName","Weerachai Nukitram"));
41. objCmd.Parameters.Add(new OracleParameter(":sEmail","webmaster:thaicreate.com"));
42. objCmd.Parameters.Add(new OracleParameter(":sCountryCode","TH"));
43. objCmd.Parameters.Add(new OracleParameter(":sBudget","2000000"));
44. objCmd.Parameters.Add(new OracleParameter(":sUsed","1000000"));
45.
46.
47. objCmd.ExecuteNonQuery();
48.
49. lblText.Text = lblText.Text + "- Record Inserted";
50.
51.
52. /*
53. strSQL = "UPDATE customer SET Budget = :sBudget " +
54. " WHERE CustomerID = :sCustomerID ";
55.
56. objCmd = new System.Data.OracleClient.OracleCommand(strSQL,objConn);
57. objCmd.Parameters.Add(new OracleParameter(":sBudget","4000000"));
58. objCmd.Parameters.Add(new OracleParameter(":sCustomerID","C005"));
59. objCmd.ExecuteNonQuery();
60. */
61.
62.
63.
64. /*
65. strSQL = "DELETE FROM customer " +
66. " WHERE CustomerID = :sCustomerID ";
67.
68. objCmd = new System.Data.OracleClient.OracleCommand(strSQL,objConn);
69. objCmd.Parameters.Add(new OracleParameter(":sCustomerID","C005"));
70.
71. objCmd.ExecuteNonQuery();
72. */
73.
74. objCmd = null;
75. objConn.Close();
76. objConn = null;
77. }
78.
79.
80.</script>
81.<html>
82.<head>
83.<title>ThaiCreate.Com ASP.NET - System.Data.OracleClient</title>
84.</head>
85.<body>
86. <form id="form1" runat="server">
87. <asp:Label id="lblText" runat="Server"></asp:Label>
88. </form>
89.</body>
90.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
