title: C#, convert a database value to a string?
body: <p>I have a report that gets updated every week that needs pushed out to 30+ PC's and the number is rising each week.  I am trying to figure out how to take an Access Database and push the files out from a location on our server to all of each of those PC's but what I can't wrap my head around is how to do it.  I was going to use a copy command and then use the value of the PC ID in a string and enter it into the file paths.  This is a little bit more advanced than I am used to working with. Here's what I have so far:</p>
  
  <pre><code>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.IO;
  
  namespace WindowsFormsApplication1
  {
      public partial class Form1 : Form
      {
          public Form1()
          {
              InitializeComponent();
          }
  
          private void Form1_Load(object sender, EventArgs e)
          {
              // TODO: This line of code loads data into the 'database1DataSet1.PCID_List' table. You can move, or remove it, as needed.
              this.pCID_ListTableAdapter.Fill(this.database1DataSet1.PCID_List);
  
          }
  
          private void button_Close_Click(object sender, EventArgs e)
          {
              this.Close();
          }
  
          static void button_Run_Click(object sender, EventArgs e)
          {
              string reportLocationCopy = @"Location TBD";
              string repLoc = @"Location TBD";
              if (File.Exists(repLoc))
              {
                  // If file already exists in destination, delete it
                  if (File.Exists(reportLocationCopy))
                      File.Delete(reportLocationCopy);
                  File.Copy(repLoc, reportLocationCopy);
              }
          }
      }
  }
  </code></pre>