GeekInterview \| Geeks Forum \| Online Quiz \| Learning Center \| Privacy \| Terms and Conditions \| Contact

Home > Database > Oracle > Storing Images and PDF Files Into Oracle Blobs

Storing Images and PDF Files Into Oracle Blobs

Description:	Storing Images and PDF Files Into Oracle Blobs Using C#.NET and Oracle 9i
Date added:	20 February, 2008
Submitted By:	V.S.SANDILYA
Rating:	0
Download:	N/A
Instructions:	Program is used to design the form for inserting images into Oracle 9i Blobs
Source Code:	/* THIS PART OF THE PROGRAM IS USED TO DESIGN THE FORM FOR INSERTING IMAGES INTO ORACLE 9I BLOBS/ namespace oracleblob { partial class Form1 { /// /// Required designer variable. /// private System.ComponentModel.IContainer components = null; /// /// Clean up any resources being used. /// /// true if managed resources should be disposed; otherwise, false. protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.txtid = new System.Windows.Forms.TextBox(); this.txtname = new System.Windows.Forms.TextBox(); this.lblid = new System.Windows.Forms.Label(); this.lblempname = new System.Windows.Forms.Label(); this.btnbrowse = new System.Windows.Forms.Button(); this.BTNSAVE = new System.Windows.Forms.Button(); this.BTNCLOSE = new System.Windows.Forms.Button(); this.pctimg = new System.Windows.Forms.PictureBox(); this.CRTAB = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.pctimg)).BeginInit(); this.SuspendLayout(); // // txtid // this.txtid.Location = new System.Drawing.Point(286, 109); this.txtid.Name = "txtid"; this.txtid.Size = new System.Drawing.Size(276, 20); this.txtid.TabIndex = 0; // // txtname // this.txtname.Location = new System.Drawing.Point(286, 165); this.txtname.Name = "txtname"; this.txtname.Size = new System.Drawing.Size(276, 20); this.txtname.TabIndex = 1; // // lblid // this.lblid.AutoSize = true; this.lblid.Location = new System.Drawing.Point(213, 116); this.lblid.Name = "lblid"; this.lblid.Size = new System.Drawing.Size(38, 13); this.lblid.TabIndex = 2; this.lblid.Text = "emp id"; // // lblempname // this.lblempname.AutoSize = true; this.lblempname.Location = new System.Drawing.Point(213, 172); this.lblempname.Name = "lblempname"; this.lblempname.Size = new System.Drawing.Size(56, 13); this.lblempname.TabIndex = 3; this.lblempname.Text = "emp name"; // // btnbrowse // this.btnbrowse.Location = new System.Drawing.Point(638, 187); this.btnbrowse.Name = "btnbrowse"; this.btnbrowse.Size = new System.Drawing.Size(122, 23); this.btnbrowse.TabIndex = 4; this.btnbrowse.Text = "BROWSE"; this.btnbrowse.UseVisualStyleBackColor = true; this.btnbrowse.Click += new System.EventHandler(this.btnbrowse_Click); // // BTNSAVE // this.BTNSAVE.Location = new System.Drawing.Point(638, 249); this.BTNSAVE.Name = "BTNSAVE"; this.BTNSAVE.Size = new System.Drawing.Size(122, 23); this.BTNSAVE.TabIndex = 5; this.BTNSAVE.Text = "SAVE"; this.BTNSAVE.UseVisualStyleBackColor = true; this.BTNSAVE.Click += new System.EventHandler(this.BTNSAVE_Click); // // BTNCLOSE // this.BTNCLOSE.Location = new System.Drawing.Point(638, 311); this.BTNCLOSE.Name = "BTNCLOSE"; this.BTNCLOSE.Size = new System.Drawing.Size(122, 23); this.BTNCLOSE.TabIndex = 6; this.BTNCLOSE.Text = "CLOSE"; this.BTNCLOSE.UseVisualStyleBackColor = true; this.BTNCLOSE.Click += new System.EventHandler(this.BTNCLOSE_Click); // // pctimg // this.pctimg.Location = new System.Drawing.Point(286, 244); this.pctimg.Name = "pctimg"; this.pctimg.Size = new System.Drawing.Size(276, 168); this.pctimg.TabIndex = 7; this.pctimg.TabStop = false; // // CRTAB // this.CRTAB.Location = new System.Drawing.Point(638, 140); this.CRTAB.Name = "CRTAB"; this.CRTAB.Size = new System.Drawing.Size(122, 23); this.CRTAB.TabIndex = 8; this.CRTAB.Text = "CREATE_TABLE"; this.CRTAB.UseVisualStyleBackColor = true; this.CRTAB.Click += new System.EventHandler(this.CRTAB_Click); // // button1 // this.button1.Location = new System.Drawing.Point(638, 363); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(122, 23); this.button1.TabIndex = 9; this.button1.Text = "SEE PHOTO"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(821, 571); this.Controls.Add(this.button1); this.Controls.Add(this.CRTAB); this.Controls.Add(this.pctimg); this.Controls.Add(this.BTNCLOSE); this.Controls.Add(this.BTNSAVE); this.Controls.Add(this.btnbrowse); this.Controls.Add(this.lblempname); this.Controls.Add(this.lblid); this.Controls.Add(this.txtname); this.Controls.Add(this.txtid); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pctimg)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.TextBox txtid; private System.Windows.Forms.TextBox txtname; private System.Windows.Forms.Label lblid; private System.Windows.Forms.Label lblempname; private System.Windows.Forms.Button btnbrowse; private System.Windows.Forms.Button BTNSAVE; private System.Windows.Forms.Button BTNCLOSE; private System.Windows.Forms.PictureBox pctimg; private System.Windows.Forms.Button CRTAB; private System.Windows.Forms.Button button1; } } / this is the end of form design program / /this is the beginning of coding of image storage into oracle 9i blob / using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OracleClient; using System.IO; namespace oracleblob { public partial class Form1 : Form { OracleConnection conn; string connstr; string imagename; DataSet dset; FileStream FS; public Form1() { InitializeComponent(); } public void oracleconnection() { try { connstr="User Id=" + "hr"+ ";Password="+ "hr" + ";Data Source="+ "shanu;"; conn=new OracleConnection(connstr); conn.Open(); OracleCommand cmnd=conn.CreateCommand(); cmnd.CommandText="CREATE TABLE emp22(id INTEGER,name VARCHAR2(50),photo BLOB)"; cmnd.ExecuteNonQuery(); } catch(Exception e) { MessageBox.Show(e.Message); } } private void Form1_Load(object sender, EventArgs e) { } private void btnbrowse_Click(object sender, EventArgs e) { try { if (pctimg.Image != null) { pctimg.Image.Dispose(); } FileDialog fldlg=new OpenFileDialog(); //specify your own initial directory fldlg.InitialDirectory=@":D"; //this will allow onlt those file extensions to be added fldlg.Filter="Image File (.jpg;.bmp;.gif)\|.jpg;.bmp;.gif"; if(fldlg.ShowDialog()==DialogResult.OK) { imagename=fldlg.FileName; Bitmap newimg=new Bitmap(imagename); pctimg.SizeMode=PictureBoxSizeMode.StretchImage; pctimg.Image=(Image)newimg; } fldlg=null; } catch(System.ArgumentException ae) { imagename=" "; MessageBox.Show(ae.Message.ToString()); } catch(Exception ex) { MessageBox.Show(ex.Message.ToString()); } } private void BTNSAVE_Click(object sender, EventArgs e) { this.updatedata(); } private void BTNCLOSE_Click(object sender, EventArgs e) { this.Close(); } private void updatedata() { //use filestream object to read the image. //read to the full length of image to a byte array. //add this byte as an oracle parameter and insert it into database. try { //proceed only when the image has a valid path if(imagename!="") { FileStream fls; fls=new FileStream(@imagename,FileMode.Open,FileAccess.Read); //a byte array to read the image byte[] blob=new byte[fls.Length]; fls.Read(blob,0,System.Convert.ToInt32(fls.Length)); fls.Close(); //open the database using odp.net and insert the data connstr = "User Id=" + "hr" + ";Password=" + "hr" + ";Data Source=" + "shanu;"; conn=new OracleConnection(connstr); conn.Open(); OracleCommand cmnd; string query; query="insert into emp22(id,name,photo) values(" + txtid.Text + "," + "'" + txtname.Text + "'," + " :BlobParameter )"; //insert the byte as oracle parameter of type blob OracleParameter blobParameter = new OracleParameter(); blobParameter.OracleType = OracleType.Blob; blobParameter.ParameterName = "BlobParameter"; blobParameter.Value = blob; cmnd=new OracleCommand(query,conn); cmnd.Parameters.Add(blobParameter); cmnd.ExecuteNonQuery(); MessageBox.Show("added to blob field"); cmnd.Dispose(); conn.Close(); conn.Dispose(); } } catch(Exception ex) { MessageBox.Show(ex.Message); } } private void CRTAB_Click(object sender, EventArgs e) { oracleconnection(); } private void button1_Click(object sender, EventArgs e) { if (pctimg.Image != null) { pctimg.Image.Dispose(); } int tt = Convert.ToInt32(txtid.Text); connstr = "User Id=" + "hr" + ";Password=" + "hr" + ";Data Source=" + "shanu;"; conn = new OracleConnection(connstr); conn.Open(); OracleDataAdapter da = new OracleDataAdapter("SELECT FROM EMP22 WHERE ID=" + tt, conn); dset = new DataSet(); dset.Clear(); dset.Reset(); da.Fill(dset); FS = new FileStream("c:\image.jpg", FileMode.Create); byte[] blob = (byte[])dset.Tables[0].Rows[0].ItemArray[2]; FS.Write(blob, 0, blob.Length); FS.Close(); FS = null; pctimg.Image = Image.FromFile("c:\image.jpg"); pctimg.SizeMode = PictureBoxSizeMode.StretchImage; pctimg.Refresh(); } } } /* THIS IS THE END OF CODING OF THE IMAGE STORAGE PROGRAM / /THIS IS THE BEGGING OF THE FORMS DESIGN TO STORE PDF FILES INTO ORACLE 9i BLOBS USING C#.NET / namespace oracleblob { partial class pdf_file { /// /// Required designer variable. /// private System.ComponentModel.IContainer components = null; /// /// Clean up any resources being used. /// /// true if managed resources should be disposed; otherwise, false. protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.button1 = new System.Windows.Forms.Button(); this.CRTAB = new System.Windows.Forms.Button(); this.BTNCLOSE = new System.Windows.Forms.Button(); this.BTNSAVE = new System.Windows.Forms.Button(); this.btnbrowse = new System.Windows.Forms.Button(); this.lblempname = new System.Windows.Forms.Label(); this.lblid = new System.Windows.Forms.Label(); this.txtname = new System.Windows.Forms.TextBox(); this.txtid = new System.Windows.Forms.TextBox(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(570, 377); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(122, 23); this.button1.TabIndex = 19; this.button1.Text = "SEE PDF FILE"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // CRTAB // this.CRTAB.Location = new System.Drawing.Point(570, 154); this.CRTAB.Name = "CRTAB"; this.CRTAB.Size = new System.Drawing.Size(122, 23); this.CRTAB.TabIndex = 18; this.CRTAB.Text = "CREATE_TABLE"; this.CRTAB.UseVisualStyleBackColor = true; this.CRTAB.Click += new System.EventHandler(this.CRTAB_Click_1); // // BTNCLOSE // this.BTNCLOSE.Location = new System.Drawing.Point(570, 325); this.BTNCLOSE.Name = "BTNCLOSE"; this.BTNCLOSE.Size = new System.Drawing.Size(122, 23); this.BTNCLOSE.TabIndex = 16; this.BTNCLOSE.Text = "CLOSE"; this.BTNCLOSE.UseVisualStyleBackColor = true; this.BTNCLOSE.Click += new System.EventHandler(this.BTNCLOSE_Click); // // BTNSAVE // this.BTNSAVE.Location = new System.Drawing.Point(570, 263); this.BTNSAVE.Name = "BTNSAVE"; this.BTNSAVE.Size = new System.Drawing.Size(122, 23); this.BTNSAVE.TabIndex = 15; this.BTNSAVE.Text = "SAVE"; this.BTNSAVE.UseVisualStyleBackColor = true; this.BTNSAVE.Click += new System.EventHandler(this.BTNSAVE_Click); // // btnbrowse // this.btnbrowse.Location = new System.Drawing.Point(570, 201); this.btnbrowse.Name = "btnbrowse"; this.btnbrowse.Size = new System.Drawing.Size(122, 23); this.btnbrowse.TabIndex = 14; this.btnbrowse.Text = "BROWSE"; this.btnbrowse.UseVisualStyleBackColor = true; this.btnbrowse.Click += new System.EventHandler(this.btnbrowse_Click); // // lblempname // this.lblempname.AutoSize = true; this.lblempname.Location = new System.Drawing.Point(145, 186); this.lblempname.Name = "lblempname"; this.lblempname.Size = new System.Drawing.Size(56, 13); this.lblempname.TabIndex = 13; this.lblempname.Text = "emp name"; // // lblid // this.lblid.AutoSize = true; this.lblid.Location = new System.Drawing.Point(145, 130); this.lblid.Name = "lblid"; this.lblid.Size = new System.Drawing.Size(38, 13); this.lblid.TabIndex = 12; this.lblid.Text = "emp id"; // // txtname // this.txtname.Location = new System.Drawing.Point(218, 179); this.txtname.Name = "txtname"; this.txtname.Size = new System.Drawing.Size(276, 20); this.txtname.TabIndex = 11; // // txtid // this.txtid.Location = new System.Drawing.Point(218, 123); this.txtid.Name = "txtid"; this.txtid.Size = new System.Drawing.Size(276, 20); this.txtid.TabIndex = 10; // // pdf_file // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(837, 548); this.Controls.Add(this.button1); this.Controls.Add(this.CRTAB); this.Controls.Add(this.BTNCLOSE); this.Controls.Add(this.BTNSAVE); this.Controls.Add(this.btnbrowse); this.Controls.Add(this.lblempname); this.Controls.Add(this.lblid); this.Controls.Add(this.txtname); this.Controls.Add(this.txtid); this.Name = "pdf_file"; this.Text = "pdf_file"; this.Load += new System.EventHandler(this.pdf_file_Load); this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.Button button1; private System.Windows.Forms.Button CRTAB; private System.Windows.Forms.Button BTNCLOSE; private System.Windows.Forms.Button BTNSAVE; private System.Windows.Forms.Button btnbrowse; private System.Windows.Forms.Label lblempname; private System.Windows.Forms.Label lblid; private System.Windows.Forms.TextBox txtname; private System.Windows.Forms.TextBox txtid; } } / THIS IS THE END OF DESIGNING OF FORM TO STORE PDF FILES INTO ORACLE 9i BLOB FIELD / /THIS IS THE BEGINNING OF CODIFICATION OF THE FORM ABOVE / using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OracleClient; using System.IO; namespace oracleblob { public partial class pdf_file : Form { OracleConnection conn; string connstr; string imagename; DataSet dset; FileStream FS; public pdf_file() { InitializeComponent(); } private void updatedata() { //use filestream object to read the image. //read to the full length of image to a byte array. //add this byte as an oracle parameter and insert it into database. try { //proceed only when the image has a valid path if (imagename != "") { FileStream fls; fls = new FileStream(@imagename, FileMode.Open, FileAccess.Read); //a byte array to read the image byte[] blob = new byte[fls.Length]; fls.Read(blob, 0, System.Convert.ToInt32(fls.Length)); fls.Close(); //open the database using odp.net and insert the data connstr = "User Id=" + "hr" + ";Password=" + "hr" + ";Data Source=" + "shanu;"; conn = new OracleConnection(connstr); conn.Open(); OracleCommand cmnd; string query; query = "insert into emp32(id,name,biodata) values(" + txtid.Text + "," + "'" + txtname.Text + "'," + " :BlobParameter )"; //insert the byte as oracle parameter of type blob OracleParameter blobParameter = new OracleParameter(); blobParameter.OracleType = OracleType.Blob; blobParameter.ParameterName = "BlobParameter"; blobParameter.Value = blob; cmnd = new OracleCommand(query, conn); cmnd.Parameters.Add(blobParameter); cmnd.ExecuteNonQuery(); MessageBox.Show("added to blob field"); cmnd.Dispose(); conn.Close(); conn.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } public void oracleconnection() { try { connstr = "User Id=" + "hr" + ";Password=" + "hr" + ";Data Source=" + "shanu;"; conn = new OracleConnection(connstr); conn.Open(); OracleCommand cmnd = conn.CreateCommand(); cmnd.CommandText = "CREATE TABLE emp32(id INTEGER,name VARCHAR2(50),biodata BLOB)"; cmnd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.Message); } } private void pdf_file_Load(object sender, EventArgs e) { } private void btnbrowse_Click(object sender, EventArgs e) { try { FileDialog fldlg = new OpenFileDialog(); //specify your own initial directory fldlg.InitialDirectory = @":D"; //this will allow onlt those file extensions to be added fldlg.Filter = "PDF File (.pdf)\|.pdf"; if (fldlg.ShowDialog() == DialogResult.OK) { imagename = fldlg.FileName; System.Diagnostics.Process proc = new System.Diagnostics.Process(); proc.EnableRaisingEvents = false; proc.StartInfo.FileName = "AcroRd32"; proc.StartInfo.Arguments = imagename; proc.Start(); fldlg = null; } } catch (System.ArgumentException ae) { imagename = " "; MessageBox.Show(ae.Message.ToString()); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } private void BTNSAVE_Click(object sender, EventArgs e) { this.updatedata(); } private void BTNCLOSE_Click(object sender, EventArgs e) { this.Close(); } private void CRTAB_Click_1(object sender, EventArgs e) { oracleconnection(); } private void button1_Click(object sender, EventArgs e) { try { string imagename1; int tt = Convert.ToInt32(txtid.Text); connstr = "User Id=" + "hr" + ";Password=" + "hr" + ";Data Source=" + "shanu;"; conn = new OracleConnection(connstr); conn.Open(); OracleDataAdapter da = new OracleDataAdapter("SELECT FROM EMP32 WHERE ID=" + tt, conn); dset = new DataSet(); dset.Clear(); dset.Reset(); da.Fill(dset); FS = new FileStream("c:\mybio.pdf", FileMode.Create); imagename1 = "c:\mybio.pdf"; byte[] blob = (byte[])dset.Tables[0].Rows[0].ItemArray[2]; FS.Write(blob, 0, blob.Length); FS.Close(); FS = null; System.Diagnostics.Process proc = new System.Diagnostics.Process(); proc.EnableRaisingEvents = false; proc.StartInfo.FileName = "AcroRd32"; proc.StartInfo.Arguments = imagename1; proc.Start(); } catch (System.ArgumentException ae) { MessageBox.Show(ae.ToString()); } } } } /* THIS IS THE END OF THE PROGRAM */