[UPLOAD]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Test_save_XML
{
    public partial class from1 : Form
    {
        string fname;
        string fpath;
        public from1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            openFileDialog1.Filter = "XML files(*.XML) | *.XML";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                fpath = openFileDialog1.FileName;
                fname = fpath.Substring(fpath.LastIndexOf("\\") + 1);
                textBox1.Text = fname;
                textBox2.Text = fpath;
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            BITPF_ASSEM.LOG_ASSEM bit = new BITPF_ASSEM.LOG_ASSEM();
            bool re = bit.FileUpLoad("wangno", fname, fpath);
            if (re)
            {
                MessageBox.Show("데이터베이스에 저장완료");
                return;
            }
            else
            {
                MessageBox.Show("동일한 파일명이 존재합니다");
                return;
            }
        }
        private void button3_Click(object sender, EventArgs e)
        {
            fname = textBox1.Text;
        }
    }
}

[DOWNLOAD]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Collections;
using System.IO;
namespace Down_XML_From_DB
{
    public partial class Form1 : Form
    {
        string click;
        BITPF_ASSEM.LOG_ASSEM bit;
        public Form1()
        {
            bit = new BITPF_ASSEM.LOG_ASSEM();
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            listBox1.Items.Clear();
            ArrayList list = new ArrayList();
            bit.GetFileList(textBox1.Text, ref list);
            foreach (string s in list)
            {
                listBox1.Items.Add(s);
            }
        }
        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            click = listBox1.SelectedItem.ToString();
            textBox2.Text = click;
        }
        private void button2_Click(object sender, EventArgs e)
        {
            byte[] MyData = null;
            int Datasize = new int();
            string SavePath = "c:\\";
            bit.DownLoadFile("wangno",click,ref MyData,ref Datasize);
            FileStream fs = new FileStream(SavePath+click, FileMode.Create, FileAccess.Write);
            fs.Write(MyData, 0, Datasize+1);
            fs.Close();
            MessageBox.Show(string.Format("[{0}] 폴더에 [{1}] 파일 저장완료",SavePath,click));
        }
    }
}

[DLL]
 public bool FileUpLoad(string ID, string FileName, string FilePath)
        {
            byte[] Mydata = GetImage(FilePath);
            InitSQL("ExistFileName");
            SqlParameter p1 = new SqlParameter("@ID", SqlDbType.VarChar, 50);
            SqlParameter p2 = new SqlParameter("@FILENAME", SqlDbType.VarChar, 50);
            SqlParameter p3 = new SqlParameter("@DATAFILE", SqlDbType.Image, Mydata.Length);
            SqlParameter p4 = new SqlParameter("@FILESIZE", SqlDbType.Int);
            SqlParameter p5 = new SqlParameter("@CHECK", SqlDbType.TinyInt);
            p1.Value = ID;
            p2.Value = FileName.Substring(FileName.LastIndexOf("\\") + 1);
            p3.Value = Mydata;
            p4.Value = Mydata.Length;
            p5.Direction = System.Data.ParameterDirection.Output;
            sCom.Parameters.Add(p1);
            sCom.Parameters.Add(p2);
            sCom.Parameters.Add(p3);
            sCom.Parameters.Add(p4);
            sCom.Parameters.Add(p5);
            sCom.Connection.Open();
            sCom.ExecuteNonQuery();
            int re = int.Parse(p5.Value.ToString());
            if (re == 0)
            {
                sCom.Connection.Close();
                return true;
            }
            sCom.Connection.Close();
            return false;
       }
       
        public void GetFileList(string FileName, ref ArrayList list)
        {
            InitSQL("FindFile");
            SqlParameter p1 = new SqlParameter("@FILENAME", SqlDbType.VarChar, 50);
            p1.Value = FileName;
            sCom.Parameters.Add(p1);
            sCom.Connection.Open();
            SqlDataReader sr = sCom.ExecuteReader();
            while (sr.Read())
            {
                list.Add(sr.GetValue(0).ToString());
            }
            sr.Close();
            sCom.Connection.Close();
        }
        public void DownLoadFile(string ID, string FileName, ref byte[] Mydata, ref int datasize)
        {
            InitSQL("DownLoadFile");
            SqlParameter p1 = new SqlParameter("@FILENAME", SqlDbType.VarChar, 50);
            p1.Value = FileName;
            sCom.Parameters.Add(p1);
            sCom.Connection.Open();
            SqlDataReader sr = sCom.ExecuteReader();
            while (sr.Read())
            {
                Mydata = (byte[])sr.GetValue(0);
                datasize = Mydata.GetUpperBound(0);
            }
            sr.Close();
            sCom.Connection.Close();
        }