Internet Application Development

FIT5032: Week 8

Internet Application Development’s eighth week began discussion on data stores. The topics covered included:

  • Introduction to data stores
  • DataSource Controls
  • User Interaction with data sources

Some common data stores include:

  • RDBMS (SQL server, Oracle, MySQL etc)
  • XML
  • Access 🙁
ASP.NET Data access controls

ASP.NET 2.0 Data Source control make it extremely easy to integrate dynamic data access to web applications. In fact, it can be completed with drag and drop. There are 6 standard data source controls in ASP.NET 2.0:

  • SQLDataSoure control
  • LINQDataSource control
  • ObjectDataSource control
  • XMLDataSource control
  • SiteMapDataSource control (used in assignment 2)
  • AccessDataSource control

An example of how simple the code can be using these controls:

<asp:AccessDataSource id="BillNBenDS" runat="server"
DataFile="Billnben.mdb" SelectCommand="SELECT product_id,product_name, " + "product_price, product_url FROM Product_details" />
<asp:GridView id="gvCatalogue" runat="server" DataSourceID="BillNBenDS" CellPadding="3" Font-Names="arial" Font-Size="8pt" HeaderStyle-BackColor="#dcdcdc" HeaderStyle-ForeColor="blue" />
We then covered a walk though of coding and drag and drop methods for implementing dynamic content.
A retrieval of data use case was then analyzed and explained.

Leave a Reply

Your email address will not be published. Required fields are marked *