You need this to identify the specific, distinct record you're updating.
Using Visual Studio 2005 to create asp web page I have a drop down list to veiw a list of customers.
When I make a selection in that list a formview is populated with the details of that customer.
The statement can include parameters if the data source supports them.
Parameters are used to send values for insert, update, and delete operations to the data source.
Indeed, you did not specify the Update Command for the SQLData Source and thus the ASPx Grid View cannot update data in the SQLData Source.
If you bind the standard Grid View to this Data Source, the problem will be the same.
Description: An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it originated in the code. Not Supported Exception: Updating is not supported by data source ' Sql Data Source Grid View' unless Update Command is specified.
I then have a button to edit records on that formview and a button to insert a new customer. Insert) End Sub Protected Sub cmd Edit Customer_click Form View1. Edit) The errors I get when I click the insert of update words at the bottom of the Form View are: "updating is not supported by data source 'Sql Data Source1' unless Update Command is specified" or "inserting is not supported by data source 'Sql Data Source1' unless Insert Command is specified." Can someone help me with this problem Thanks ="INSERT INTO dbo.
When I click the Insert new customer button or the Update button I have the following code: Protected Sub cmd New Customer_click...... Customer_Update(Cust Num, Last Name, First Name, Mid Init, Address1, Address2, City, State, Zip, Active Date, Date2, Date3, Home Phone, Work Phone, Dept, Cust Title, Cust Code, Cust Type, Status) Values(@Cust Num Text Box, @Last Name Text Box, @First Name Text Box, @Mid Init Text Box, @Address1Text Box, @Address2Text Box, @City Text Box, @State Text Box, @Zip Text Box, @Active Date Text Box, @Date2Text Box, @Date3Text Box, @Home Phone Text Box, @Work Phone Text Box, @Dept Text Box, @Cust Title Text Box, @Cust Code Text Box, @Cust Type Text Box, @Status Text Box)"="SELECT Cust Num, Last Name, First Name, Mid Init, Address1, Address2, City, State, Zip, Active Date, Date2, Date3, Home Phone, Work Phone, Dept, Cust Title, Cust Code, Cust Type, Status FROM dbo.