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
- Create a website using ASP.NET and add SQLDataSourceControl on the web form.
- Click and configure the Data source option
- Create a new connection button to establish a connection with the database
- Once the connection has been set up. You can configure the select statement
- Add a grid view in the data source and format the control
- Execute the application