SqlCeParameterCollection.Item Property (String)

Gets or sets the SqlCeParameter with the specified name.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

public SqlCeParameter this[
	string parameterName
] { get; set; }

Parameters

parameterName
Type: System.String
The name of the parameter to retrieve.

Property Value

Type: System.Data.SqlServerCe.SqlCeParameter
The SqlCeParameter with the specified name.

ExceptionCondition
IndexOutOfRangeException

The name specified does not exist.

The Item property is an indexer to the collection. To set the properties of a specific item, you reference the item by its number or name.

The following example adds a SqlCeParameter object to SqlCeParameterCollection, and then sets the value of the first parameter (0 in the collection). This example assumes that a SqlCeCommand has already been created.

SqlCeDataAdapter da = new SqlCeDataAdapter();

SqlCeConnection conn = new SqlCeConnection("Data Source = MyDatabase.sdf");
SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM Customers WHERE Country = @country", conn);

cmd.Parameters.Add("@country", SqlDbType.NVarChar, 15);
cmd.Parameters[0].Value = "UK";

da.SelectCommand = cmd;


Show: