一个文档附件存入数据库的方法，很普通

最新推荐文章于 2024-09-17 17:22:20 发布

weixin_30314793

最新推荐文章于 2024-09-17 17:22:20 发布

阅读量210

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/ocnnb/archive/2005/03/14/118381.html

版权

private string InsertFileToDB(DocAccessory docAccessory)
  {
   string tmpGuid = Guid.NewGuid().ToString();
   string tmpSQL = "INSERT INTO ECMSDOCACCESSORY (accessoryid,accessorydocid,accessoryfile,accessoryfilename,accessoryfilesize,accessorytype) ";
   tmpSQL += "VALUES(@accessoryid,@accessorydocid,@accessoryfile,@accessoryfilename,@accessoryfilesize,@accessorytype)";

#region 插入数据逻辑在此

   ComplusGetAll cg = ComplusGetAll.CreateSingletonObject();;
   ConnectionInfo ci = cg.GetConnectionManager().BaseConnection();
   System.Data.SqlClient.SqlConnection dbConnection = new SqlConnection (ci.ConnectionString );
   dbConnection.Open ();
   SqlCommand CmdObj = new SqlCommand(tmpSQL,dbConnection);
   CmdObj.Parameters.Add("@accessoryid",SqlDbType.VarChar ,128).Value =tmpGuid;
   CmdObj.Parameters.Add("@accessoryfilename",SqlDbType.VarChar,128).Value =docAccessory.AccessoryFileName;
   CmdObj.Parameters.Add("@accessoryfile",SqlDbType.Binary ,50).Value =docAccessory.AccessoryFile ;
   CmdObj.Parameters.Add("@accessorydocid",SqlDbType.VarChar ,128).Value =docAccessory.AccessoryDocId;
   CmdObj.Parameters.Add("@accessoryfilesize",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryFileSize;
   CmdObj.Parameters.Add("@accessorytype",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryType;

   CmdObj.ExecuteNonQuery ();

转载于:https://www.cnblogs.com/ocnnb/archive/2005/03/14/118381.html