Update command net

Download Microsoft Edge More info. Contents Exit focus mode. Ole DbData Adapter. Update Command Property Reference Is this page helpful?

Please rate your experience Yes No. Any additional feedback? For more information, see LoggerVerbosity. The version range of the tool package to update to. This cannot be used to downgrade versions, you must uninstall newer versions first. Updates the dotnetsay global tool.

Updates the dotnetsay global tool located in a specific Windows directory. Updates the dotnetsay local tool installed for the current directory. Updates the dotnetsay global tool to the latest patch version, with a major version of 2 , and a minor version of 0.

For more information on semantic versioning ranges, see NuGet packaging version ranges. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Thank you. Microsoft makes no warranties, express or implied, with respect to the information provided here. Gets or sets a Transact-SQL statement or stored procedure used to update records in the data source. It assumes you have already created a SqlConnection object. During Update , if this property is not set and primary key information is present in the DataSet , the UpdateCommand can be generated automatically if you set the SelectCommand property and use the SqlCommandBuilder.

Then, any additional commands that you do not set are generated by the SqlCommandBuilder. This generation logic requires key column information to be present in the DataSet. SqlClient , which is the default provider for the SqlDataSource class, the placeholder of the parameter is ' parameterName'. However, if the provider is set to the System. Odbc or System. OleDb , the placeholder of the parameter is '? The UpdateCommand property can be an SQL string or the name of a stored procedure, if the data source supports stored procedures.

For security purposes, the UpdateCommand property is not stored is view state. Because it is possible to decode the contents of view state on the client, storing sensitive information about the database structure in view state could result in an information disclosure vulnerability. Values are inserted into parameters without validation, which is a potential security threat.