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 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"
/>