SqlParameter.SourceColumn Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
public:
virtual property System::String ^ SourceColumn { System::String ^ get(); void set(System::String ^ value); };
public:
property System::String ^ SourceColumn { System::String ^ get(); void set(System::String ^ value); };
public override string SourceColumn { get; set; }
[System.Data.DataSysDescription("DataParameter_SourceColumn")]
public string SourceColumn { get; set; }
member this.SourceColumn : string with get, set
[<System.Data.DataSysDescription("DataParameter_SourceColumn")>]
member this.SourceColumn : string with get, set
Public Overrides Property SourceColumn As String
Public Property SourceColumn As String
Property Value
The name of the source column mapped to the DataSet. The default is an empty string.
Implements
- Attributes
Examples
The following example creates a SqlParameter and sets some of its properties.
static void CreateSqlParameterSourceColumn()
{
SqlParameter parameter = new SqlParameter("Description", SqlDbType.VarChar, 88);
parameter.SourceColumn = "Description";
}
Private Sub CreateSqlParameterSourceColumn()
Dim parameter As New SqlParameter("Description", SqlDbType.VarChar, 88)
parameter.SourceColumn = "Description"
End Sub
Remarks
When SourceColumn is set to anything other than an empty string, the value of the parameter is retrieved from the column with the SourceColumn name. If Direction is set to Input
, the value is taken from the DataSet. If Direction is set to Output
, the value is taken from the data source. A Direction of InputOutput
is a combination of both.
For more information about how to use the SourceColumn property, see DataAdapter Parameters and Updating Data Sources with DataAdapters.
Applies to
See also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om