Updating is not supported by data source unless updatecommand

Hi I have a Details View that is bound to a sql server.Problem is when I press the auto generated Edit button make some change and press the Update link I get the below error; Updating is not supported by data source 'mysqlserver' unless Update Command is specified.On the onclick event if the button the records are inserted into the SQL Server Database and the Grid View is updated You can view above I am simply getting the data from the textboxes in the Footer Row and then firing an update query along with the select query so that the ASP. The figure below displays the Edit and Update functionality.

updating is not supported by data source unless updatecommand-67

The CTE result set is derived from a simple query and is referenced by UPDATE statement.

Common table expressions can also be used with the SELECT, INSERT, DELETE, and CREATE VIEW statements.

Page Request Manager Server Error Exception: Updating is not supported by data source ' Existing Sql Source' unless Update Command is specified.

Updating is not supported by data source ' Sql Data Source1' unless Update Command is specified. Update(IDictionary keys, IDictionary values, IDictionary old Values, Data Source View Operation Callback callback) 92 System.

Raise Bubble Event(Object source, Event Args args) 37 System.

Net Grid View Add (Insert), Edit, Update and Delete functionality, but this is different and how I’ll explain as we progress. The following code samples that demonstrate how to use the Ole Db Data Adapter object to update an OLEDB Data Source using Update Command properties in Ole Db Data Adapter. The Insert Command, the Update Command, and the Delete Command properties of the Ole Db Data Adapter object update the Data Source with the data modifications that are run on a Data Set object. Ole Db Public Class Form1 Private Sub Button1_Click(By Val sender As System. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Net Grid View simple and also combining the powers of ASP.

Tags: , ,