C# Mastery Hub
Home
Challenges
Discussion
Lessons
Core Topics
C# Fundamentals
Console Applications
Classes & OOP
Windows Forms
ASP.NET Core
SQL Server
VS & SQL Connection
RDLC Reports
.NET MAUI
Getting Started
Getting Started
Website Development
SEO Guide
Security
Project Workflow
Extra Topics
Cloud & Deployment
AWS Cloud
Deployment
About
Contact
Test Your Knowledge
VS + SQL - Lesson 4: DataReader vs DataAdapter Quiz
Answer all questions to test your understanding
1
What is the main characteristic of SqlDataReader?
Loads all data into memory at once
Reads data forward-only, one row at a time
Allows editing data offline
Stores data in a DataSet
2
What is the main characteristic of SqlDataAdapter?
Reads data one row at a time
Loads data into a DataTable for offline access
Only executes stored procedures
Connects to multiple databases
3
Which one is better for binding to a Windows Forms DataGridView?
SqlDataReader
SqlDataAdapter
They are both the same
Neither works
4
Which one is more memory efficient for reading large datasets?
SqlDataAdapter
SqlDataReader
They use the same memory
Neither is memory efficient
5
What method fills a DataTable using SqlDataAdapter?
Load()
Fill()
Read()
Execute()
Submit Quiz