Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Item Property (String)
Collapse the table of content
Expand the table of content

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; }


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

Property Value

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


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;

© 2015 Microsoft