SqlCeCommand.CreateParameter Method
Creates a new instance of a SqlCeParameter object.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Function CreateParameter As SqlCeParameter
'Usage
Dim instance As SqlCeCommand
Dim returnValue As SqlCeParameter
returnValue = instance.CreateParameter
public SqlCeParameter CreateParameter ()
public:
SqlCeParameter^ CreateParameter ()
public SqlCeParameter CreateParameter ()
public function CreateParameter () : SqlCeParameter
Return Value
A SqlCeParameter object.
Remarks
The CreateParameter method is a strongly-typed version of CreateParameter.
Example
The following example creates a SqlCeCommand and uses the CreateParameter property to create parameters.
Dim conn As SqlCeConnection = Nothing
Dim rdr As SqlCeDataReader = Nothing
Try
conn = New SqlCeConnection(connStr)
conn.Open()
Dim cmd As New SqlCeCommand("SELECT * FROM myTable", conn)
cmd.Connection.Open()
rdr = cmd.ExecuteReader()
While rdr.Read()
Console.WriteLine(rdr.GetString(0))
End While
Finally
rdr.Close()
conn.Close()
End Try
SqlCeConnection conn = null;
SqlCeDataReader rdr = null;
try
{
conn = new SqlCeConnection(connStr);
conn.Open();
SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM myTable", conn);
cmd.Connection.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr.GetString(0));
finally
{
rdr.Close();
conn.Close();
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .
Platforms
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Version Information
.NET Compact Framework
Supported in: 2.0, 1.0
See Also
Reference
SqlCeCommand Class
SqlCeCommand Members
System.Data.SqlServerCe Namespace