C realizes file and binary transfer and stores in database

  • 2021-07-06 11:36:51
  • OfStack


// This method is to browse the file object 
    private void button1_Click(object sender, EventArgs e)
    {
      // User opens file browsing 
      using (OpenFileDialog dialog = new OpenFileDialog())
      {
        // Only single selection 1 Files 
        dialog.Multiselect = false;
        // Select 1 Files 
        if (dialog.ShowDialog() == DialogResult.OK)
        {
          try
          {
            // Give the selected file path to txtPath
            this.textBox1.Text = dialog.FileName;
          }
          catch (Exception ex)
          {
            // Throw an exception 
            throw (ex);
          }
        }
      }
    }

    // Shut down 
    private void button3_Click(object sender, EventArgs e)
    {
      this.Close();
    }

    // Turn a file into 2 Binary outflow into database 
    private void button2_Click(object sender, EventArgs e)
    {
      FileStream fs = new FileStream(textBox1.Text, FileMode.Open);
      BinaryReader br = new BinaryReader(fs);
      Byte[] byData = br.ReadBytes((int)fs.Length);
      fs.Close();
      string conn = "server=.;database=testDB;Uid=sa;Pwd=sa ";
      SqlConnection myconn = new SqlConnection(conn);
      myconn.Open();
      string str = "insert into pro_table (pro_name,pro_file) values(' Test file ',@file)";
      SqlCommand mycomm = new SqlCommand(str, myconn);
      mycomm.Parameters.Add("@file", SqlDbType.Binary, byData.Length);
      mycomm.Parameters["@file"].Value = byData;
      mycomm.ExecuteNonQuery();
      myconn.Close();
    }

    // From the database 2 Binary stream read, write and restore to file 
    private void button4_Click(object sender, EventArgs e)
    {
      string conn = "server=.;database=testDB;Uid=sa;Pwd=sa ";
      string str = "select pro_file from pro_table where pro_name=' Test file ' ";
      SqlConnection myconn = new SqlConnection(conn);
      SqlDataAdapter sda = new SqlDataAdapter(str, conn);
      DataSet myds = new DataSet();
      myconn.Open();
      sda.Fill(myds);
      myconn.Close();
      Byte[] Files = (Byte[])myds.Tables[0].Rows[0]["pro_file"]; 
      BinaryWriter bw = new BinaryWriter(File.Open("D:\\2.rdlc",FileMode.OpenOrCreate));
      bw.Write(Files);
      bw.Close();
       
    }

Related articles: