finals programming

ADO.NET

stands for “Active Data Objects,” where its library is a rich framework that retrieves and updates information in various relational databases, which include Microsoft SQL Server, Microsoft Access, Oracle, and XML. It

Data provider

It is used for connecting in the database, recovering results, updating data, and executing commands.

Dataset

It characterizes a local copy of related data tables.

o It is composed of one or more DataTable objects that are manipulated and updated as per the requirements of the users or client.

DataTable

It manages the data for any entity. It contains zero or more rows of data, and each value shown in the data table is identified by the DataColumn.

DataColumn

It includes a data type declaration based on the kind of data saved.

DataRelation

It is used to link two (2) DataTable classes inside the DataSet class.

DataColumnMapping

It is used to map a table name from the database to a DataTable within a DataSet.

DataView

It is used to customize the view of the table or desired view of the rows in a DataTable

Command

It can run SQL commands and perform a stored procedure—accessing and manipulating data

Connection

From the data source, it allows users to connect and disconnect.

DataAdapters

It transfers DataSets between the data source and the caller. It also acts as a connection between the data source and DataSet

DataReaders

It is a read-only access to data using a server-side cursor.

Server Explorer

It is a server management console that is used for logging in to servers, opening data connections, and accessing databases.

Data Connections

It contains all the connections to the server and local databases.

SQL Server Object Explorer

It is used to design, connect to the available database, browse the schema, and create a query on its object.

SqlConnection

This class is used to open a connection using the Open() method. The connection can be closed by calling the Close() method.

ConnectionString

a property that is used to read or assign the connection string to be used by the SqlConnection class

DataSource

a read-only property that returns the name of the SQL Server instance

Database

a read-only property that returns the name of the database

State

a read-only property that returns the current state of the connection.

SqlCommand

This class is used to perform desired processing on the database. It allows executing any direct T-SQL or stored procedure on the server.

ExecuteNonQuery

This method executes the command but does not return output.

ExecuteReader

This method executes the command and returns a DataReader object based on the SQL statement.

SqlDataReader

This object is forward-only and read-only cursor that can be iterated through to fetch the rows in it.

ExecuteRow

It executes the command and returns the SqlRecord object that contains a single returned row

ExecuteScalar

It executes the command and returns the first column of the first row in the result set.

CommandText

It gets or sets the stored procedure or the T-SQL statement.

CommandType

It indicates the way the CommandText property should be interpreted.

SqlParameterCollection

It refers to a collection of parameters that is connected with SqlCommand.

SQL UPDATE

- It is used to modify or update an existing record.

- It uses the WHERE clause to determine the number of records that will be updated.

Property of the Command object • Connection

It gets or sets the SqlConnection class that can be used by the Command object