SQL存取Word文件.docx

要将Word文件存储到数据库的CONTRACT_FILE字段中，需要将文件转换为byte数组/ / 将文件转换为Bytes/ / / public static byte File2Bytes(string fileName)FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Read);byte fileDatas = new bytefs.Length;fs.Read(fileDatas, 0, System.Convert.ToInt32(fs.Length);fs.Close();return fileDatas;将转换完成的byte存储到数据库的对应字段/ / 更新合同文件/ / / / public bool UpdateContractFile(string id, byte fileBytes)string sql = UPDATE CONTRACTS SET CONTRACT_FILE=CONTRACT_FILE WHERE ID=ID;using (SqlConnection conn = new SqlConnection(this.m_DataAccess.ConnectString)conn.Open();using (SqlCommand cmd = new SqlCommand()cmd.Connection = conn;cmd.CommandText = sql;cmd.Parameters.Clear();cmd.Parameters.Add(new SqlParameter(CONTRACT_FILE, SqlDbType.Image);cmd.ParametersCONTRACT_FILE.Value = fileBytes; cmd.Parameters.Add(new SqlParameter(ID, SqlDbType.VarChar); cmd.ParametersID.Value = id;return cmd.ExecuteNonQuery() 0 ? true : false;读取数据库中存储的Word文件，需要先将Image类型的字段转换为bytes通过ID获取文件byte数组 / / 获取合同文件/ / / public byte GetContractFile(string id)string sql = SELECT CONTRACT_FILE FROM CONTRACTS WHERE ID=0; sql = string.Format(sql, id); object contractFile; contractFile = this.m_DataAccess.ExecuteScalar(sql); if (contractFile = null) return new byte0; else return (byte)contractFile; 获取到文件的byte后，将该文件通过文件流操作存储为Word文件byte fileBytes = this.m_ContractsBusiness.GetContractFile(id);if (fileBytes.Length = 0) XMessageBox.ShowError(未找到合同文件！); return;SaveFileDialog sfd = new SaveFileDialog();sfd.Filter = Word文件(*.doc)|*.doc;if (sfd.ShowDialog() = System.Windows.Forms.DialogResult.OK) try string saveFileName = sfd.FileName; int arraysize = new int();/注意这句话 arraysize = fileBytes.GetUpperBound(0); FileStream fs = new FileStream(saveFileName, FileMode.OpenOrCreate, FileAccess.Write); fs.Write(fileBytes, 0, arraysize); fs.Close();if (XMessageBox.ShowQuestion(文件下载成功，是否立即打开文件？) = System.Windows.For