The purpose of the project was to investigate how SQL is embedded in C#.NET database applications as well as Java database applications.This article describes in complete detail how to connect to a MS SQL Server database from C#.NET database application as well as a Java database application.Generally we will use Execute Reader object to bind data to datareader.To bind Data Reader data to Grid View we need to write the code like as shown below: Data Set Data Set is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of Data Tables and relations between tables. You can select data form tables, create views based on table and ask child rows over relations. NET components categorized in three modes: disconnected, common or shared and the . Shared or common components are the base classes for data providers and shared by all data providers. NET applications for data source communication using a driver or provider: Answer 2: ADO. For example, you can use a Data Table object with or without providers and shared or common components are the base classes for data providers.
SQL or Structured Query Language is a programming language used by the popular database management systems (DBMSs) to store, manipulate and retrieve any data in the database.
This means if you enable Connection pooling in the connection object, actually you enable the re-use of the connection to more than one user. NET uses a technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections.
Connection pooling reuses existing active connections with the same connection string instead of creating new connections when a request is made to the database.
Wish I could use this, but the code which fills the dataset is part of a method which returns the filled dataset.
Might not be applicable here but maybe in the future. Count == o this will count the number of rows that are in data set.