private void btShowImages_Click(object sender, System.EventArgs e) { Devart.Data.PostgreSql.PgSqlDataReader dataReader = selectCommand.ExecuteReader(); int fieldNo = dataReader.GetOrdinal("Picture"); while (dataReader.Read()) { int length = (int)dataReader.GetBytes(fieldNo, 0, null, 0, 0); byte[] buffer = new Byte[length]; length = (int)dataReader.GetBytes(fieldNo, 0, buffer, 0, length); string pictureName = dataReader.GetString(1); if (length > 0) { Form form = new Form(); form.Text = pictureName; form.Show(); PictureBox pictureBox = new PictureBox(); pictureBox.Parent = form; pictureBox.Dock = DockStyle.Fill; pictureBox.Image = System.Drawing.Bitmap.FromStream(new MemoryStream(buffer)); } } dataReader.Close(); }
private void btExecute_Click(object sender, System.EventArgs e) { const int len = 11; int recCount = 0; Devart.Data.PostgreSql.PgSqlDataReader dataReader = null; try { dataReader = command.ExecuteReader(); if (dataReader.FieldCount > 0) { for (int i = 0; i < dataReader.FieldCount; i++) { tbResult.AppendText(dataReader.GetName(i).PadRight(len).Substring(0, len) + "\t"); } tbResult.AppendText("\r\n"); for (int i = 0; i < dataReader.FieldCount; i++) { tbResult.AppendText(String.Empty.PadRight(len, '-').Substring(0, len) + "\t"); } tbResult.AppendText("\r\n"); while (dataReader.Read()) { System.Text.StringBuilder sb = new System.Text.StringBuilder(100); for (int i = 0; i < dataReader.FieldCount; i++) { if (dataReader.IsDBNull(i)) { sb.Append("(null)".PadRight(len).Substring(0, len) + "\t"); } else { sb.Append(dataReader.GetValue(i).ToString().PadRight(len).Substring(0, len) + "\t"); } } sb.Append("\r\n"); recCount++; tbResult.AppendText(sb.ToString()); } writeStatus1 = recCount.ToString() + " rows selected"; } else { writeStatus1 = "Statement executed"; } tbResult.AppendText("\r\n"); OnWriteStatus(); } catch (Devart.Data.PostgreSql.PgSqlException exception) { tbResult.AppendText(exception.Message + "\r\n\r\n"); throw; } finally { if (dataReader != null) { dataReader.Close(); } } }