C#往SQL数据库字段中插入二进制文件的三种方法

C#往SQL数据库字段中插入二进制文件的三种方法,网络测试程序一别人好象成功了.我怎么都测试不成功.同事解说是INSERTSQL语句是字符串.所以不能把二进制内容跟字段联合起来传递给SQL2000



//创建一个SqlConnection对象 

string strCon = "Initial Catalog='HMMISDATA';Server='192.168.1.180';User ID='用户名';Password='密码';Persist Security Info=True"; 

SqlConnection myConn = new SqlConnection ( strCon ) ; 

//测试方法一:使用SQL语句插入二进制字段,测试失败



/*

string insertSQL="INSERT INTO EP_HmSoftOfficeDocList(DocumentType,DocumentDate,DocumentManager,DocumentDepartment,DocumentTitle,DocumentContent,BinaryFileData,BinaryFileType,BinaryFileLength,BinaryFilePath,AddUserName,AddUserTime,AddUserIP) ";



insertSQL=insertSQL+ " VALUES('"+DocumentType+"','"+DocumentDate+"','"+DocumentManager+"','"+DocumentDepartment+"','"+DocumentTitle+"','"+DocumentContent+"',"+@BinaryFileData+",'"+BinaryFileType+"',"+BinaryFileLength+",'"+BinaryFilePath+"','"+strAddUser+"','"+strAddTime+"','"+strAddIP+"')" ;



SqlCommand insertCommand= new SqlCommand(); 

insertCommand.Parameters.Add("@BinaryFileData",SqlDbType.Image);

insertCommand.Parameters["@BinaryFileData"].Value=BinaryFileData;

insertCommand.CommandType=CommandType.Text;

insertCommand.CommandText=insertSQL;

insertCommand.Connection=myConn;

insertCommand.Connection.Open();

insertCommand.ExecuteNonQuery();



*/

//测试方法二:使用存储过程插入二进制字段,测试成功

/*



SqlCommand insertCommand = new SqlCommand("sp_HmSoft_OfficeDoc_ADD",myConn);

insertCommand.CommandType = CommandType.StoredProcedure;

insertCommand.Parameters.Add(new SqlParameter("@DocumentType", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@DocumentDate", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@DocumentManager", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@DocumentDepartment", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@DocumentTitle", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@DocumentContent", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@BinaryFileData", SqlDbType.Image));

insertCommand.Parameters.Add(new SqlParameter("@BinaryFileType", SqlDbType.NVarChar, 50)); 

insertCommand.Parameters.Add(new SqlParameter("@BinaryFileLength", SqlDbType.Int));

insertCommand.Parameters.Add(new SqlParameter("@BinaryFilePath", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@AddUserName", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@AddUserTime", SqlDbType.NVarChar, 50));

insertCommand.Parameters.Add(new SqlParameter("@AddUserIP", SqlDbType.NVarChar, 50)); 

insertCommand.Parameters["@DocumentType"].Value=DocumentType;

insertCommand.Parameters["@DocumentDate"].Value=DocumentDate;

insertCommand.Parameters["@DocumentManager"].Value=DocumentManager;

insertCommand.Parameters["@DocumentDepartment"].Value=DocumentDepartment; 

insertCommand.Parameters["@DocumentTitle"].Value=DocumentTitle;

insertCommand.Parameters["@DocumentContent"].Value=DocumentContent;

insertCommand.Parameters["@BinaryFileData"].Value=BinaryFileData;

insertCommand.Parameters["@BinaryFileType"].Value=BinaryFileType;

insertCommand.Parameters["@BinaryFileLength"].Value=BinaryFileLength;

insertCommand.Parameters["@BinaryFilePath"].Value=BinaryFilePath;

insertCommand.Parameters["@AddUserName"].Value=strAddUser;

insertCommand.Parameters["@AddUserTime"].Value=strAddTime;

insertCommand.Parameters["@AddUserIP"].Value=strAddIP;

insertCommand.Connection.Open();

insertCommand.ExecuteNonQuery();



*/



//测试方法三:使用DataSet插入二进制字段,测试成功 

myConn.Open();

DataSet tempDataSet=new DataSet();

SqlDataAdapter tempAdapter = new SqlDataAdapter("SELECT * FROM EP_HmSoftOfficeDocList WHERE 1=0", myConn);

SqlCommandBuilder tempBuilder=new SqlCommandBuilder(tempAdapter); 

tempAdapter.Fill(tempDataSet);

//'插入一条记录 

DataRow tempDataRow = tempDataSet.Tables[0].NewRow();

tempDataRow["DocumentType"] =DocumentType;

tempDataRow["DocumentDate"] =DocumentDate;

tempDataRow["DocumentManager"] =DocumentManager;

tempDataRow["DocumentDepartment"] =DocumentDepartment;

tempDataRow["DocumentTitle"] =DocumentTitle;

tempDataRow["DocumentContent"] =DocumentContent;

tempDataRow["BinaryFileData"] =BinaryFileData; 

tempDataRow["BinaryFileType"] =BinaryFileType;

tempDataRow["BinaryFileLength"] =BinaryFileLength;

tempDataRow["BinaryFilePath"] =BinaryFilePath;

tempDataRow["AddUserName"] =strAddUser;

tempDataRow["AddUserTime"] =strAddTime;

tempDataRow["AddUserIP"] =strAddIP;

tempDataSet.Tables[0].Rows.Add(tempDataRow);

tempAdapter.Update(tempDataSet);



//关闭连接

myConn.Close ( ) ;