Also if we want to retrieve an Output parameter of stored procedure, for example, we can use the Inserted (Updated / Deleted) events of SQLData Source.
This is a sample of retrieving an output parameter’s value in Inserted event of SQLData Source Protected Sub Sql Data Source1_Inserted(By Val sender As Object, By Val e As System.
The Object Data Source control is particularly suited for declarative programming and, in general, all those scenarios where your information fits well in the control s programming interface.
A slogan I usually apply to the Object Data Source control is, either easy or nothing.
I’ve just learned about another interesting solution which is presented in Peter Kellner’s blog. The solution I’m familiar with and used is to set the parameter in Selecting (Inserting / Updating for Insert / Update) events of SQLData Source.
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 ...
Net and when the Row is double clicked the Row will be edited. Net Grid View with three columns of which two are Bound Fields and one is a Template Field column with Update and Cancel Link Buttons which will be visible when the row is edited.
The Grid View is populated using some dummy records using Data Table, you can populate it from database too.