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