Sqldatasource updating gridview

NET 2.0 introduces three new data Web controls: the Grid View, the Details View, and the Form View.

Future installments will explore more advanced updating scenarios, such as customizing the Grid View's editing interface and programmatically setting the updated values. The UPDATE Table Name SET Column Name1 = @Parameter Value1 Column Name2 = @Parameter Value2 ...

Unlike Details View, Form View control doesn't have predefined data layout.

This article is one in a series of articles on ASP. In particular, we look at enabling editing support in the Grid View. This article focuses on the Sql Data Source control; for a detailed look at updating with the Object Data Source, refer to the "Editing, Inserting, and Deleting" tutorials in my Working with Data in ASP. Let's explore the updating "action" for the Access Data Source and Sql Data Source controls in more detail.

Column Name N = @Parameter Value N WHERE Primary Key Column Name1 = @Primary Key Value To Update1 AND Primary Key Column Name2 = @Primary Key Value To Update2 AND ...

AND Primary Key Column Name N = @Primary Key Value To Update N , in this instance - has its value specified via the data source control's Select Parameters, which can specify a source for the parameter value.

If you place Form View control to web form you'll see that it not appears very user friendly at first look.

There is only gray rectangle, like in image bellow: Unlike Details View control, there is no predefined template in Form View control.

Leave a Reply