insert image to Sql Data base

[v_sadeghpour]

hello i would like insert a image in sql Data base with oledb Connection. please help me.:doh: vahid

[Judah Gabriel Himango]

A simple Google search returned these results[^].

Tech, life, family, faith: Give me a visit. I'm currently blogging about: Goof around music jam with my brothers (with video) The apostle Paul, modernly speaking: Epistles of Paul Judah Himango

[Billah]

i think following code will help u: 1st Step: Take pic. box 2nd Step: Take a Button and Text box to take the image, which u want to save into Database

buff = new byte [ f.Length ] ; f.Read ( buff, 0, ( int ) f.Length ) ; MemoryStream ms= new MemoryStream(buff,0,buff.Length); Image i = Image.FromStream ( ms ) ; img.Image = i ; f.Close(); } catch(Exception ee) { MessageBox.Show("An error has occured.\n" + ee.Message); } } }

3rd Step: Create table where take one field which will image type CREATE TABLE [dbo].[tableName] ([img_name] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

buff = new byte [ st.Length ] ; st.Read ( buff, 0, ( int ) st.Length ) ; try { using(SqlConnection conn = new SqlConnection()) { conn.ConnectionString = dbcon; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "insert into tableName(imageName) values(@pict)"; cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@pict",buff); cmd.ExecuteNonQuery(); } } catch(SqlException sqle) { Console.WriteLine(sqle.Message); } st.Close(); } private void linklblShowPicture_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e) { try { using(SqlConnection conn = new SqlConnection()) { conn.ConnectionString = dbcon; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select imageName from tableName where .... "; \\here u can use track id in datatabel to select, update or delete image cmd.Connection = conn; cmd.CommandType = CommandType.Text; SqlDataReader r = cmd.ExecuteReader(); if(r.R

[v_sadeghpour]

Thank you. vahid