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 (PicFileSize) 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/