how to save image in sql table?

Question

hi
it's my table in sql :

and form :

and Query :

protected void Button1_Click(object sender, EventArgs e)
{
sqlserver sqls = new sqlserver(".", "University");
sqls.update("insert into master (m_pcode , m_name , m_family , m_melicode , m_phone , m_mobi , m_brithday , m_r_id , m_ma_id , m_address) values('" + m_pcode.Text + "','" + m_name.Text + "','" + m_family.Text + "','" + m_melicode.Text + "','" + m_phone.Text + "','" + m_mobil.Text + "','" + m_brithday.Text + "','" + m_course.Text + "' , '" + m_certificate.Text + "' , '" + m_address.Text + "')");
}

Everything works properly, query the data just don't know what to write for save image and where to do it?

payam hayati · Answer

now how to mix my Query??

Santosh Ubale · Answer

Insert Image in DB //Get Image in bytes byte[] img = null; FileStream fs = new FileStream(ImageLocation FileMode.Open FileAccess.Read); BinaryReader br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); string sql = INSERT INTO TableName(Field1Field2 Field3 IMAGE) VALUES(+Field1Value +'+ Field2Value +' '+ Field3Value +'@IMG); //Open connection and pass connection object to command object if (conn.State != ConnectionState.Open) conn.Open(); command = new SqlCommand(sql conn); command.Parameters.Add(new SqlParameter(@IMG img)); command.ExecuteNonQuery(); conn.Close(); LIKE THIS ANSWER IF IT HELPS YOU :)