In this tutorial we will look at how to configure the TableAdapter to use existing stored procedures. Alternatively, you may prefer to create your stored procedures by hand or through some tool other than the TableAdapter wizard that auto-generates your 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. In particular, we examined how to have the TableAdapter wizard automatically create these stored procedures. In the preceding tutorial we saw how the Typed DataSet s TableAdapters could be configured to use stored procedures to access data rather than ad-hoc SQL statements. We also learn how to manually add new stored procedures to our database. In this tutorial we learn how the same TableAdapter Wizard can work with existing stored procedures. In the previous tutorial we learned how to use the TableAdapter Wizard to generate new stored procedures. Using Existing Stored Procedures for the Typed DataSet’s TableAdapters (VB)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |