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 is frequently used in websites. A relational database has the concept of tables, where data is stored in rows and columns, much like a …

What is a Database? 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, the control has access to the ODBC, OLE DB, SQL Server, Oracle, and SQL Server Compact providers. LinqDataSource: – It provides access to different …

Different Data Source Controls 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 the columns from the table that you want to retrieve for a query. You will do that with the SELECT statement. …

Retrieving and Manipulating Data With SQL 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 and edit data in a web page, you will also learn how to work with the SqlDataSource control that acts as the bridge between …

Displaying and Updating Data 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 using the MaximumValue and MinimumValue properties. The RangeValidator control also makes sure that what is entered and what kind of …

RangeValidator 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 Web Page, which has been used with SqlData Source Control. Here is a Simple Use of GridView Control To display …

Grid View 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 an ASP.NET Web Page, which has been used with SqlData Source Control. Here is a Simple Use of DetailsView Control …

Details View 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 Web Page, which has been used with SqlData Source Control. Here is a Simple Use of ListView Control To display …

List View 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.

Menu

The Menu control is capable of displaying hierarchical data in a vertical pop-out style menu, so it can be data-bound only to the XmlDataSource and the SiteMapDataSource controls.

Chart in ASP.NET

This control is useful for running some good-looking charts. The Chart server control supports many chart types as follows: Point FastPoint Bubble Line Spline StepLine FastLine Bar StackedBar StackedBar100 Column StackedColumn StackedColumn100 Area SplineArea StackedArea Drag the Chart control from the Toolbox which is under the Data Tab.when you drag it onto the Design View …

Chart in ASP.NET Read More »

Scroll to Top