C# 將圖片存到mysql

			try
			{
				if (!string.IsNullOrEmpty(fileName) && System.IO.File.Exists(fileName))
				{
					string connString = "Data Source = 127.0.0.1;Initial Catalog = dbName;User ID = uuu;Password = ppp";
					MySqlConnection conn = new MySqlConnection(connString);
					conn.Open();
					string sql = "Insert into orderPrint(ordersn,image,FileName) values (@ordersn,@image,@FileName)";

					MySqlCommand cmd = new MySqlCommand(sql, conn);

					string picturePath = fileName;
					FileStream fs = new FileStream(picturePath, FileMode.Open, FileAccess.Read);
					Byte[] mybyte = new byte[fs.Length];
					fs.Read(mybyte, 0, mybyte.Length);
					fs.Close();
					MySqlParameter prm = new MySqlParameter
					  ("@image", MySqlDbType.VarBinary, mybyte.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, mybyte);
					cmd.Parameters.Add(prm);
					cmd.Parameters.Add(new MySqlParameter("@ordersn", ordersn));
					cmd.Parameters.Add(new MySqlParameter("@FileName", System.IO.Path.GetFileName(fileName)));
					cmd.ExecuteNonQuery();
					cmd.Dispose();
					conn.Close();
				}
			}
			catch (Exception)
			{

			}