读取Oracle中的Blob字段生成对应的文件(二)

2014-11-24 18:02:24 · 作者: · 浏览: 5
int _length = 30485760;


byte[] _buffer = new byte[_length];


int i;


while ((i = _oracleLob.Read(_buffer, 0, _length)) > 0)


{


_fileStream.Write(_buffer, 0, i);


}



_fileStream.Close();


_oracleLob.Clone();


_selectCommand.Parameters.Clear();



_transaction.Commit();


}


else


{


MessageBoxEx.Show("没有查找到相符合的记录!", "提示",


MessageBoxButtons.OK, MessageBoxIcon.Information);


}


}



catch (Exception ex)


{


MessageBoxEx.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);


}


}