Add(String,SQLiteType,Int32) Method

In This Topic

Adds a SQLiteParameter to the SQLiteParameterCollection given the the parameter name, data type, and data size.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal dbType As SQLiteType, _
   ByVal size As Integer _
) As SQLiteParameter

public SQLiteParameter Add( 
   string parameterName,
   SQLiteType dbType,
   int size
)

Parameters

parameterName: The name of the parameter.
dbType
size: The maximum size, in bytes, of the data the parameter can contain.

Return Value

The new SQLiteParameter object.

Example

The following example creates a SQLiteParameterCollection, adds instances of SQLiteParameter to the collection, and returns a reference to the new SQLiteParameter.

csharp

public void CreateSQLiteParamColl(SQLiteConnection myConn) {
  SQLiteCommand sqCommand = new SQLiteCommand("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn);
  SQLiteParameterCollection myParamCollection = sqCommand.Parameters;
  SQLiteParameter myNewParameter = myParamCollection.Add("DeptNo", SQLiteType.Int32, 40);
}

Visual Basic

Public Sub CreateSQLiteParamColl(myConn As SQLiteConnection)
  Dim sqCommand As SQLiteCommand = New SQLiteCommand("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn)
  Dim myParamCollection As SQLiteParameterCollection = sqCommand.Parameters
  Dim myNewParameter As SQLiteParameter = myParamCollection.Add("DeptNo", SQLiteType.Int32, 40)
End Sub

Reference

SQLiteParameterCollection Class
SQLiteParameterCollection Members
Overload List

Send Feedback