Đ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 6

Uploading Images to Oracle Database Using BLOB - Nó rất đơn giản để tải lên thông tin BLOB vào cơ sở dữ liệu Oracle. Tất cả chúng ta cần phải làm được đọc toàn bộ tập tin (trong các hình thức byte) và sử dụng OracleParameter cùng với OracleCommand để tải nó lên. | Chapter 6 The following is an illustration of a sample form designed to work with BLOB images 149 Dealing with Large Objects LOBs The following is an illustration of a sample form designed to work with BLOB documents Uploading Images to Oracle Database Using BLOB It is very simple to upload BLOB information into Oracle database. All we need to do is read the entire file in the form of bytes and use Oracleparameter together with OracleCommand to upload it. 150 Chapter 6 The following code uploads an image into the EmpImages table Private Sub btnAdd_Click ByVal sender As System.Object ByVal e As System.EventArgs Handles btnAdd.Click If Me.txtImageFile.Text.Trim.Length 0 Then MessageBox.Show No file chosen Exit Sub End If Now read the entire file into a string Dim contents As Byte _ File.ReadAllBytes Me.txtlmageFile.Text create connection to db Dim cn As New OracleConnection Data Source xe _ User Id scott Password tiger Try create command object Dim sb As New System.Text.StringBuilder sb.Append INSERT INTO EmpImages sb.Append empno image sb.Append VALUES sb.Append 1 2 Dim cmd As New OracleCommand With cmd .CommandText sb.ToString define parameters Dim p_empno As New OracleParameter 1 _ OracleDbType.Int16 p_empno.Value Me.txtEmpno.Text Dim p_img As New OracleParameter 2 _ OracleDbType.Blob p_img.Size contents.Length p_img.Value contents .Parameters.Add p_empno .Parameters.Add p_img proceed with execution .Connection cn .Connection.Open .ExecuteNonQuery .Connection.Close .Dispose End With 151