'Declaration Public Function New( _ ByVal commandText As String _ )
public SqlCommand( string commandText )
Parameters
- commandText
- The text of the query.
'Declaration Public Function New( _ ByVal commandText As String _ )
public SqlCommand( string commandText )
Properties | Initial value |
---|---|
CommandText | commandText |
CommandTimeout | 30 |
CommandType | System.Data.CommandType.Text |
Connection | null |
public void CreateSqlCommand() { string mySelectQuery = "SELECT * FROM Test.Dept"; SqlCommand myCommand = new SqlCommand(mySelectQuery); myCommand.FetchSize = 100; }
Public Sub CreateSqlCommand() Dim mySelectQuery As String = "SELECT * FROM Test.Dept" Dim myCommand As New SqlCommand(mySelectQuery) myCommand.FetchSize = 100 End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2