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;