C#+mysql Picture Data storage

Turn files into binary streams into the 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 ();
}

Reads the binary stream read-write from the database and restores it to a 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 ();
}

C#+mysql Picture Data storage