SqlParameterCollection.Add Method

asp.net.ph

System.Data.SqlClient Namespace SqlParameterCollection Class

Adds an SqlParameter to the parameters collection.

1. Adds a new SqlParameter object to the parameters collection.

[ VB ] Overloads Public Function Add ( Object ) As SqlParameter

[ C# ] public virtual SqlParameter Add ( object );

[ C++ ] public: virtual SqlParameter* Add ( Object );

[ JScript ] public function Add ( Object ) : SqlParameter;

2. Adds a specified SqlParameter object to the parameters collection.

[ VB ] Overloads Public Sub Add ( SqlParameter )

[ C# ] public void Add ( SqlParameter );

[ C++ ] public: void Add ( SqlParameter* );

[ JScript ] public function Add ( SqlParameter );

3. Adds an SqlParameter with the specified name and value to the parameters collection.

[ VB ] Overloads Public Function Add ( String, Object ) As SqlParameter

[ C# ] public virtual SqlParameter Add ( string, Object );

[ C++ ] public: virtual SqlParameter* Add ( String*, Object );

[ JScript ] public function Add ( String, Object ) : SqlParameter;

4. Adds an SqlParameter with the specified name and data type to the parameters collection.

[ VB ] Overloads Public Function Add ( String, SqlDbType ) As SqlParameter

[ C# ] public virtual SqlParameter Add ( string, SqlDbType );

[ C++ ] public: virtual SqlParameter* Add ( String*, SqlDbType );

[ JScript ] public function Add ( String, SqlDbType ) : SqlParameter;

5. Adds an SqlParameter with the specified name, data type, and column width to the parameters collection.

[ VB ] Overloads Public Function Add ( String, SqlDbType, Integer ) As SqlParameter

[ C# ] public virtual SqlParameter Add ( string, SqlDbType, int );

[ C++ ] public: virtual SqlParameter* Add ( String*, SqlDbType, int );

[ JScript ] public function Add ( String, SqlDbType, int ) : SqlParameter;

6. Adds an SqlParameter with the specified name, data type, column width, and source column name to the parameters collection.

[ VB ] Overloads Public Function Add ( String, SqlDbType, Integer, String ) As SqlParameter

[ C# ] public virtual SqlParameter Add ( string, SqlDbType, int, string );

[ C++ ] public: virtual SqlParameter* Add ( String*, SqlDbType, int, String* );

[ JScript ] public function Add ( String, SqlDbType, int, String ) : SqlParameter;

The following example adds a new SqlParameter.

NOTE: This example shows how to use one of the overloaded versions of Add. For other examples that may be available, see the individual overload topics.

public void CreateSqlParamColl ( SqlConnection myConn ) {
   SqlCommand myCmd = new SqlCommand (
      "SELECT * FROM Customers WHERE CustomerID = @CustomerID", myConn );
   SqlParameterCollection myParams = myCmd.Parameters;
   SqlParameter myParam = myParams.Add ( new SqlParameter (
      "@CustomerID", SqlDbType.VarChar, 5, "CustomerID" ) );
}

Public Sub CreateSqlParamColl ( myConn As SqlConnection )
   Dim myCmd As New SqlCommand ( _
      "SELECT * FROM Customers WHERE CustomerID = @CustomerID", myConn )
   Dim myParams As SqlParameterCollection = myCmd.Parameters
   Dim myParam As SqlParameter = myParams.Add ( New SqlParameter ( _
      "@CustomerID", SqlDbType.VarChar, 5, "CustomerID" ) )
End Sub

C#

VB

SqlParameterCollection Members

Suggested Reading

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph