2023年6月21日发(作者：)
C#往SQL数据库字段中插⼊⼆进制⽂件的三种⽅法C#往SQL数据库字段中插⼊⼆进制⽂件的三种⽅法,⽹络测试程序⼀别⼈好象成功了.我怎么都测试不成功.同事解说是INSERTSQL语句是字符串.所以不能把⼆进制内容//创建⼀个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,DocumentCoinsertSQL=insertSQL+ " VALUES('"+DocumentType+"','"+DocumentDate+"','"+DocumentManager+"','"+DocumentDepartment+"','"+DocumentTitle+"','"+DocumenSqlCommand insertCommand= new SqlCommand();
("@BinaryFileData",);ters["@BinaryFileData"].Value=BinaryFileData;dType=;dText=insertSQL;tion=myConn;();eNonQuery();*///测试⽅法⼆:使⽤存储过程插⼊⼆进制字段,测试成功/*SqlCommand insertCommand = new SqlCommand("sp_HmSoft_OfficeDoc_ADD",myConn);dType = Procedure;(new SqlParameter("@DocumentType", ar, 50));(new SqlParameter("@DocumentDate", ar, 50));(new SqlParameter("@DocumentManager", ar, 50));(new SqlParameter("@DocumentDepartment", ar, 50));(new SqlParameter("@DocumentTitle", ar, 50));(new SqlParameter("@DocumentContent", ar, 50));(new SqlParameter("@BinaryFileData", ));(new SqlParameter("@BinaryFileType", ar, 50));
(new SqlParameter("@BinaryFileLength", ));(new SqlParameter("@BinaryFilePath", ar, 50));(new SqlParameter("@AddUserName", ar, 50));(new SqlParameter("@AddUserTime", ar, 50));(new SqlParameter("@AddUserIP", ar, 50));
ters["@DocumentType"].Value=DocumentType;ters["@DocumentDate"].Value=DocumentDate;ters["@DocumentManager"].Value=DocumentManager;ters["@DocumentDepartment"].Value=DocumentDepartment;
ters["@DocumentTitle"].Value=DocumentTitle;ters["@DocumentContent"].Value=DocumentContent;ters["@BinaryFileData"].Value=BinaryFileData;ters["@BinaryFileType"].Value=BinaryFileType;ters["@BinaryFileLength"].Value=BinaryFileLength;ters["@BinaryFilePath"].Value=BinaryFilePath;ters["@AddUserName"].Value=strAddUser;ters["@AddUserTime"].Value=strAddTime;ters["@AddUserIP"].Value=strAddIP;();eNonQuery();*///测试⽅法三:使⽤DataSet插⼊⼆进制字段,测试成功
();DataSet tempDataSet=new DataSet();SqlDataAdapter tempAdapter = new SqlDataAdapter("SELECT * FROM EP_HmSoftOfficeDocList WHERE 1=0", myConn);SqlCommandBuilder tempBuilder=new SqlCommandBuilder(tempAdapter);
(tempDataSet);(tempDataSet);//'插⼊⼀条记录
DataRow tempDataRow = [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;[0].(tempDataRow);(tempDataSet);//关闭连接 ( ) ;
2023年6月21日发(作者：)
C#往SQL数据库字段中插⼊⼆进制⽂件的三种⽅法C#往SQL数据库字段中插⼊⼆进制⽂件的三种⽅法,⽹络测试程序⼀别⼈好象成功了.我怎么都测试不成功.同事解说是INSERTSQL语句是字符串.所以不能把⼆进制内容//创建⼀个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,DocumentCoinsertSQL=insertSQL+ " VALUES('"+DocumentType+"','"+DocumentDate+"','"+DocumentManager+"','"+DocumentDepartment+"','"+DocumentTitle+"','"+DocumenSqlCommand insertCommand= new SqlCommand();
("@BinaryFileData",);ters["@BinaryFileData"].Value=BinaryFileData;dType=;dText=insertSQL;tion=myConn;();eNonQuery();*///测试⽅法⼆:使⽤存储过程插⼊⼆进制字段,测试成功/*SqlCommand insertCommand = new SqlCommand("sp_HmSoft_OfficeDoc_ADD",myConn);dType = Procedure;(new SqlParameter("@DocumentType", ar, 50));(new SqlParameter("@DocumentDate", ar, 50));(new SqlParameter("@DocumentManager", ar, 50));(new SqlParameter("@DocumentDepartment", ar, 50));(new SqlParameter("@DocumentTitle", ar, 50));(new SqlParameter("@DocumentContent", ar, 50));(new SqlParameter("@BinaryFileData", ));(new SqlParameter("@BinaryFileType", ar, 50));
(new SqlParameter("@BinaryFileLength", ));(new SqlParameter("@BinaryFilePath", ar, 50));(new SqlParameter("@AddUserName", ar, 50));(new SqlParameter("@AddUserTime", ar, 50));(new SqlParameter("@AddUserIP", ar, 50));
ters["@DocumentType"].Value=DocumentType;ters["@DocumentDate"].Value=DocumentDate;ters["@DocumentManager"].Value=DocumentManager;ters["@DocumentDepartment"].Value=DocumentDepartment;
ters["@DocumentTitle"].Value=DocumentTitle;ters["@DocumentContent"].Value=DocumentContent;ters["@BinaryFileData"].Value=BinaryFileData;ters["@BinaryFileType"].Value=BinaryFileType;ters["@BinaryFileLength"].Value=BinaryFileLength;ters["@BinaryFilePath"].Value=BinaryFilePath;ters["@AddUserName"].Value=strAddUser;ters["@AddUserTime"].Value=strAddTime;ters["@AddUserIP"].Value=strAddIP;();eNonQuery();*///测试⽅法三:使⽤DataSet插⼊⼆进制字段,测试成功
();DataSet tempDataSet=new DataSet();SqlDataAdapter tempAdapter = new SqlDataAdapter("SELECT * FROM EP_HmSoftOfficeDocList WHERE 1=0", myConn);SqlCommandBuilder tempBuilder=new SqlCommandBuilder(tempAdapter);
(tempDataSet);(tempDataSet);//'插⼊⼀条记录
DataRow tempDataRow = [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;[0].(tempDataRow);(tempDataSet);//关闭连接 ( ) ;
发布评论