Abstract:
Using SQL Server CLR Functions LPAD and RPAD in Dot Net.
Description:
Integración SQL Server vs CLR.
// Namespace Used
Imports System
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.Data.SqlClient
Imports System.Runtime.InteropServices
Code:
Public Class SentenciaSQL
_
Public Shared Function LPad(ByVal strFrase As String, ByVal strCaracter As String, ByVal intCantidad As Integer) As String
Dim strResult As String = vbNullString
Dim i As Integer
For i = 0 To intCantidad - 1
strResult &= strCaracter
Next
strResult = strResult & strFrase
Return Left(strResult, intCantidad)
End Function
_
Public Shared Function RPad(ByVal strFrase As String, ByVal strCaracter As String, ByVal intCantidad As Integer) As String
Dim strResult As String = vbNullString
Dim i As Integer
For i = 0 To intCantidad - 1
strResult &= strCaracter
Next
strResult = strFrase & strResult
Return Right(strResult, intCantidad)
End Function
End Class
|
No responses found. Be the first to respond and make money from revenue sharing program.
|