How to insert image to access database using c# code

Question

hai expert............ How to insert image to access database using c# code? thanks in advance...

Suthish Nair · Answer

I will suggest not to store images in Access database, because of database size issue (2 giga bytes). Access does not handle images very efficiently. You can store the images to a physical folder and then path with file name to DB Table. If for learning purpose, then go for above samples.

Manikavelu Velayutham · Answer

below code will help you to insert the image to access database. code is in vb.net, hope you can easily conver it to c#. File name is Image.vb Imports System Imports System.IO Imports System.Data Public Class SaveImage Shared Sub main() Dim o As System.IO.FileStream Dim r As StreamReader Dim gifFile As String Console.Write("Enter a Valid .Gif file path") gifFile = Console.ReadLine If Dir(gifFile) = "" Then Console.Write("Invalid File Path") Exit Sub End If o = New FileStream(gifFile, FileMode.Open, FileAccess.Read, FileShare.Read) r = New StreamReader(o) Try Dim FileByteArray(o.Length - 1) As Byte o.Read(FileByteArray, 0, o.Length) Dim Con As New _ System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=Test.mdb") Dim Sql As String = "INSERT INTO Images (Pic,FileSize) VALUES (?,?)" Dim Cmd As New System.Data.OleDb.OleDbCommand(Sql, Con) Cmd.Parameters.Add("@Pic", System.Data.OleDb.OleDbType.Binary, o.Length).Value = FileByteArray Cmd.Parameters.Add("@FileSize", System.Data.OleDb.OleDbType.VarChar, 100).Value = o.Length Con.Open() Cmd.ExecuteNonQuery() Con.Close() Catch ex As Exception Console.Write(ex.ToString) End Try End Sub End Class

Muralidharan Deenathayalan · Answer

Please try this .... //select the file here openFileDialog1.ShowDialog(); System.IO. FileStream imagefs = new System.IO. FileStream (openFileDialog1.FileName, System.IO. FileMode .Open); byte [] buffer = new byte [imagefs.Length]; BinaryReader mbr = new BinaryReader (imagefs); mbr.Read(buffer, 0, Convert .ToInt32( imagefs.Length)); string connectionstirng = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database1.mdb;User Id=admin;Password=;" ; string query = " insert into table1 (Images) values (?)" ; OleDbConnection con = new OleDbConnection (); con.ConnectionString = connectionstirng; con.Open(); OleDbCommand cmd = new OleDbCommand (); cmd.Connection = con; cmd.CommandText = query; OleDbParameter param = new OleDbParameter ( "@image" , OleDbType .Binary); param.Value = buffer; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); con.Close();

Soumya Surendran · Answer

Thanks...............

Manikavelu Velayutham · Answer

Below link has few more code to do the same. Based on your requirement you can easily chose the code http://programming.top54u.com/post/Store-and-Display-Images-from-MS-Access-Database-Using-C-Sharp.aspx http://www.aspfree.com/c/a/ASP.NET/Uploading-Images-to-a-Database--C---Part-I/

How to insert image to access database using c# code

Answers (5)