web 2.0

VB.NET & System.Data.OracleClient - ExecuteNonQuery()

VB.NET & System.Data.OracleClient - ExecuteNonQuery() - How to learn Connector/NET ADO.NET component  System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle data source, Using the ExecuteNonQuery method for Executes a Transact-SQL statement  (Insert/Update/Delete) data  and returns the number of rows affected. (Oracle Server Database)

ShotDev Focus:
- VB.NET & System.Data.OracleClient - ExecuteNonQuery()

Example

ExecuteNonQuery.aspx

  1. <%@ Import Namespace="System.Data"%>  
  2. <%@ Import Namespace="System.Data.OracleClient"%>  
  3. <%@ Page Language="VB" %>  
  4. <script runat="server">  
  5.   
  6. Sub Page_Load(sender As Object, e As EventArgs)  
  7. Sample1()  
  8. 'Sample2()  
  9. End Sub  
  10.   
  11. Sub Sample1()  
  12.   
  13. Dim objConn As System.Data.OracleClient.OracleConnection  
  14. Dim objCmd As System.Data.OracleClient.OracleCommand  
  15. Dim strConnString,strSQL As String  
  16.   
  17. strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;"  
  18. objConn = New System.Data.OracleClient.OracleConnection(strConnString)  
  19. objConn.Open()  
  20.   
  21. strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _  
  22. "VALUES ('C005','Weerachai Nukitram','webmaster@shotdev.com','TH','2000000','1000000')"  
  23.   
  24. objCmd = New System.Data.OracleClient.OracleCommand()  
  25. With objCmd  
  26. .Connection = objConn  
  27. .CommandType = CommandType.Text  
  28. .CommandText = strSQL  
  29. End With  
  30. objCmd.ExecuteNonQuery()  
  31.   
  32. lblText.Text = "Record Insert Sucessful."  
  33.   
  34. objCmd = Nothing  
  35. objConn.Close()  
  36. objConn = Nothing  
  37.   
  38. End Sub  
  39.   
  40. Sub Sample2()  
  41.   
  42. Dim objConn As System.Data.OracleClient.OracleConnection  
  43. Dim objCmd As System.Data.OracleClient.OracleCommand  
  44. Dim strConnString,strSQL As String  
  45.   
  46. strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;"  
  47. objConn = New System.Data.OracleClient.OracleConnection(strConnString)  
  48. objConn.Open()  
  49.   
  50. strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _  
  51. "VALUES ('C005','Weerachai Nukitram','webmaster@shotdev.com','TH','2000000','1000000')"  
  52.   
  53. objCmd = New System.Data.OracleClient.OracleCommand(strSQL,objConn)  
  54.   
  55. Try  
  56. objCmd.ExecuteNonQuery()  
  57. lblText.Text = "Record Insert Sucessful."  
  58. Catch ex As Exception  
  59. lblText.Text = "Record Cannot Insert : Error (" & ex.Message & ")"  
  60. End Try  
  61.   
  62. objCmd = Nothing  
  63. objConn.Close()  
  64. objConn = Nothing  
  65.   
  66. End Sub  
  67.   
  68. </script>  
  69. <html>  
  70. <head>  
  71. <title>ShotDev.Com Tutorial</title>  
  72. </head>  
  73. <body>  
  74. <form id="form1" runat="server">  
  75. <asp:Label id="lblText" runat="Server"></asp:Label>  
  76. </form>  
  77. </body>  
  78. </html>  

Screenshot

VB.NET & System.Data.OracleClient - ExecuteNonQuery()
.
.
.
Download this script.
Download

1 Star2 Stars3 Stars4 Stars5 Stars6 Stars7 Stars8 Stars9 Stars10 Stars (No Ratings Yet)
Loading ... Loading ...

One Response to “VB.NET & System.Data.OracleClient - ExecuteNonQuery()”

  1. 3putrefaction…

Leave a Reply

You must be logged in to post a comment.