Форум программистов [Powered by Invision Power Board]

Код


byte[] photo = GetDOC(docFilePath);
             using (OleDbConnection connection = new OleDbConnection(connect))
            {
                OleDbCommand command = new OleDbCommand(
                "INSERT into Imeg(Docc) Values(@Docc)", connection);
                command.Parameters.Add("@Docc", OleDbType.LongVarBinary, photo.Length).Value = photo;
                connection.Open();
                command.ExecuteNonQuery();

            }

 public static byte[] GetDOC(string filePath)
        {
            FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
            BinaryReader br = new BinaryReader(fs);
            byte[] photo = br.ReadBytes((int)fs.Length);
            br.Close();
            fs.Close();
            return photo;
        }

Код


 using (OleDbConnection conn = new OleDbConnection(connect))
            {
                try
                {
                    conn.Open();
                    //--------------------------------
                    OleDbCommand command = new OleDbCommand("SELECT Docc FROM Imeg where id=34", conn);
                    FileStream stream;
                    BinaryWriter writer;
                    OleDbDataReader datareader = command.ExecuteReader();
                    datareader.Read();
                    int bLength = (int)datareader.GetBytes(0, 0, null, 0, int.MaxValue);
                    datareader.Close();
                    int bufferSize = bLength;
                    byte[] outByte = new byte[bLength];
                    long retval;
                    long startIndex = 0;
                    //string pubID = "";
                    OleDbDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess);

                    while (reader.Read())
                    {
                        //pubID = reader.GetString(0);
                        stream = new FileStream("Привет.doc", FileMode.OpenOrCreate, FileAccess.Write);
                        writer = new BinaryWriter(stream);
                        startIndex = 0;
                        retval = reader.GetBytes(0, startIndex, outByte, 0, bufferSize);
                        while (retval == bufferSize)
                        {
                            writer.Write(outByte);
                            writer.Flush();
                            startIndex += bufferSize;
                            retval = reader.GetBytes(0, startIndex, outByte, 0, bufferSize);
                        }
                        writer.Write(outByte, 0, (int)retval);
                        writer.Flush();
                        writer.Close();
                        stream.Close();
                    }
                    reader.Close();
                    SaveFileDialog saveFileDlg = new SaveFileDialog();
                    saveFileDlg.Filter = "Word Documents|*.doc|Excel Worksheets|*.xls|PowerPoint Presentations|*.ppt" +
             "|Office Files|*.docx;*.xls;*.ppt" + "|All Files|*.*";
                    if (saveFileDlg.ShowDialog() == DialogResult.OK)
                    {
                        FileStream streamF = new FileStream(saveFileDlg.FileName, FileMode.OpenOrCreate);
                        BinaryWriter writerB = new BinaryWriter(streamF);
                        byte[] b1 = outByte;
                        writerB.Write(b1);
                        streamF.Close(); writerB.Close();
                        Process prEx1 = new Process();
                        prEx1.EnableRaisingEvents = true;
                        prEx1.Exited += new EventHandler(prEx1_Exited);
                        prEx1.StartInfo = new ProcessStartInfo(saveFileDlg.FileName, saveFileDlg.InitialDirectory);
                        prEx1.Start();
                        prEx1.WaitForExit();
                        string path = saveFileDlg.FileName;
                        try
                        {
                            using (StreamWriter sw = File.CreateText(path)) { }
                            string path2 = path + "temp";
                            // Ensure that the target does not exist.
                            File.Delete(path);                            
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine("The process failed: {0}", ex.ToString());
                        }
                    }
                    conn.Close();
                }
                catch (SqlException ex)
                {
                    MessageBox.Show(ex.Message, ex.Source);
                    conn.Close();
                }
            }
НУ при закрытии файла можем обновить базу