Updating gridview rows using sqldatasource
main problem is how to Add new record on gridview using SQLDatasource without any code behind code? Please remember to click “Mark as Answer” on the post that helps you.
experts please help me hi look at this : Startv20/aspnet/doc/ctrlref/data/ hi there is comple gridview article in partwise...learn anyone from them to solve ur issue. everybody simply explained about Update/Delete/Select only. i have added the Insert query into the Sql Datasource but i when i click New button on the GV the textboxes no appearing, how to resolve this? This can be beneficial to other community members reading the thread.
Figure 40 Figure 41 In Figure 41 notice how the Product ID column is not editable. NET page's declarative syntax below shows, you can mark a Grid View column as non-editable by settings its Read Only property to True.
When poking through the markup below, be sure to take note of the following: checking the Use optimistic concurrency checkbox.
Next, we'll see how to create an editable Grid View from an Object Data Source.
If you checked that along with the Generate Insert, Update, and Delete Statements checkbox, the Update Command for the Sql Data Source would have included a more thorough WHERE clause.