// 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();
}