Database are useful to store and retrieve data in a structured way.Database can be access at run time in your site, which means you are no longer limited to just the relatively static files you …
Read More »Data Access in ASP.NET 4.5
What is a Database?
What is a Database? A database is a collection of data that is arranged so that it can be accessed, managed, and updated easily. The most popular type of database is the relational database. It is the type of database that …
Read More »Different Data Source Controls
Different Data Source Controls In ASP.NET has seven built-in Data Source control, each used for a specific type of Data Access. SqlData Source: – It provides access to any data source that has an ADO.NET Data provider available, by default, …
Read More »Using SQL to work with Database Data
To get data in and out of a database, you need to use Structured Query Language (SQL). This is the main language for querying relational databases that almost all relational database systems understand.
Read More »Retrieving and Manipulating Data With SQL
Retrieving and Manipulating Data With SQL . When interacting with databases, you will use four distinct types of operations Create, Read, Update, and Delete. Reading Data To read data from a database:- First, you need to indicate …
Read More »Displaying and Updating Data
Displaying and Updating Data Here you will learn how to display, insert, update, and delete data using the popular data controls that you can use with ASP.NET. Besides working with the visual controls that are used to display …
Read More »RangeValidator
The RangeValidator control makes sure that the user value or selection provided is within a specified range as opposed to being just greater than or less than a specified constant. You can set the range …
Read More »Compare Validator
The Compare Validator control allow you to compare two form elements as well as to compare values contained within form elements to a constant value that you specify. One of the most common ways of …
Read More »RegularExpressionValidator
The RegularExpression Validator control offers a lot of flexibility when you apply validation rules to your Web Forms. You can check a user’s input based on a pattern that you define using a regular expression. …
Read More »Data Bound Control
Here you will learn how different Data Bound Control will work with the data source control to display, create, edit and delete data.
Read More »Grid View
The GridView is a powerful data Grid control that allows you to display an entire collection of data, add sorting and paging, and perform inline editing. Drag GridView Control from the Toolbox onto the design view of an ASP.NET …
Read More »Details View
The DetailsView Control is a Data-Bound Control that allows you to work with a single data record at a time. It includes features such as paging, updating, inserting and deleting data. Drag DetailsView Control from the Toolbox onto the design view of …
Read More »List View
The ListView control bridges the gap between the highly structured GridView control, and the anything goes, unstructured controls like DataList and Repeater. Drag DetailsView Control from the Toolbox onto the design view of an ASP.NET …
Read More »Other Data Bound Control
ASP.NET contains a variety of other controls that can be bound to data source. Here you will see three more controls.
Read More »Tree View
The TreeView displays hierarchically structured data, so it can be data-bound only to the XmlDataSource and the SiteMapDataSource controls that are designed to bind to hierarchically structured data sources like a SiteMap file.
Read More »