请问怎么把word文档存入数据库,代码越详细越好,最好有实例,谢谢,

解决方案 »

  1.   

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158 
      

  2.   


    //如果选择了文件进行上传
            if (FileUpload1.HasFile)
            {
                string fileName = FileUpload1.FileName;
                int contentLength = FileUpload1.PostedFile.ContentLength;//文件的字节长度
                string mime = FileUpload1.PostedFile.ContentType;
                byte[] data = FileUpload1.FileBytes;//文件的字节数据
                if (fileName.EndWith(".doc")||fileName.EndWith(".docx"))//如果是word文件
                {
                    string sql = "insert into FileList(FileName,FileData,FileLength,Mime)values(@FileName,@FileData,@FileLength,@Mime)";
                    SqlParameter[] parameters = new SqlParameter[4];
                    parameters[0] = new SqlParameter("@FileName", SqlDbType.NVarChar, 50);
                    parameters[0].Value = fileName;                parameters[1] = new SqlParameter("@FileData", SqlDbType.Image, int.MaxValue);
                    parameters[1].Value = data;                parameters[2] = new SqlParameter("@FileLength", SqlDbType.Int, 4);
                    parameters[2].Value = contentLength;                parameters[3] = new SqlParameter("@Mime", SqlDbType.VarChar, 50);
                    parameters[3].Value = mime;                SqlDbHelper helper = new SqlDbHelper(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString);
                    if (helper.ExecuteNonQuery(sql, CommandType.Text, parameters) > 0)
                    {
                        Response.Write("<script language='javascript'>alert('上传成功!');</script>");
                    }
                    else
                    {
                        Response.Write("<script language='javascript'>alert('上传失败');</script>");
                    }
                }
                else
                {
                    Response.Write("<script language='javascript'>alert('请上传Word文件');</script>");
                }
            }
            else
            {
                Response.Write("<script language='javascript'>alert('请选择上传文件');</script>");
            }
        }