NetQuarry Core Help
Namespaces
NetQuarry
EAPUtil Class
EAPUtil Methods
AddStyles Method
AnsiQuote Method
BitsSet Method
BlobToBytes Method
BlobToFile Method
CalcLatLongDistance Method
CalendarQuarter Method
CaptureStackFrames Method
CleanFilename Method
ClearFarmCacheAsync Method
ComposeDateTime Method
ConstructExternalLink Method
ConstructLink Method
ContainsKey Method
ControlHtml Method
CreateMissingPath Method
DataTableTypeToOleDbType Method
DateSQL Method
DefaultHtmlHeader Method
Deserialize Method
DevLogUnknownBits Method
DiagnoseMultipleControlError Method
EqualValue Method
EscapeEmbeddedFunctions Method
EscapeExpressionBrackets Method
EscapeSQLName Method
ExtractNestedMessage Method
FileExists Method
FileIsReadonly Method
FileMakeWriteable Method
FileVersion Method
FindChildControl Method
FixupHoverButton Method
FormatException Method
FormatExceptionForRequestLog Method
FromHex Method
FtpDeleteFile Method
FtpGetFileContents Method
FtpGetFileList Method
FtpUpload Method
GetByteBufferFromFile Method
GetByteBufferFromLogicalFile Method
GetDataRowValue Method
GetEventsHandled Method
GetImageFromFile Method
GetLogDB Method
GetNextBusinessDay Method
GetPageForm Method
GetTypeFromString Method
HasExactlyOneBitSet Method
HasRows Method
HelpString Method
HtmlEncode Method
ImageSize Method
InputStreamToBase64 Method
IsBitMask Method
IsClientScriptBlockRegistered Method
IsEditorBrowsable Method
IsFileValidateAcceptType Method
IsFolder Method
IsGuid Method
IsNonEmptyString Method
IsNullObjectOrEmptyString Method
IsNullOrBlank Method
IsNumeric Method
IsReservedDBWord Method
IsStartupScriptRegistered Method
IsTruthy Method
IsUIHidden Method
IsVersionConstrained Method
JString Method
LoadComponent Method
LogApiRequest Method
MD5 Method
MergeStrings Method
NewGuid Method
ObjCompare Method
PathExists Method
PathSplit Method
PhysicalPathToRelativePath Method
ReaderBlobToFile Method
ReadInputStream Method
ReadTextFile Method
RedirectUrl Method
RegisterClientHtmlBlock Method
RegisterClientScriptBlock Method
RegisterClientScriptFile Method
RegisterDocReadyScript Method
RegisterHiddenField Method
RegisterStartupScript Method
RemoveInvalidChars Method
ReplaceCaseInsensitive Method
ResizeImage Method
ResolvePath Method
RetrieveLinkerTimestamp Method
SafeSQLName Method
SavePostedFile Method
Serialize Method
SetInitialFocus Method
SetNewActionOnQS Method
SpanIncluding Method
SqlBlobToFile Method
SqlDbTypeToOleDbType Method
SqlExceptionInternals Method
SqlNativeTypeToOleDbType Method
SQLString Method
StripHTML Method
TextToHtml Method
ToDecimal Method
ToDouble Method
ToDoubleSafe Method
ToHex Method
ToInt Method
ToString Method
ToStringRaw Method
TypeIsBinary Method
TypeIsBoolean Method
TypeIsChar Method
TypeIsDate Method
TypeIsFloat Method
TypeIsInteger Method
TypeIsLong Method
TypeIsLongChar Method
TypeIsNumeric Method
TypeIsUnicode Method
TypeRequiresUnicodeEscape Method
ValidBits Method
WeekNumber Method
WindowOpenFeatures Method
WriteBlobToDatabase Method
WriteExceptionToRequestLog Method
WriteFileToDatabase Method
WriteInputStreamToDatabase Method
WriteToRequestLog Method
WriteToTimingLog Method
ZipDistanceCalc Method
ZipInfoLookup Method
Click or drag to resize

EAPUtilSqlBlobToFile Method

Extract a binary column from a SQL-Server data reader to a file. See ReaderBlobToFile(IDataReader, Int32, String, Int32) for a general purpose blob-to-file implementation.

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
Copy
public static bool SqlBlobToFile(
	SqlDataReader dr,
	int nPictureColIdx,
	string sDestFilePath,
	int nPrefixByteCount
)

Parameters

dr
Type: System.Data.SqlClientSqlDataReader
The SQL-Server datareader.
nPictureColIdx
Type: SystemInt32
The column index into the reader.
sDestFilePath
Type: SystemString
The destination to which to write the file.
nPrefixByteCount
Type: SystemInt32
The number of prefix bytes to ignore in the image stream.

Return Value

Type: Boolean
True if file was extracted, else false.
See Also