Leadtools.Services.DataContracts Namespace : DbBinaryData Class |
[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
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"; }
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