The DbBinaryData Class is available in LEADTOOLS Document and Medical Imaging toolkits.
Loads and saves files to and from a database.
Object Model
Syntax
Visual Basic (Declaration) | |
---|
<DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")>
Public Class DbBinaryData
Inherits BinaryData |
C++/CLI | |
---|
[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public ref class DbBinaryData : public BinaryData |
Example
This example will convert a TIF file in a source folder to a CMP file and save it into a database field.
Visual Basic | Copy Code |
---|
Public Sub DbBinaryDataExample()
Dim client As RasterServiceClient = New RasterServiceClient()
Dim sourceBinaryData As FileBinaryData = New FileBinaryData()
sourceBinaryData.FileName = Path.Combine(LEAD_VARS.ImagesDir, "clean.tif")
Dim destinationBinaryData As DbBinaryData = New DbBinaryData()
destinationBinaryData.Provider = DbBinaryDataProvider.SqlServer
destinationBinaryData.CommandType = DbBinaryDataCommandType.Text
destinationBinaryData.CommandText = "insert into ImagesTable (Image) values (@Image);"
destinationBinaryData.ConnectionString = "server=sp2007ep;" & "Trusted_Connection=yes;" & "database=Images;" & "connection timeout=30"
destinationBinaryData.Parameters = New DbBinaryDataParameter()
destinationBinaryData.Parameters.Add("Image", Nothing)
destinationBinaryData.DataFieldType = DbBinaryDataFieldType.Raw
destinationBinaryData.DataFieldName = "Image"
Dim convertOptions As RasterConvertOptions = New RasterConvertOptions()
convertOptions.Source = sourceBinaryData
convertOptions.Destination = destinationBinaryData
convertOptions.Format = RasterImageFormat.Cmp
convertOptions.FirstPage = 1
convertOptions.LastPage = 1
convertOptions.BitsPerPixel = 24
convertOptions.QualityFactor = 2
Dim request As ConvertRequest = New ConvertRequest()
request.ConvertOptions = convertOptions
client.Convert(request)
client.Close()
End Sub
Public NotInheritable Class LEAD_VARS
Public Const ImagesDir As String = "C:\Users\Public\Documents\LEADTOOLS Images"
End Class |
C# | Copy Code |
---|
public void DbBinaryDataExample()
{
RasterServiceClient client = new RasterServiceClient();
FileBinaryData sourceBinaryData = new FileBinaryData();
sourceBinaryData.FileName = Path.Combine(LEAD_VARS.ImagesDir,"clean.tif");
DbBinaryData destinationBinaryData = new DbBinaryData();
destinationBinaryData.Provider = DbBinaryDataProvider.SqlServer;
destinationBinaryData.CommandType = DbBinaryDataCommandType.Text;
destinationBinaryData.CommandText = "insert into ImagesTable (Image) values (@Image);";
destinationBinaryData.ConnectionString = "server=sp2007ep;" + "Trusted_Connection=yes;" + "database=Images;" + "connection timeout=30";
destinationBinaryData.Parameters = new DbBinaryDataParameter();
destinationBinaryData.Parameters.Add("Image", null);
destinationBinaryData.DataFieldType = DbBinaryDataFieldType.Raw;
destinationBinaryData.DataFieldName = "Image";
RasterConvertOptions convertOptions = new RasterConvertOptions();
convertOptions.Source = sourceBinaryData;
convertOptions.Destination = destinationBinaryData;
convertOptions.Format = RasterImageFormat.Cmp;
convertOptions.FirstPage = 1;
convertOptions.LastPage = 1;
convertOptions.BitsPerPixel = 24;
convertOptions.QualityFactor = 2;
ConvertRequest request = new ConvertRequest();
request.ConvertOptions = convertOptions;
client.Convert(request);
client.Close();
}
static class LEAD_VARS
{
public const string ImagesDir = @"C:\Users\Public\Documents\LEADTOOLS Images";
} |
Remarks
Inheritance Hierarchy
Requirements
Target Platforms: Microsoft .NET Framework 3.0, Windows 2000, Windows XP, Windows Server 2003 family, Windows Server 2008 family, Windows Vista, Windows 7
See Also