SqlString(String,Boolean) Method

Returns a string quoted with '' for Access and N'' (Unicode) for SQL-Server, or NULL if value is empty or null

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function SqlString( _ 
   ByVal value As String, _ 
   ByVal returnNullOnEmptyString As Boolean _ 
) As String

public static string SqlString( 
   string value,
   bool returnNullOnEmptyString 
)

Parameters

value: The string to quote
returnNullOnEmptyString: Return null if value is null or empty

Remarks

The string format is based on the database type set up for the particular solution.

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

Reference

Database Class
Database Members
Overload List