Đang chuẩn bị liên kết để tải về tài liệu:
ODP .NET Developer's Guide oracle database 10g development with visual studio 2005 phần 4

Creating an Oracle Table Dynamically Using ODP.NET - Bạn có thể làm việc với hầu như bất kỳ lệnh DDL bằng cách sử dụng cùng một phương pháp bạn đã sử dụng trước đó tức là ExecuteNonQuery với OracleCommand. Chúng tôi chỉ có thể thay thế DML lệnh chúng tôi sử dụng trước đó với một lệnh DDL. Ví dụ sau đây tạo ra một bảng trong cơ sở dữ liệu | Chapter 4 Creating an Oracle Table Dynamically Using ODP.NET You can work with almost any DDL command using the same method you used previously i.e. ExecuteNonQuery with OracleCommand. We can just replace the DML command we used earlier with a DDL command. The following example creates a table in Oracle database dynamically from within .NET Private Sub btnCreateTable_Click ByVal sender As System.Object ByVal e As System.EventArgs Handles btnCreateTable.Click create connection to db Dim cn As New OracleConnection Data Source xe _ User Id scott Password tiger Try Dim SQL As String build the CREATE TABLE statement Dim sb As New System.Text.StringBuilder sb.Append CREATE TABLE MyEmp sb.Append sb.Append empno NUMBER 4 sb.Append ename VARCHAR2 20 sb.Append SQL sb.ToString create command object Dim cmd As New OracleCommand SQL cn open the connection cmd.Connection.Open execute the DDL command cmd.ExecuteNonQuery close the connection cmd.Connection.Close display the result MessageBox.Show Succesfully created Catch ex As Exception display if any error occurs MessageBox.Show Error ex.Message close the connection if it is still open If cn.State ConnectionState.Open Then cn.Close End If End Try End Sub 81 Manipulating Data in Oracle Using ODP.NET Updating Offline Data to the Database Using OracleDataAdapter When you use OracleDataAdapter you will generally fill information into either a dataset or data table. A dataset or data table resides in client memory offline without having any connection to Oracle database. You can make changes to the data available at the client in offline mode and finally update all of those modifications to the database using the Update method of OracleDataAdapter. The following is a demonstration which adds a new row to a data table in offline mode and later updates it to the database using the Update method Private Sub btnDatasetUpdate_Click ByVal sender As System.Object ByVal e As System.EventArgs Handles btnDatasetUpdate.Click create connection .