C#

private void listViewFiles_DragDrop(object sender, DragEventArgs e)
{
    string[] files = (string[])e.Data.GetData(DataFormats.FileDrop);
    foreach (string file in files)
    {
        newFile = new OpenFileDialog();
        newFile.FileName = file;
        SaveFileThread(file, newFile.SafeFileName, false);
        newFile.Dispose();
    }
    bwLoadFiles.RunWorkerAsync();
}
private void lstMRFiles_DragDrop(object sender, DragEventArgs e)
{
    string[] files = (string[])e.Data.GetData(DataFormats.FileDrop);
    foreach (string file in files)
    {
        newFile = new OpenFileDialog();
        newFile.FileName = file;
        SaveFileThread(file, newFile.SafeFileName, true);
        newFile.Dispose();
    }
    bwLoadFiles.RunWorkerAsync();
}

private void SaveFileThread(string Filename, string SafeFile, bool MR)
 {
     RegistryAccess reg = new RegistryAccess();
     SqlConnection conn = new SqlConnection(reg.ReturnConnection);
     SqlCommand cmd = new SqlCommand("SELECT * FROM Inventory_Files WHERE FilesID=@FilesID AND [Filename]=@Filename AND MR=@MR", conn);

     try
     {
         cmd.Parameters.AddWithValue("@FilesID", txtTAG.Text);
         cmd.Parameters.AddWithValue("@Filename", SafeFile);
         cmd.Parameters.AddWithValue("@MR", MR);

         conn.Open();
         SqlDataReader myReader = cmd.ExecuteReader();

         if (myReader.HasRows)
         {
             if (MR) Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Did not save. File already exist.", true });
             else Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Did not save. File already exist.", false });
         }
         else
         {
             conn.Close();
             FileStream fs = new FileStream(Filename, FileMode.Open, FileAccess.Read);

             decimal Size = fs.Length;
             byte[] buffer = new byte[fs.Length];
             fs.Read(buffer, 0, (int)fs.Length);
             fs.Close();

             if (MR) Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Saving file.. Size: " + Math.Round((Size / 1024) / 1024, 2) + "MB", true });
             else Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Saving file.. Size: " + Math.Round((Size / 1024) / 1024, 2) + "MB", false });

             conn = new SqlConnection(reg.ReturnConnection);
             cmd = new SqlCommand("INSERT INTO Inventory_Files (FilesID, Saved_File, Filename, File_Size, MR) VALUES (@FilesID, @File, @FileName, @Size, @MR)", conn);
             cmd.Parameters.AddWithValue("@FilesID", txtTAG.Text);
             cmd.Parameters.AddWithValue("@File", buffer);
             cmd.Parameters.AddWithValue("@FileName", SafeFile);
             cmd.Parameters.AddWithValue("@Size", Size);
             cmd.Parameters.AddWithValue("@MR", MR);
             conn.Open();

             int Success = cmd.ExecuteNonQuery();

             if (Success > 0)
             {
                 if (MR) Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Saved file.", true });
                 else Invoke(new FilesLabelDelegate(FilesLabel), new object[] { "Saved file.", false });
             }
         }
     }
     catch (Exception ex) { new Errors(ex).ShowDialog(); }
     finally { conn.Close(); }
 }

private void lvNameList_SelectedIndexChanged(object sender, EventArgs e)
        {
            ClearSearch();
            select = "SELECT * FROM agenda_telefonica WHERE nume = '" + lvNameList.FocusedItem.Text + "' AND prenume = '" + lvNameList.FocusedItem.SubItems[1].Text + "'"; 
            SqlDataReader dr = realSql.Select(select);
            if (!dr.HasRows)
            {
                MessageBox.Show("Information not found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                while (dr.Read())
                {
                    tbName.Text = dr[1].ToString().Trim() + " " + dr[2].ToString().Trim();
                    tbPhoneNumber1.Text = dr[3].ToString().Trim();
                    tbPhoneNumber2.Text = dr[4].ToString().Trim();
                    tbPhoneNumber3.Text = dr[5].ToString().Trim();
                    tbFaxNumber.Text = dr[6].ToString().Trim();
                    tbEmail.Text = dr[7].ToString().Trim();
                    tbCompany.Text = dr[8].ToString().Trim();
                    tbService.Text = dr[9].ToString().Trim();
                    tbEquipment.Text = dr[10].ToString().Trim();
                }
            }
            dr.Close();
            realSql.Close();
        }
    }