Multiple Inheritance was not allowed in .Net to avoid "Diamond Problem" (Where a class inherits from two classes which are both inherited from a same base class. Then on invoking the base functions the compiler may get confused to call which function... Read More

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... Read More

ADO is used in windows based application and ADO.NET is used in web based application. Read More

ADO.NET features are included in the Microsoft.NET framework. It has software components which help in data access and services. This can be used to make changes to RDBMS and non relational data base systems. This technology is considered to be the... Read More

The static modifier is used to declare a static member, which belongs to the type itself rather than to a specific object. The static modifier can be used with fields, methods, properties, operators, events and constructors, but cannot be used with... Read More

An Abstract class has abstract methods. An Abtsract class can not be instanitiated directly. All the abtract methods are implemented in the derived class. There is no multiple inheritance here. Interface class also has abstract methods and all of... Read More

The connected environment of data access is the traditional procedure for accessing data programmatically. The differentiating property of the connected data access environment is that here you (the programmer) is required to manage the connection... Read More

Data Reader worked as conventional Record Set of VB but Data Set Can store a complete database with all the relations and constraints. Data Reader worked in Read only where as Data Set provide u the flexibility of Updating data also. Data... Read More

The System.Data namespace contains the interfaces implemented by different dot net framework data providers, such as: * IDbConnection implemented by SqlConnection, OracleConnection, OleDbConnection, OdbcConnection classes represents a connection... Read More

ADO.Net introduces the concept of disconnected data architecture. In traditional data access components, you make a connection to the database system and then interact with it through SQL queries using the connection. The application stays... Read More

No, each have its own functionality, ex : for sql client , there is SqlConnection object and for oledb client , there is OleDBConnection Read More

Since no memory buffer is maintained by the data reader, it takes up fewer resources and performs more efficiently with small number of data operations. The dataset, on the other hand is more efficient when large number of updates are to be made to... Read More

Once you have the UpdateCommand prepared in the data adapter, you can update individual records simply by updating the field values in the data table?s rows. The above code demonstrate how we can update the ?lines? field of the third record of the... Read More

The procedure for updating records using INSERT commands is very similar to the one we presented in the previous example (of SELECT) except that here the command does not return anything and thus the method to call on the SqlCommand object is called... Read More

System.Reflection Namespace Read More

Active X data objects are used to access data sources and it is based upon the Component object model. This technology allows data base developers to write program without the knowledge of how database is implemented. Knowledge of SQL is absolutely... Read More

Some of the several objects which ADO consists are as follows they are * Connection object is responsible for creating a connection to the database. * Record object represents data which is not from the database. * Parameter object represents a... Read More

Repeater Control just reads the information from the database,so edit is not possible... Read More

public partial class UseDataList : System.Web.UI.Page { protected DataTable GetInventory() { String strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0; DataSource=C:... Read More

Yes, you can connect two datareader to the same datasource, but one mainthing is close the first datareader before using second one then only it's possible. Read More

SQLCommand is used to retrieve or update the data from database. You can use the SELECT / INSERT,UPDATE,DELETE command with SQLCommand. SQLCommand will execute these commnds in the database. SQLBUILDER is used to build the SQL Command like... Read More

Using the power of the SQL Profiler and running a simple trace to capture the performance of your stored procedures can easily obtain these query lists. that needs tuning. Read More

To read data from the database, you first make a connection object (SqlConnection, etc) and open it. C# Version string connString = " server=FARAZ; database=programmersheaven;" + "uid=sa; pwd="; SqlConnection conn = new SqlConnection(connString);... Read More

In the connected environment, it is your responsibility to open and close the database connection. You first establish the database connection, perform the interested operations to the database and when you are done, close the database connection.... Read More

The dataset is generally used when you like to employ the disconnected architecture of the ADO.Net. It reads the data into the local memory buffer and perform the data operations (update, insert, delete) locally to this buffer. The data reader, on... Read More

he differences includes In ADO, the in-memory representation of data is the Recordset. In ADO.net, it is the dataset A recordset looks like a single table in ADO In contrast, a dataset is a collection of one or more tables in ADO.net ADO is... Read More

The data reader is more useful when you need to work with large number of tables, database in non-uniform pattern and you need not execute the large no. of queries on few particular table. When you need to work on fewer no. of tables and most of the... Read More

ADO.Net also contains some database specific classes. This means that different database system providers may provide classes (or drivers) optimized for their particular database system. The provider for such classes are called the Dot Net... Read More

Dot Net Framework Data Provider is a set of classes that establishes the database communication between an application and the database management system based on the standards of ADO.Net framework. Different data providers provide specialized and... Read More

OleDbConnection1.Open() OleDbDataAdapter1.Fill(DataSet21, 5, 15, ?tab?) Read More

DataReader is connected object and one can process the rows that are returned by query, one at a time. It discards every row after you have gone through it and so it is extremely fast.It contains only read-only data, so no updates are allowed using... Read More

DateReader is an forward only and read only cursor type if you are accessing data through DataRead it shows the data on the web form/control but you can not perform the paging feature on that record(because it's forward only type). Reader is... Read More

There are several languages which implement ADO technology out of which these are some of the basic they are VB script in ASP, Visual Basic, Delphi, C++, and Microsoft environments. ADO.NET is a new addition to ADO. Read More

Some of the basic steps which should be taken to access and manipulate data are as follows. * Creating connection object which helps to connect to a database. * Record set object should be created which facilitates connection to receive data. *... Read More

This feature should be used when you have a long list of results and you need to process one at a time. It provides only two features which is read and forward only. Records should be accessed sequentially. Previously accessed records cannot be... Read More

Language integrated query or LINQ provides developers to query data. It uses strongly typed queries and results. Developer productivity increases by the usage of compile time error checking and intellisense. This feature is common on number of data... Read More

ADO.NET has number of combinations of patterns and resources of libraries. This creates a feature which integrates data services with web. It contains formats which represent data such as JSON and plain XML. This form of interaction enables... Read More

This feature allows LINQ query capabilities and it specifically forms a part of the .NET framework. This feature allows developers to program in ADO.NET and ORM. This feature also allows access to third party database. This provides new features to... Read More

Implementation of INSERT, DELETE and UPDATE commands is automatic and this class provides the necessary automation. You cannot extend or change the command builder while keeping the base algorithm intact to create action statements. Read More

ADO.NET utilizes the power of XML by providing disconnected access to data. This is designed with the help of XML classes in .NET Framework which form the components of single architecture. Read More

The dataset is represented in the memory as an XML document. You can fill the dataset by XML and can also get the result in the form of XML. Since XML is an international and widely accepted standard, you can read the data using the ADO.Net in the... Read More

The Data Adapter contains in it the Command and Connection object. It uses the connection object to connect to the database, execute the containing command, fetch the result and update the DataSet. Read More

The dot net framework data provider for OLEDB provides connectivity with the OLEDB supported database management systems. It is the recommended middle tier for the SQL Server 6.5 or earlier and Microsoft Access Database. It is a general data provider... Read More

Data access using ADO.Net involves the following steps: * Defining the connection string for the database server * Defining the connection (SqlConnection, OleDbConnection, etc) to the database using the connection string * Defining the command ... Read More

You can read the records from the data table using its Rows collection. With the Rows collection, you need to specify the row number and column name or number to access a particular field of the specified row. For example, if we have read the ... Read More

THERE CAN BE AT THE MOST 1 CLUSTERED INDEX FOR ONE TABLE IN SQL SERVER Read More

A stored procedure is a precompiled executable object that contains one or more SQL statements. A stored procedure may be written to accept inputs and return output. Read More

Here we are presenting a brief review of four basic type of stored procedure for SELECT, INSERT, UPDATE and DELETE operations. In SQL Server, you can create and add stored procedures to your database using the SQL Server Enterprise Manager. UPDATE... Read More

Using stored procedures with ADO.Net in C# is extremely simple, especially when we have developed the application with SQL commands. All we need is: * Create a command object (SqlCommand, etc) and specify the stored procedure name * Set the... Read More

Data Grid is the standard control for viewing data in .Net environment. A data grid control is represented in .Net by System.Windows.Forms.DataGrid class. The data grid control can display the data from a number of data sources e.g. data table,... Read More

May be there is a better way, but you can generating a datatable from source and load it to destination if the process is successful, execute the drop table query. Read More

Let?s create a simple application first that loads a table data from database server to the data grid control. First of all, add a data grid control and a button to your form from Visual Studio toolbox. We have set the Name property of data grid to ... Read More

Ok, let?s discuss some of the issues and their solution briefly. The specific detail of these solutions is given in the next FAQs. * The easiest and very sound solution is to provide the database script to create necessary database and tables... Read More

The problem arises when you are using the general data providers such as classes from System.Data.OleDb and System.Data.Odbc namespaces. You can?t make a general GUI to generate the connection string for all the database servers. Then what to do now?... Read More

We will start with the assumption that you have a data access application. Note that we are only providing here the C# example. The VB.Net example is exactly similar. Why we didn?t include the VB.Net example? Because, the intent here is not to... Read More

ADO and ADO.NET are different in several ways: ? ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time. This is barring, of course, you... Read More

I will give the cod e for itComboBox1.DataSorce = ds;ComboBox1.DataTextField = "ColumnNameOfTheTable";ComboBox1.DataBind(); Read More

Ado.net uses dataset for accessing the data , since the dataset is created in client side there is no need of connection at the time of working on dataset ,to the server(where the database is present), so this makes the data accessing faster mainly... Read More

Question : 1,how to protect the cookies in particular textbox?it means in web page some text box allow cookies, some box does not allow cookies. how to do it?please reply me. 2,how to calculate the particular user hit our webpage?(... Read More

The data adapter stores your command (query) and connection and using these connect to the database when asked, fetch the result of query and store it in the local dataset. The DataAdapter class (SqlDataAdapter, OracleDataAdapter,... Read More

A data adapter is the component that exists between the local repository (dataset) and the physical database. It contains the four different commands (SELECT, INSERT, UPDATE and DELETE). It uses these commands to fetch the data from the DB and fill... Read More

Most of the today?s applications need to interact with database systems to persist, edit or view data. In .Net data access service is provided through ADO.Net ( ActiveX Data Object in Dot Net) components. ADO.Net is an object oriented framework that... Read More

A dataset is the local repository of the data used to store the tables and disconnected record set. When using disconnected architecture, all the updates are made locally to dataset and then the updates are performed to the database as a batch. Read More

ADO.NET has two primary parts in its architecture out of which one is data provider. It has its own set of objects and it consists of its own classes. Some of them are connection, parameter, data reader, command and data adapter. This provides access... Read More

This base class is added to ADO.NET 2.0. This class facilitates the process of obtaining a list of data sources. SQL server returns instances that are available on the network. Programmers do have choice of tools in their hands with this feature. Read More

Problem can arise from these following instances they are: - 1) Mismatch of schema between the client and database. 2) Network library problems or non existence of data. 3) Wrong SQL generated. 4) Wrong programming logic. Read More

If you are planning to create specialized sub classes of the data set then it is better to use visual studio as it has features supporting database schema. Access can be obtained to each field through strongly types properties. Intellisense is much... Read More

A database connection represents a communication channel between you application and database management system (DBMS). The application uses this connection to pass the commands and queries to the database and obtain the results of the operations... Read More

A database command specifies which particular action you want to perform to the database. The commands are in the form of SQL (Structured Query Language). There are four basic SQL statements that can be passed to the database. Read More

The data reader is a component that reads the data from the database management system and provides it to the application. The data reader works in the connected manner; it reads a record from the DB, pass it to the application, then reads another... Read More

The Dot Net Framework 1.1 is shipped with four different data providers: * Dot Net Framework data provider for Microsoft SQL Server DBMS * Dot Net Framework data provider for Oracle DBMS (available only in Framework 1.1) * Dot Net Framework... Read More

The specialized data providers (e.g., SQL Server and Oracle) are built specially for a particular kind of DBMS and works much more efficiently than the general data providers (e.g., OLEDB and ODBC). In practice, the specialized data providers are... Read More

The dot net framework data provider for Oracle is the optimized data provider for Oracle DBMS. It is recommended to use Oracle data provider to access the Oracle DB than general provider like OLEDB. It supports the Oracle Client version 8.1.7... Read More

First of all, you create a command object (SqlCommand, OracleCommand, OleDbCommand, OdbcCommand) using the connection object (SqlConnection, OracleConnection, OleDbConnection, OdbcConnection) and set its CommandText property to the SQL query to... Read More

We update the dataset and table by calling the Update method of the data adapter. This saves the changes in the local repository of data: dataset. To save the changed rows and tables to the physical database, we call the AcceptChanges() method of the... Read More

Writing the SQL statements inside our code is usually not a good idea. In this way you expose your database schema (design) in the code which may be changed. Hence most of the time programmers use stored procedures instead of plain SQL statements... Read More

Some of the basic issues related to the deployment of the data access applications are: * Can we suppose the required database exists at the target location? * If the database does exist then how can we get the connection string of it? Should we... Read More

OleDBDotNet Provider can be used to connect to any DataSource but OleDb SQL SERVER can be used to connect only to a SQL Server DataSource. Read More

By using template column, as <asp:TemplateColumn> <asp:ItemTemplate> <asp:CheckBox></asp:CheckBox> <asp:DropDownList></asp:DropDownList> </asp:ItemTemplate> </asp:TemplateColumn> Read More

Control which drives from BaseDataBoundControl Class Read More

Question : Hi i have a doubt.Interviewer asked me: How did you design your data access layer? What should i tell for that question suppose if i use SQL server or Oracle?         Answers: The Data Access Layer... Read More

Type sql> execute Procedure_name(arg1,arg2,...,arg n); Read More

A remote data object is also called as RDO in short. This represents data access application programming interface used in operating systems of windows. This was primarily designed for visual basic applications. This feature allows data base... Read More

DAO is used for database access on windows platform. It creates a work space object in which applications or operations are performed. There are two types of database engines they are Jet database engine and ODBC direct database engine. Read More

Usually the connection string options are provided in the documentation, you can also find the connection strings on the internet. A good website for the connections strings is http://www.connectionstrings.com Read More

We can do this by using DataAdapter's fill Method.Syntax for This is DataSet ds=new DataSet(); SqlDataAdapter dap=new SqlDataAdapter(<query1>,<connection>); dap.Fill(ds,"<TableName>"); SqlDataAdapter dap1=new... Read More

Using Rowstate property of the DataRow. Read More