LPAD and RPAD SQL Functions in Dot Net

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


Related Articles

Object Serialisation in dot net

This article provides an overview of the serialization used in Microsoft .NET and the usage of the same.For example, serialization is used to save session state in ASP.NET and to copy objects to the clipboard in Windows Forms. It is also used by remoting to pass objects by value from one application domain to another.

More articles: Dot Net SQL function

Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: