C#中如何增SQL SERVER的IMAGE字段内容

Question

要点： SQL语句使用参数传递
            string path = @"D:\photo\100_4683.JPG";
            OleDbCommand cmd = new OleDbCommand("insert into blob(pic) values(@para1)", conn);
            OleDbParameter para = new OleDbParameter("@para1", OleDbType.Binary);
            para.Value =(byte[]) Class1.ReadFileToByte(path);
            cmd.Parameters.Add(para);
            int i = cmd.ExecuteNonQuery();            cmd.Dispose();

Answer 1

         bool isRun = true; 
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
using System.Drawing;
using System.Text.RegularExpressions;
using System.IO;
//net2.0引用
 
         HttpPostedFile PF = fileObj.PostedFile;
            if (PF.FileName != "")
            {
                try
                {
                    SqlConnection cn = new SqlConnection((string)Page.Cache["SQLConn"] + ";Pooling=true;Connection Reset=false;Connection Lifetime=30;Min Pool Size=3");
                    SqlCommand cmd = cn.CreateCommand();
                    cmd.CommandText = "update 表 set ftitle=@fName,fcontent=@fileImg where id=@ID";
                    //录入和修改只要进行相应的操作就行了
                    cmd.CommandType = CommandType.Text;
                    SqlParameter p = new SqlParameter("@ID", SqlDbType.VarChar);
                    p.Value = txtID.Text;
                    cmd.Parameters.Add(p);
                    p = new SqlParameter("@fName", SqlDbType.VarChar);
                    p.Value = PF.FileName.Substring(PF.FileName.LastIndexOf("\\") + 1);
                    cmd.Parameters.Add(p);
                    Stream fileDataStream = PF.InputStream;
                    int fileLength = PF.ContentLength;
                    byte[] fileData = new byte[fileLength];
                    fileDataStream.Read(fileData, 0, fileLength);
                    p = new SqlParameter("@fileImg", SqlDbType.Image);
                    p.Value = fileData;
                    cmd.Parameters.Add(p);
                    if (cn.State == ConnectionState.Closed)
                    {
                        cn.Open();
                    }
                    isRun = (cmd.ExecuteNonQuery() > 0);
                    cmd.Parameters.Clear();
                    cn.Close();
                }
                catch
                {
                    isRun = false;
                }
            }
            if (isRun)
            {
               //成功转到那？
                  
            }http://www.xpeng.com.cn
http://www.lyyywx.com.cn
http://www.bdgxqsq.com.cn

Answer 2

private void button1_Click(object sender, EventArgs e)
        {
            Stream ms;
            byte[] picbyte;
            OpenFileDialog ofdSelectPic = new OpenFileDialog();
            ofdSelectPic.ShowDialog();
            ms = ofdSelectPic.OpenFile();
            picbyte = new byte[ms.Length];
            ms.Position = 0;
            ms.Read(picbyte, 0, Convert.ToInt32(ms.Length));            SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=;database=库");
            conn.Open();
            string sqlstring = "insert into 表(字段) values(@img)";
            SqlCommand cmd = new SqlCommand(sqlstring, conn);
            cmd.Parameters.Add("@img", SqlDbType.Image, picbyte.Length).Value = picbyte;
            
            cmd.ExecuteNonQuery();
            conn.Close();
        }