ASP.NET

ASP.NET - Database Access

ASP.NET - Database Access

ASP.NET allows sources of database to be used.

  • Databases(Access, SQL, Oracle, MySQL)
  • XML documents
  • Business Objects
  • Flat Files

ADO.net  is the bridge between ASP.NET  object and backend data source.

Retrieve and display data

There are two types of data control to retrieve data in ASP.NET

  • Source data control
  • Data view control

Steps to take action

  1. Create a website using ASP.NET  and add SQLDataSourceControl on the web form.
  2. Click and configure the Data source option
  3. Create a new connection button to establish a connection with the database
  4. Once the connection has been set up. You can configure the select statement
  5. Add a grid view in the data source and format the control 
  6. Execute the application