DbBinaryData Class

C#
Visual Basic
Objective-C
Java
C++

[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public class DbBinaryData : BinaryData

'Declaration
 
<DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")>
Public Class DbBinaryData 
   Inherits BinaryData

'Usage
 
Dim instance As DbBinaryData

[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public ref class DbBinaryData : public BinaryData

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

This example will convert a TIF file in a source folder to a CMP file and save it into a database field.

C#
Visual Basic
WinRT C#
WinRT JavaScript
Silverlight C#
Silverlight VB

Copy Code

Imports Leadtools.Services
Imports Leadtools.Services.Raster.ServiceContracts
Imports Leadtools.Services.Raster.ServiceImplementations
Imports leadtools.services.datacontracts._2009._01
Imports leadtools.services.raster.datacontracts._2009._01

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

using Leadtools.Services;
using Leadtools.Services.Raster.ServiceContracts;
using Leadtools.Services.Raster.ServiceImplementations;
using leadtools.services.datacontracts._2009._01;
using leadtools.services.raster.datacontracts._2009._01;

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";
}

Target Platforms

Reference

DbBinaryData Members
Leadtools.Services.DataContracts Namespace