Question

怎样word文档以二进制流的形式存入数据库

Answer 1

protected void Button1_Click(object sender, EventArgs e)
        {
 
            //FileInfo thefile = new FileInfo(@"D:\立项依据.doc");
            FileStream fsDoc = File.OpenRead(@"D:\立项依据.doc");
 
            DateTime dtnow = DateTime.Now;
            string filename = dtnow.ToString("yyyyMMdd")+".doc";
 
            byte[] buffer=new byte[fsDoc.Length];
 
            fsDoc.Read(buffer,0,(int)fsDoc.Length);
            conn.Open();
            string sqlCmd = @"Insert into MyUploadTable(filename,filesize,filedata,ProjectID,IsAuditActivePage)
                              Values(@filename,@filesize,@filedata,@ProjectID,1)";
            SqlCommand Cmd = new SqlCommand(sqlCmd,conn);
            Cmd.Parameters.Add("@filename",SqlDbType.VarChar).Value=filename;
            Cmd.Parameters.Add("@filesize",SqlDbType.BigInt).Value=fsDoc.Length;
            Cmd.Parameters.Add("@filedata",SqlDbType.Image).Value=buffer;
            Cmd.Parameters.Add("@ProjectID",SqlDbType.Int).Value=2;
            Cmd.ExecuteNonQuery();
            fsDoc.Close();
            conn.Close();
 
             
        }