Gets or sets a Transact-SQL statement or stored procedure used to select records in the data source.
Syntax
[System.ComponentModel.Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
[System.ComponentModel.DefaultValue(null)]
public SqlCommand SelectCommand { set; get; }
[System.ComponentModel.DefaultValue(null)]
public SqlCommand SelectCommand { set; get; }
Value
Documentation for this section has not yet been entered.
Remarks
When SqlDataAdapter.SelectCommand is assigned to a previously created System.Data.SqlClient.SqlCommand, the System.Data.SqlClient.SqlCommand is not cloned. The SqlDataAdapter.SelectCommand maintains a reference to the previously created System.Data.SqlClient.SqlCommand object.
If the SqlDataAdapter.SelectCommand does not return any rows, no tables are added to the System.Data.DataSet, and no exception is raised.
Requirements
Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0