how to save image in sql table?

payam hayati

12y1.1k.NET

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

payam hayati12y ago
now how to mix my Query??
Santosh Ubale12y ago
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(Field1,Field2, 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" :)