public void SaveFile(byte[] data)
{
StringBuilder cb = new StringBuilder();
SqlCommand cmd = new SqlCommand();
SqlParameter parm = new SqlParameter("@NewsImage", SqlDbType.Image);
parm.Value = data;
cmd.Parameters.Add(parm);
using (SqlConnection conn = new SqlConnection(CONN_STRING))
{
cb.Append("INSERT INTO NewsInfo(NewsImage) VALUES(@NewsImage)");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = cb.ToString();
cmd.ExecuteNonQuery();
conn.Close();
}
}
private string CONN_STRING = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;