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

Visual Basic (Usage)	Copy Code
`Dim instance As DbBinaryData`

C#
[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")] public class DbBinaryData : 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

Visual Basic	Copy Code
Public Sub DbBinaryDataExample() Dim client As RasterServiceClient = New RasterServiceClient() Dim sourceBinaryData As FileBinaryData = New FileBinaryData() sourceBinaryData.FileName = LeadtoolsExamples.Common.ImagesPath.Path & "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 Sub DbBinaryDataExample()

   Dim client As RasterServiceClient = New RasterServiceClient()

   Dim sourceBinaryData As FileBinaryData = New FileBinaryData()

   sourceBinaryData.FileName = LeadtoolsExamples.Common.ImagesPath.Path & "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

C# Copy Code

C#	Copy Code
public void DbBinaryDataExample() { RasterServiceClient client = new RasterServiceClient(); FileBinaryData sourceBinaryData = new FileBinaryData(); sourceBinaryData.FileName = LeadtoolsExamples.Common.ImagesPath.Path + "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(); }

public void DbBinaryDataExample() 
{ 
   RasterServiceClient client = new RasterServiceClient(); 
   FileBinaryData sourceBinaryData = new FileBinaryData(); 
   sourceBinaryData.FileName = LeadtoolsExamples.Common.ImagesPath.Path + "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(); 
}

Remarks

Calls the LoadData and SaveData methods internally to load and save data to and from a database field specified by UrlBinaryData.Url.

Inheritance Hierarchy

System.Object
Leadtools.Services.DataContracts.BinaryData
Leadtools.Services.DataContracts.DbBinaryData

Requirements

Target Platforms: Microsoft .NET Framework 3.0, Windows XP, Windows Server 2003 family, Windows Server 2008 family

Leadtools.Services.DataContracts	Requires Document/Medical product license \| Send comments on this topic. \| Back to Introduction - All Topics \| Help Version 16.5.9.25
DbBinaryData Class
See Also Members Example