Explain all the classes those are used for database connections between sql server and asp.net?
Submitted by: Administrator1.SqlClientPermission - Enables the .NET Framework Data Provider for SQL Server to help ensure that a user has a security level adequate to access a data source.
2.SqlClientPermissionAttribute - Associates a security action with a custom security attribute.
3. SqlCommand - Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
4.SqlCommandBuilder - Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.
5. SqlConnection - Represents an open connection to a SQL Server database. This class cannot be inherited.
6.SqlDataAdapter - Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.
7.SqlDataReader - Provides a means of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
8.SqlError - Collects information relevant to a warning or error returned by SQL Server. This class cannot be inherited.
9.SqlErrorCollection - Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
10.SqlException - The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
11.SqlInfoMessageEventArgs - Provides data for the InfoMessage event. This class cannot be inherited.
12.SqlParameter - Represents a parameter to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.
13.SqlParameterCollection - Represents a collection of parameters relevant to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.
14.SqlRowUpdatedEventArgs - Provides data for the RowUpdated event. This class cannot be inherited.
15.SqlRowUpdatingEventArgs- Provides data for the RowUpdating event. This class cannot be inherited.
16. SqlTransaction - Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
Submitted by: Administrator
2.SqlClientPermissionAttribute - Associates a security action with a custom security attribute.
3. SqlCommand - Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
4.SqlCommandBuilder - Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.
5. SqlConnection - Represents an open connection to a SQL Server database. This class cannot be inherited.
6.SqlDataAdapter - Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.
7.SqlDataReader - Provides a means of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
8.SqlError - Collects information relevant to a warning or error returned by SQL Server. This class cannot be inherited.
9.SqlErrorCollection - Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
10.SqlException - The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
11.SqlInfoMessageEventArgs - Provides data for the InfoMessage event. This class cannot be inherited.
12.SqlParameter - Represents a parameter to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.
13.SqlParameterCollection - Represents a collection of parameters relevant to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.
14.SqlRowUpdatedEventArgs - Provides data for the RowUpdated event. This class cannot be inherited.
15.SqlRowUpdatingEventArgs- Provides data for the RowUpdating event. This class cannot be inherited.
16. SqlTransaction - Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
Submitted by: Administrator
Read Online ADO.NET 2.0 Job Interview Questions And Answers
Top ADO.NET 2.0 Questions
☺ | How to add a check box or a dropdown list to a column in a datagrid? |
☺ | Explain Advantages of ADO.Net? |
☺ | How to identify the updated rows in a dataset? |
☺ | What is difference in Record set and Dataset? |
☺ | What is difference between ado and ado.net? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |