private void TransferFiles()
        {
            using (SqlConnection conn = new SqlConnection(ConnectionString.Value))
            {
                try
                {
                    conn.Open();
                    string fullPath = System.Reflection.Assembly.GetAssembly(typeof(Form1)).Location;                    // Получаем полное местоположение exe файла сборки 
                    string theDirectory = Path.GetDirectoryName(fullPath);                                               // Получаем папку в котором он находится
                    DataTable dt = new DataTable();
                    string queryOpen = String.Format("select top {7} t1.id, t1.{0}, t2.{1} " +
                                                     "from {2}.dbo.{3} t1 " +
                                                     "left join {4}.dbo.{5} t2 on t1.id = t2.{6}",
                                                     ConnectionString.DoVarchar, colNameImageCmb.Text, ConnectionString.InitialCatalog, ConnectionString.TableNameText,
                                                     initialCatalogTxb.Text, tableNameCmb.Text, fieldCommunicationCmb.Text, numericNumberOfLines.Value);
                    if (!String.IsNullOrEmpty(tableNameCmb.Text) && !String.IsNullOrEmpty(colNameImageCmb.Text) && !String.IsNullOrEmpty(fieldCommunicationCmb.Text))
                    {
                        SqlCommand command = new SqlCommand(queryOpen, conn);
                        SqlDataReader reader = command.ExecuteReader();
                        dt.Load(reader);
                        reader.Close();
                        foreach (var item in dt.Select())
                        {
                            int fileId = (int)item["id"];
                            string fileName = (string)item[ConnectionString.DoVarchar];
                            byte[] fileContent = (byte[])item[colNameImageCmb.Text];

                            using (FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate))
                            {
                                fs.Write(fileContent, 0, fileContent.Length);
                            }
                            string queryLoad = String.Format("UPDATE {0} SET \"{1}\" = (SELECT * FROM OPENROWSET(BULK '{4}\\{2}', SINGLE_BLOB) AS x), " +
                                                             "{5} = (GetDate()) where \"id\" = {3}",
                                                                ConnectionString.TableNameText, ConnectionString.Filestream, fileName, fileId, theDirectory, ConnectionString.Datetime);
                            command = new SqlCommand(queryLoad, conn);
                            command.ExecuteNonQuery();
                        }
                    }
                    else
                        MessageBox.Show("Выберите все поля!");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            for (int i = 0; i <= 100; i++)
            {
                Thread.Sleep(10);
                backgroundWorker1.WorkerReportsProgress = true;
                backgroundWorker1.ReportProgress(i);
            }
        }

        private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
        {
            circularProgressBar1.Value = e.ProgressPercentage;
            progressLbl.Text = e.ProgressPercentage.ToString() + "%";
            if (progressLbl.Text == "100%")
            {
                MessageBox.Show("Копирование успешно завершено!");
            }
        }

  foreach (var item in dt.Select())
                        {
                            int fileId = (int)item["id"];
                            string fileName = (string)item[ConnectionString.DoVarchar];
                            byte[] fileContent = (byte[])item[colNameImageCmb.Text];

                            using (FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate))
                            {
                                fs.Write(fileContent, 0, fileContent.Length);
                            }
                            string queryLoad = String.Format("UPDATE {0} SET \"{1}\" = (SELECT * FROM OPENROWSET(BULK '{4}\\{2}', SINGLE_BLOB) AS x), " +
                                                             "{5} = (GetDate()) where \"id\" = {3}",
                                                                ConnectionString.TableNameText, ConnectionString.Filestream, fileName, fileId, theDirectory, ConnectionString.Datetime);
                            command = new SqlCommand(queryLoad, conn);
                            command.ExecuteNonQuery();

                            backgroundWorker1.RunWorkerAsync();
                            circularProgressBar1.Show();
                        }