LEADTOOLS WCF (Leadtools.Services.DataContracts assembly)
LEAD Technologies, Inc

DbBinaryData Class

Example 





Members 
Loads and saves files to and from a database.
Object Model
DbBinaryData ClassDbBinaryDataParameterDictionary ClassObject Class
Syntax
[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
public sealed class DbBinaryData : BinaryData 
function Leadtools.Services.DataContracts.DbBinaryData()
[DataContractAttribute(Namespace="http://Leadtools.Services.DataContracts/2009/01", Name="DbBinaryData")]
public ref class DbBinaryData : public BinaryData 
Remarks
Calls the LoadData and SaveData methods internally to load and save data to and from a database field specified by UrlBinaryData.Url.
Example
 
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
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";
}
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

DbBinaryData Members
Leadtools.Services.DataContracts Namespace

 

 


Products | Support | Contact Us | Copyright Notices

© 2006-2012 All Rights Reserved. LEAD Technologies, Inc.

Applications developed with LEADTOOLS WCF components require runtime licenses. Server licensing is required for applications on a server. For more information, refer to: LEADTOOLS Toolkit Features