Clone Method (SqlCommand)

In This Topic

Creates a new object that is a copy of the current SqlCommand instance.

Syntax

Visual Basic
C#

'Declaration
 
Public Function Clone() As SqlCommand

public SqlCommand Clone()

Return Value

A new SqlCommand object in which all property values are the same as the original.

Remarks

Use this method when you need to create a new SqlCommand object that is absolutely like existing one.

Example

This example shows how to clone a SqlCommand . To make sure all the properties are inherited, one of them (CommandText) is written to the console.

csharp

public void CloneACommand()
{
  SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept");
        SqlCommand myCommand2 = (SqlCommand)myCommand.Clone();
  Console.WriteLine(myCommand2.CommandText);
}

Visual Basic

Public Sub CloneACommand()
  Dim myCommand As New SqlCommand("SELECT * FROM Test.Dept")
  Dim myCommand2 As SqlCommand = CType(myCommand.Clone(), SqlCommand)
  Console.WriteLine(myCommand2.CommandText)
End Sub

Reference

SqlCommand Class
SqlCommand Members

Send Feedback