Con la siguiente clase lo que se pretende es, poder convertir tipos de datos, entre arreglos de bytes e imagen. esto es para poder transmitirlos o guardarlos en una base de datos.
Imports System.IO
Imports System.Text
Imports System.Drawing
Public Class FuncsAndUtils
Public Shared Function ArrayToStream(ByVal buffer() As Byte) As Stream
Dim Flujo As Stream = New MemoryStream(buffer)
Return Flujo
End Function
Public Shared Function ArrayToBitmap(ByVal Buffer() As Byte) As Bitmap
Return StreamToBitmap(ArrayToStream(Buffer))
End Function
Public Shared Function StreamToArray(ByVal Flujo As Stream) As Byte()
Dim streamLength As Integer = Convert.ToInt32(Flujo.Length)
Dim fileData(streamLength) As Byte
' Read the file into a byte array
Flujo.Read(fileData, 0, streamLength - 1)
Flujo.Close()
Return fileData
End Function
Public Shared Function StreamToBitmap(ByVal Flujo As Stream) As Bitmap
Try
Return New Bitmap(Flujo)
Catch ex As Exception
Throw ex
End Try
End Function
Public Shared Function BitmapToArray(ByVal bmp As Bitmap) As Byte()
Dim stream As New System.IO.MemoryStream()
bmp.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp)
stream.Position = 0
Dim data(stream.Length) As Byte
stream.Read(data, 0, stream.Length)
Return data
End Function
Public Shared Function StringToArray(ByVal valor As String) As Byte()
Return (New UnicodeEncoding).GetBytes(valor)
End Function
Public Shared Function BitmapToStream(ByVal bmp As Bitmap) As Stream
Dim stream As New System.IO.MemoryStream()
bmp.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp)
stream.Position = 0
Return stream
End Function
Public Shared Function ArrayToString(ByVal valor() As Byte) As String
Return New UnicodeEncoding().GetString(valor)
End Function
End Class
martes, octubre 07, 2008
sábado, mayo 12, 2007
LABEL MULTILINEA
Vamos a crear un web control, que sera un label multilinea con scrollBar
Este control es practico cuando necesitamos un campo de tipo lectura y disponemos de poco espacio para mostrar la información.
Vamos a crear un nuevo Proyecto de tipo Class Library.
Lo importante son las Librerias que importamos y como lo declaramos.
A continuación el codigo.
Imports System
Imports System.Web.UI
Imports System.Web.UI.WebControls
Public Class MultiLineLabel
Inherits CompositeControl
#Region "Variables"
Private lblcontent As Label
#End Region
#Region "Propiedades"
Public Property Text() As String
Get
EnsureChildControls()
Return lblcontent.Text
End Get
Set(ByVal value As String)
EnsureChildControls()
lblcontent.Text = value
End Set
End Property
Public Overloads Property Height() As String
Get
EnsureChildControls()
Return lblcontent.Height.ToString
End Get
Set(ByVal value As String)
EnsureChildControls()
lblcontent.Height = Unit.Parse(value)
End Set
End Property
Protected Overrides ReadOnly Property TagKey() As System.Web.UI.HtmlTextWriterTag
Get
Return HtmlTextWriterTag.Div
End Get
End Property
#End Region
#Region "Crear control"
Protected Overrides Sub CreateChildControls()
lblcontent = New Label
lblcontent.ID = Me.ID & "Lab"
Me.Controls.Add(lblcontent)
End Sub
#End Region
#Region "Render Tags"
Protected Overrides Sub RenderContents(ByVal writer As System.Web.UI.HtmlTextWriter)
writer.AddStyleAttribute("overflow", "auto")
writer.RenderBeginTag(HtmlTextWriterTag.Div)
lblcontent.RenderControl(writer)
writer.RenderEndTag() 'DIV
End Sub
#End Region
End Class
Este control es practico cuando necesitamos un campo de tipo lectura y disponemos de poco espacio para mostrar la información.
Vamos a crear un nuevo Proyecto de tipo Class Library.
Lo importante son las Librerias que importamos y como lo declaramos.
A continuación el codigo.
Imports System
Imports System.Web.UI
Imports System.Web.UI.WebControls
Public Class MultiLineLabel
Inherits CompositeControl
#Region "Variables"
Private lblcontent As Label
#End Region
#Region "Propiedades"
Public Property Text() As String
Get
EnsureChildControls()
Return lblcontent.Text
End Get
Set(ByVal value As String)
EnsureChildControls()
lblcontent.Text = value
End Set
End Property
Public Overloads Property Height() As String
Get
EnsureChildControls()
Return lblcontent.Height.ToString
End Get
Set(ByVal value As String)
EnsureChildControls()
lblcontent.Height = Unit.Parse(value)
End Set
End Property
Protected Overrides ReadOnly Property TagKey() As System.Web.UI.HtmlTextWriterTag
Get
Return HtmlTextWriterTag.Div
End Get
End Property
#End Region
#Region "Crear control"
Protected Overrides Sub CreateChildControls()
lblcontent = New Label
lblcontent.ID = Me.ID & "Lab"
Me.Controls.Add(lblcontent)
End Sub
#End Region
#Region "Render Tags"
Protected Overrides Sub RenderContents(ByVal writer As System.Web.UI.HtmlTextWriter)
writer.AddStyleAttribute("overflow", "auto")
writer.RenderBeginTag(HtmlTextWriterTag.Div)
lblcontent.RenderControl(writer)
writer.RenderEndTag() 'DIV
End Sub
#End Region
End Class
viernes, octubre 13, 2006
Unir 2 tablas de diferentes bases de datos
esta es rapida. lo unico importante aqui es que deben estar en la misma instancia de SQL las bases de datos, y si hay problemas, es solo cuestion de revisar la configuracion del COLLATE
select * from BD1..Tabla1inner join BD2..Tabla2On BD1..Tabla1.Camp=BD2..Tala2.Camp COLLATE Compatibility_52_409_30003
Suscribirse a:
Entradas (Atom)