Inserting updating and deleting data with the sqldatasource
Insert Command = "insert into milestone (branch,ko,ks,customer) values (@dd1,@dd2,@dd3,@dd4)"; //Sql Data Source1. You are not allowing nulls in any of your columns so any missing parameter would cause a sql insert error. You can change them to allow nulls (except your primary key columns).
Once this is done the Sql Data Source will automatically pick values from respective Text Boxes inside the Grid View row to be edited.Again, to reiterate, you cannot use a SQL View for this, you must use a datasource object for CRUD. Its Provide / return a set of table values in a beetre manner.but there is a way to Update a View, Please Follow the link below Rad Grid can extract values from columns that are set as read-only, if the column's Force Extract Value property is set to: The default value for the Force Extract Value property is "None", which means that the extraction of default values will not be performed for read-only columns.Automatic operations through the Data Source control are not supported when you use standard Web User Control as a custom edit form.