Contents
Can we modify data in a view?
If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can’t delete rows. You can’t directly modify data in views based on union queries. You can’t modify data in views that use GROUP BY or DISTINCT statements.
Can you pull data from a view?
In a VIEW, we can also control user security for accessing the data from the database tables. We can allow users to get the data from the VIEW, and the user does not require permission for each table or column to fetch data.
How to insert, updating, and deleting data?
These data modification capabilities can be plugged directly into a data source control without a line of code needing to be written. An Overview of Inserting, Updating, and Deleting examined using the ObjectDataSource to facilitate inserting, updating, and deleting with the GridView, DetailsView, and FormView controls.
What can be used in place of the objectdatasource?
Alternatively, the SqlDataSource can be used in place of the ObjectDataSource. Recall that to support inserting, updating, and deleting, with the ObjectDataSource we needed to specify the object layer methods to invoke to perform the insert, update, or delete action.
How to use existing stored procedures for the typed DataSet’s?
Open the ExistingSprocs.aspx page in the AdvancedDAL folder and drag a DropDownList from the Toolbox onto the Designer. Set the DropDownList s ID property to Categories and its AutoPostBack property to true. Next, from its smart tag, bind the DropDownList to a new ObjectDataSource named CategoriesDataSource.
Are there stored procedures in the tableadapter Wizard?
In particular, we examined how to have the TableAdapter wizard automatically create these stored procedures. When porting a legacy application to ASP.NET 2.0 or when building an ASP.NET 2.0 website around an existing data model, chances are that the database already contains the stored procedures we need.