遍历文件夹上传文件到数据库，然后更新客户端文件

额外命名空间：

using System.IO;
using System.Text.RegularExpressions;

public partial class Form1 : Form { SqlConnection conn = new SqlConnection("Data Source=ALVIN//SQLEXPRESS;Initial Catalog=gis_data;User ID=sa;password=111111"); string filename = ""; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { if (folderBrowserDialog1.ShowDialog() == DialogResult.OK) { filename = folderBrowserDialog1.SelectedPath.ToString(); textBox1.Text = filename.ToString();//这里是选择文件后，你的文件的位置 FindFile(filename + "//"); //这个路径是服务器地址文件夹 } } public void FindFile(string dir)//上传文件到数据库（参数为指定的目录） { //在指定目录及子目录下查找文件 DirectoryInfo Dir = new DirectoryInfo(dir); try { foreach (DirectoryInfo d in Dir.GetDirectories()) //查找子目录 { FindFile(Dir + d.ToString() + "//"); } foreach (FileInfo f in Dir.GetFiles("*.*")) //查找文件 { string str = Dir.ToString().TrimStart(filename.Trim().ToCharArray()); string str2=str+f.ToString(); if (have(str2) < 0) { if (conn.State == ConnectionState.Open) { conn.Close(); conn.Open(); } else conn.Open(); SqlCommand cmd = new SqlCommand("insert into file1 (filename,filedata,filetime) values ('" + str2.ToString() + "',@filedata,'" + DateTime.Now + "')", conn); SqlParameter paramFileData = cmd.Parameters.Add("@FileData", SqlDbType.Image); paramFileData.Direction = ParameterDirection.Input; byte[] bImage = new byte[f.Length]; Stream objStream = f.OpenRead(); objStream.Read(bImage, 0, (int)f.Length); paramFileData.Value = bImage; cmd.ExecuteNonQuery(); conn.Close(); } else { if (conn.State == ConnectionState.Open) { conn.Close(); conn.Open(); } else conn.Open(); SqlCommand cmd = new SqlCommand("update file1 set filename='" + str2.ToString() + "',filedata=@FileData,filetime='" + DateTime.Now + "' where filename='" + f.ToString() + "'", conn); SqlParameter paramFileData = cmd.Parameters.Add("@FileData", SqlDbType.Image); paramFileData.Direction = ParameterDirection.Input; byte[] bImage = new byte[f.Length]; Stream objStream = f.OpenRead(); objStream.Read(bImage, 0, (int)f.Length); paramFileData.Value = bImage; cmd.ExecuteNonQuery(); conn.Close(); } } } catch (Exception e) { MessageBox.Show(e.Message); } } private void button3_Click(object sender, EventArgs e) { if (folderBrowserDialog1.ShowDialog() == DialogResult.OK) { filename = folderBrowserDialog1.SelectedPath.ToString(); textBox1.Text = filename.ToString();//这里是选择文件后，你的文件的位置 delete(filename+"//"); Find(filename + "//"); //这个路径是服务器地址下文件夹 } } public void Find(string dir) //更新客户端文件（参数为指定的目录） { //在指定目录及子目录下查找文件 if (conn.State == ConnectionState.Open) { conn.Close(); conn.Open(); } else conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select filename from file1", conn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { int row = ds.Tables[0].Rows.Count; for (int i = 0; i < row; i++) { string str = ds.Tables[0].Rows[i]["filename"].ToString(); string str1 = dir + str; FileInfo file = new FileInfo(str1); if (file.Exists) { SqlDataAdapter sda = new SqlDataAdapter("select filedata from file1 where filename='" + str.ToString() + "'", conn); SqlCommandBuilder MyCB = new SqlCommandBuilder(da); DataSet dss = new DataSet("file1"); byte[] MyData; sda.Fill(dss, "file1"); int rows = dss.Tables["file1"].Rows.Count; DataRow myRow; myRow = dss.Tables["file1"].Rows[rows - 1]; MyData = (byte[])myRow["filedata"]; int ArraySize = MyData.GetUpperBound(0); FileStream fs = new FileStream(str1.ToString(), FileMode.Create, FileAccess.Write); fs.Write(MyData, 0, ArraySize); fs.Close(); } else { string s = dir + "//" + str.TrimEnd(file.Name.Trim().ToCharArray()); Directory.CreateDirectory(s); SqlDataAdapter da1 = new SqlDataAdapter("select filedata from file1 where filename='" + str.ToString() + "'", conn); SqlCommandBuilder MyCB = new SqlCommandBuilder(da); DataSet ds2 = new DataSet("file1"); byte[] MyData; da1.Fill(ds2, "file1"); int row1 = ds2.Tables["file1"].Rows.Count; DataRow myRow; myRow = ds2.Tables["file1"].Rows[row1 - 1]; MyData = (byte[])myRow["filedata"]; int ArraySize = MyData.GetUpperBound(0); FileStream fs = new FileStream(str1.ToString(), FileMode.Create, FileAccess.Write); fs.Write(MyData, 0, ArraySize); fs.Close(); } } } conn.Close(); } public void delete(string dir)//删除多余文件 { DirectoryInfo Dir = new DirectoryInfo(dir); try { foreach (DirectoryInfo d in Dir.GetDirectories()) //查找子目录 { delete(Dir + d.ToString() + "//"); } foreach (FileInfo f in Dir.GetFiles("*.*")) //查找文件 { string str = Dir.ToString().TrimStart(filename.Trim().ToCharArray()); string str2 = str + f.ToString(); if (conn.State == ConnectionState.Open) { conn.Close(); conn.Open(); } else conn.Open(); SqlCommand cmd = new SqlCommand("select * from file1 where filename='" + str2.ToString() + "'", conn); SqlDataReader dr = cmd.ExecuteReader(); if (!dr.Read()) { File.Delete(Dir + f.ToString()); } dr.Close(); conn.Close(); } } catch (Exception e) { MessageBox.Show(e.Message); } } public int have(string path)//判断数据库中该文件是否存在 { if (conn.State == ConnectionState.Open) { conn.Close(); conn.Open(); } else conn.Open(); SqlCommand cmd = new SqlCommand("select * from file1 where filename='" + path.ToString() + "'", conn); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { return 1; } else { return -1; } dr.Close(); conn.Close(); } }

开始选择上传文件夹，遍历文件夹下的所有文件，将其转换成Image类型，保存相对路径到数据库（判断该文件数据库中是否存在，若存在则更新，否则插入）

更新客户端文件，浏览需要更新的文件夹，对已有文件进行更新，没有的文件创建，不需要的文件删除