C#上传byte类型图片到数据库

来源:互联网 发布:中法翻译软件 编辑:程序博客网 时间:2024/05/10 04:23

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;



原创粉丝点击