ADO.NET Introduction

ADO.NET Introduction

ADO.NET is a technology to work with any type of data in .NET applications. ADO.NET can be used in ASP.NET applications as well.

ADO.NET_Architecture

ADO.NET has 2 – Parts:

(i) DataSet Block: DataTable, DataSet, DataView

(ii)Data Provider Block: Connection, DataAdapter, Command, DataReader

DataTable, DataSet, DataView

Similarities:

• All the objects store data at run-time. [In-memory storing of data]

• Work in Connected as well as disconnected mode.

– Gets data from original-source in connected mode.

– In dis-connected mode, they work with web page.

• Reading as well as writing data from / to any type of data source is possible.

Differences between:

DataTable:

1. DataTable

– DataRowsCollection

– DataColumnsCollection

2. Data is stored in original sequence. So sorting is NOT allowed.

3. Column-wise Data-Type can be assigned in a DataTable.

DataSet:

1. DataSet

– DataTablesCollection

– DataRowsCollection

– DataColumnsCollection

2. Data is stored in original sequence. So sorting is NOT allowed.

3. By default, Data-Type for each column is in string format. One XML Schema can be assigned to a DataSet – i.e Typed DataSet.

DataView:

1. DataView

– DataRowsCollection

– DataColumnsCollection

2. Sorting data Column-wise is allowed. And searching in a sorted column is allowed.

3. Data Type for each Column is string-type.

Thanks for your attentions

Ref: Md. Sadiq Sir

Related Information

Introduction to ADO.Net

Using ADO.NET for beginners

R K Gupta

Hi, This is R K Gupta, an IT professional and Entrepreneur. I have written many articles yet for my websites gsesoftsolutions.com, Hope you like it. Kindly subscribe our feed for any updates. Add me in Facebook and Google+

More Posts - Website

Follow Me:
TwitterFacebookPinterestYouTube

Hi, This is R K Gupta, an IT professional and Entrepreneur. I have written many articles yet for my websites gsesoftsolutions.com, Hope you like it. Kindly subscribe our feed for any updates. Add me in Facebook and Google+

Posted in Microsoft .Net Help, Software Development