DB2Command cmd = new DB2Command( "SELECT * FROM EMPLOYEE 
  WHERE LASTNAME = @lastname AND WORKDEPT = @workdept", conn );
 cmd.Parameters.Clear();
 cmd.Parameters.Add( "@workdept", DB2Type.SmallInt );
 cmd.Parameters.Add( "@lastname", DB2Type.VarChar, 15 );
 DB2Reader reader = cmd.ExecuteReader();

Byte[] out_picture = new Byte[maxSize];
String empno = "000137";
String photoFormat = "bitmap";

DB2Command cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO emp_photo (photo_format, empno, picture) VALUES (?, ?, ?)"
cmd.Parameters.Add("@format", DB2Type.Char, 10);
cmd.Parameters.Add("@empno", DB2Type.Char, 6); 
cmd.Parameters.Add("@picture", DB2Type.Blob);
cmd.Parameters("@empno").Value = empno;
cmd.Parameters("@picture").Value = out_picture;
cmd.Parameters("@format").Value = photoFormat;
cmd.ExecuteNonQuery();