---
title: "What is DataAdapter?"  
description: "What is DataAdapter?"  
author: "Sumit Kesarwani"  
published: 2014-01-27  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/1887/what-is-dataadapter  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What is DataAdapter?

DataSet contains the data from the DataAdapter which is the bridge between the DataSet and Database. DataAdapter provides the way to retrieve and save data between the DataSet and Database. It accomplishes this by means of request to the SQL Commands made against the database.

## Answers

### Answer by MindStick Software Pvt Ltd

**DataAdapter** helps in linking the database and connection object. DataAdapter provides communication between Dataset and data sources.

Data moves ‘in and out’ of the Dataset through DataAdapter.

## The properties of DataAdapter that allow the user to control the database are:

- Select Command
- Update Command
- Insert Command
- Delete Command

### Answer by Sumit Kesarwani

DataSet contains the data from the DataAdapter which is the bridge between the DataSet and Database. DataAdapter provides the way to retrieve and save data between the DataSet and Database. It accomplishes this by means of request to the SQL Commands made against the database.


---

Original Source: https://www.mindstick.com/interview/1887/what-is-dataadapter

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.