一個吐血的問題：上傳圖片參數無效

c#中以二進位形式上傳圖片到資料庫，在讀取圖片顯示在PictureBox中時提示“參數無效”；找了很久終於發現問題所在:

貼出代碼：修改後代碼

OpenFileDialog oFd = new OpenFileDialog();
            if (oFd.ShowDialog() == DialogResult.OK)
            {
                this.pictureBox1.Image = Image.FromFile(oFd.FileName);
                this.pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;

               FileStream fs = new FileStream(oFd.FileName, FileMode.Open, FileAccess.Read);
                byte[] buffByte = new byte[fs.Length];
                fs.Read(buffByte, 0, (int)fs.Length);
                fs.Close();

                 StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into EIIS_EVIDENCE_IMGS(");
                strSql.Append("EVIDENCE_NO,EVIDENCE_IMG,ORGANIZATION_ID,DELETE_FLAG,CREATE_USER,CREATE_DATETIME,CURRENT_IMG,TRANSFER_ID)");
                strSql.Append(" values (");
                strSql.Append("@EVIDENCE_NO,@EVIDENCE_IMG,@ORGANIZATION_ID,@DELETE_FLAG,@CREATE_USER,@CREATE_DATETIME,@CURRENT_IMG,@TRANSFER_ID)");
                strSql.Append(";select @@IDENTITY");
                SqlParameter[] parameters = {
                   
     new SqlParameter("@EVIDENCE_NO", SqlDbType.VarChar,50),
     new SqlParameter("@EVIDENCE_IMG", SqlDbType.Image),
     new SqlParameter("@ORGANIZATION_ID", SqlDbType.Int,4),
     new SqlParameter("@DELETE_FLAG", SqlDbType.Char,1),
     new SqlParameter("@CREATE_USER", SqlDbType.VarChar,30),
     new SqlParameter("@CREATE_DATETIME", SqlDbType.DateTime),
     new SqlParameter("@CURRENT_IMG", SqlDbType.Char,1),
                    new SqlParameter("@TRANSFER_ID",SqlDbType.Int)
                                        };
                parameters[0].Value = evi.EVIDENCE_NO;
                parameters[1].Value = buffByte;
                parameters[2].Value = GlobalClass.user.ORGANIZATION_ID;
                parameters[3].Value = Convert.ToInt32(DeleteEnum.UnDelete).ToString();
                parameters[4].Value = GlobalClass.user.USER_NO;
                parameters[5].Value = DateTime.Now;
                parameters[6].Value = Convert.ToInt32(YesOrNo.Yes).ToString();
                parameters[7].Value = eviTransfer.TRANSFER_ID;
                DataBase.SetBusinessConnection(GlobalClass.busiConnStr);
                object obj = DataBase.GetScalar(strSql.ToString(), parameters);
            }

修改後代碼：

 

OpenFileDialog oFd = new OpenFileDialog();
            if (oFd.ShowDialog() == DialogResult.OK)
            {
                this.pictureBox1.Image = Image.FromFile(oFd.FileName);
                this.pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;

               FileStream fs = new FileStream(oFd.FileName, FileMode.Open, FileAccess.Read);
                byte[] buffByte = new byte[fs.Length];
                fs.Read(buffByte, 0, (int)fs.Length);
                fs.Close();

                 StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into EIIS_EVIDENCE_IMGS(");
                strSql.Append("EVIDENCE_NO,EVIDENCE_IMG,ORGANIZATION_ID,DELETE_FLAG,CREATE_USER,CREATE_DATETIME,CURRENT_IMG,TRANSFER_ID)");
                strSql.Append(" values (");
                strSql.Append("@EVIDENCE_NO,@EVIDENCE_IMG,@ORGANIZATION_ID,@DELETE_FLAG,@CREATE_USER,@CREATE_DATETIME,@CURRENT_IMG,@TRANSFER_ID)");
                strSql.Append(";select @@IDENTITY");
                SqlParameter[] parameters = {
                   
     new SqlParameter("@EVIDENCE_NO", SqlDbType.VarChar,50),
     new SqlParameter("@EVIDENCE_IMG", SqlDbType.Image，16),
     new SqlParameter("@ORGANIZATION_ID", SqlDbType.Int,4),
     new SqlParameter("@DELETE_FLAG", SqlDbType.Char,1),
     new SqlParameter("@CREATE_USER", SqlDbType.VarChar,30),
     new SqlParameter("@CREATE_DATETIME", SqlDbType.DateTime),
     new SqlParameter("@CURRENT_IMG", SqlDbType.Char,1),
                    new SqlParameter("@TRANSFER_ID",SqlDbType.Int)
                                        };
                parameters[0].Value = evi.EVIDENCE_NO;
                parameters[1].Value = buffByte;
                parameters[2].Value = GlobalClass.user.ORGANIZATION_ID;
                parameters[3].Value = Convert.ToInt32(DeleteEnum.UnDelete).ToString();
                parameters[4].Value = GlobalClass.user.USER_NO;
                parameters[5].Value = DateTime.Now;
                parameters[6].Value = Convert.ToInt32(YesOrNo.Yes).ToString();
                parameters[7].Value = eviTransfer.TRANSFER_ID;
                DataBase.SetBusinessConnection(GlobalClass.busiConnStr);
                object obj = DataBase.GetScalar(strSql.ToString(), parameters);
            }

 

就是在定義參數SqlParameter[] parameters 是把new SqlParameter("@EVIDENCE_IMG", SqlDbType.Image),寫成了new SqlParameter("@EVIDENCE_IMG", SqlDbType.Image，16),
暈到要死。真是低級。