private string GetDBImage(int Index, Accusoft.ImagXpressSdk.ImageXView iXView)
{
string ImageName;
long retter;
int bufferSize = 16777216;
byte[] outByte = new byte[bufferSize - 1];
string stringConnection = (strProvider + strDataSource);
string stringSQL = "SELECT * FROM [tblImages]";
dbConnection.ConnectionString = (strProvider + strDataSource);
dbConnection.Open();
System.Data.OleDb.OleDbCommand dbCommandGet = new OleDbCommand(stringSQL, dbConnection);
System.Data.OleDb.OleDbDataReader dbReader = dbCommandGet.ExecuteReader(CommandBehavior.Default);
int i = 0;
while ((i <= Index))
{
dbReader.Read();
i = (i + 1);
}
retter = dbReader.GetBytes(2, 0, outByte, 0, bufferSize);
MemoryStream stmBLOBData = new MemoryStream(outByte);
ImageName = dbReader["ImageName"].ToString();
dbReader.Close();
try
{
iXView.Image = Accusoft.ImagXpressSdk.ImageX.FromStream(imagXpress1, stmBLOBData, loLoadOptions);
}
catch (Accusoft.ImagXpressSdk.ImagXpressException ex)
{
AccusoftError(ex, lblError);
}
if ((dbConnection.State == ConnectionState.Open))
{
dbConnection.Close();
dbConnection.Dispose();
}
return(ImageName);
}
