Using System.Web.UI.WebControls.WebParts 10 using System.Web.UI.HtmlControls 11 using NorthwindTableAdapters 12 13 public partial class 14 15 AllProducts System.Web.UI.Page 16 17 protected void 18 19 PageLoadobject sender EventArgs e 20 21 ProductsTableAdapter productsAdapter new 22 ProductsTableAdapter GridView1.DataSource productsAdapter.GetProducts GridView1 .DataBind . Figure 13 List of products displayed in the GridView This example requires us to write three lines of code in the PageLoad event handler of. The ASP.NET web page. In a future tutorial we will discuss using the ObjectDataSource to declaratively retrieve data from the DAL. With the ObjectDataSource we dont have to write a single line of code and we.
Get paging and sorting support! Step 3 Add parameterized methods to the data access belgium phone number data At this point the ProductsTableAdapter has only one method GetProducts which returns all the products in the database. Being able to operate on all products is certainly useful but there are times when we want to get information about a specific product or all the products that belong to. A particular category. To add this functionality to our data access layer we can add parameterized methods to our TableAdapter. Lets add a method. To add a new method to the DAL lets go back to.
The DataSet designer rightclick on it and select Add Query.GetProductsByCategoryIDcategoryIDProductsTableAdapter . Figure 14 Rightclick on the TableAdapter and select Add Query. The wizard will first ask us whether we want to access the database through an adhoc SQL statement generate a new stored procedure or use an existing stored procedure. Lets choose to use SQL statements. Next the wizard will ask us what type. Of SQL query we want to use. Since we want to return all products that belong to a specified category we need to write a SELECTstatement that returns data rows. . SELECTFigure 15 Select to generate.