Updating is not supported by data source sqldatasource1 unless updatecommand
I'm running VS 2005 ; do I need some specific references / ? familyid=F63D1F0A-9877-4A7B-88EC-0426B48DF275&displaylang=en I think you can make it work, I update rows with that grid as well... Likewise I'm not seeing a datagridview ; I only have a gridview object. Selected Valuegrated Security=SSPI; Initial Catalog=APAY") connection.
thanks I use application blocks, but you don't need it. Perhaps once I reference it properly I'll have use of that object, but how should I do that.
Works fine - but I'd like for it to auto-generate the updatecommand for me when the selectcommand is changed. Select Command = "select * from " & Drop Down List1. I can't seem to get any values on the update overload... Row Editing, Address Of Grid View_Row Editing Add Handler Grid View1. Data Bind() End Sub Sub Grid View_Row Updating(By Val Thanks.I then added a Details View and Auto Generate options for insert, delete and update buttons to True to display the links for these functions. Then I could change the command strings for the update and delete commands to: Delete Command="DELETE Members WHERE [email protected]_id" Update Command="UPDATE Members SET [email protected]_Name, ... But The Learned One is correct that I could delete the parameters for all the commands.But when I click any of these, I receive the error message "Updating is not supported by data source 'Sql Data Source1' unless Update Command [or Delete Command or Insert Command] is specified. Hi all, I have a gridview that bound to a Sql Data Source called Sql Data Source Grid View.I have enabled Edit in my Grid View, but I do all the updating in code behind with stored procedure (using on Row Updating).
while configurting sqldatasource when you configure the select statement for the gridview,there is a option as "advanced".click on that and then click on 'generate update,insert nad delete statements".