41⟩ what is data Adapter?
Data adapter is bridge between Connection and DataSet , Data adapter in passing the sql query and fill in dataset
“ADO.NET Interview Questions and Answers will guide us now that ADO.NET is a set of computer software components that can be used by programmers to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also be used to access data in non-relational sources. Learn ADO.NET with ADO.NET Interview Questions and Answers”
Data adapter is bridge between Connection and DataSet , Data adapter in passing the sql query and fill in dataset
DS.Tables["tabname"].Rows.Count;
we can get count of the records.