-
What is the difference between data reader and data adapter ?
Read Best Answer
Editorial / Best Answer
Answered by: Madhukar Singh
- Aug 11th, 2006
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 best fit to show the Data (where no need to work on data)
DataAdapter is not only connect with the Databse(through Command object) it provide four types of command (InsertCommand, UpdateCommand, DeleteCommand, SelectCommand), It supports to the disconnected Architecture of .NET show we can populate the records to the DataSet. where as Dataadapter is best fit to work on data.
nikhiljain27
- Jul 13th, 2013
Datareader- works in fast forward read only mode to fetch data from the database. It works in connected environment.
DataAdapter- Works as a bridge between the database and Ado.net and Fills the dataset. It works as a bridge to work in a disconnected environment.Deepak
- Feb 15th, 2013
1. A DataReader works in a connected environment, whereas DataSet works in a disconnected environment.
2. A DataSet represents an in-memory cache of data consisting of any number of inter related DataTable objects. A DataTable object represents a tabular block of in-memory data.
-
What is Partial class
Read Best Answer
Editorial / Best Answer
bb.geetha- Member Since May-2008 | Jun 12th, 2008
A Partial class is a class that can be split into two or more classes. This means that a class can be physically separated into other parts of the class within the same namespace. All the parts must use the partial keyword. All the other classes should also have the same access modifier. At the compile time, all the partial classes will be treated as a single class. Let us list some advantages of having partial classes.
nikhiljain27
- Jul 13th, 2013
Two or more different class having the same name and datatype but physically different from each other. At compile time all the partial class are complied in to one single entity(class) and all the m...
lata negi
- Nov 4th, 2011
Partial class is a new feature added to .NET Framework 2.0. .NET 1.0 or 1.1, does not support for partial classes. It is possible to split the definition of a class or a struct, or an interface over t...
-
Data Table in ADO.NET
What is Data table in .net and how it is different from table in database (sqlserver)
nikhiljain27
- Jul 13th, 2013
Datatable is one table collection of Rows and columns in ADO.Net. It is a member of the System.Data namespace in the .NET Framework. DataSet is also a combination of multiple DataTable. It works in Disconnected environment. You can Add/ update/ delete records in the Datatable at runtime.
Trapti
- Sep 14th, 2011
The DataTable class is a member of the System.Data namespace within the .NET Framework class library. You can create and use a DataTable independently or as a member of a DataSet, and DataTable object...
-
Difference between ado.net data set and ADO Record set
Read Best Answer
Editorial / Best Answer
ramakrishnag1982- Member Since Nov-2006 | Aug 12th, 2007
1) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.
2) A DataSet is designed to work without any continuing connection to the original data source; Recordset maintains the contentious connection with the original data source.
3) There's no concept of cursor types in a DataSet, They are bulk loaded, while Recordset work with cursors and they are loaded on demand.
4) DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.Kishore
- Jan 24th, 2013
Please need some more related information about the each topic..It is not sufficient to answer in Interviews.
sathin
- Oct 29th, 2009
To get the data from a database and put it on a data control In ADO they used recordset In ADO.Net they used dataset Record set is a connection oriented architecture whereas dataset supports a c...
-
Difference between SqlCommand and SqlCommandBuilder
Read Best Answer
Editorial / Best Answer
sahu- Member Since Dec-2005 | Mar 29th, 2007
Hi All,
Ans:
a) SQLCommand is used to execute all kind of SQL queries like DML(Insert, update,Delete) & DDL like(Create table, drop table etc)
b)SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.
Lijo
- Nov 10th, 2011
SqlCommand: SqlCommand is used to execute Query involving Select, Update, Delete operation and to Execute SQL Stored procedures SqlCommandBuilder: SqlCommandBuilder provides the feature of refl...
abhi_la2006
- Jul 13th, 2011
Sql command use to only execute dml like update delete insert but sql command builder use the dml as well as the ddl like create database alter etc.
-
How do you connect to SQL Server Database without using sqlclient
Read Best Answer
Editorial / Best Answer
knreddy221- Nov 11th, 2006
Using System.Oledb;OledbConnection con= new OledbConnection ("Provider=SQLOLEDB.1;User Id=sa;Database=Northwind");OledbCommand cmd= new OledbCommand ("select * from table1",con);oledbdatareader dr= new oledbdatareader ();dr= cmd.ExecuteReader();datagrid1.datasource=dr;datagrid1.databind();
lata negi
- Nov 4th, 2011
We have 4 Data Providers to connect to our database: SqlClient = Used only for Sql Server database. OracleClient = Used only for Oracle database. Oledb = Used for any kind of databases either new or o...
Kamal Kant Verma
- Dec 18th, 2006
You can connect sql using oledbname space .
-
Can we connect two datareader to same data source using single connection at same time?
No, we cann't since once connection to database is opened must be closed before you reopen again .
Read Best Answer
Editorial / Best Answer
Answered by: Sathiyavathi
- Mar 24th, 2006
We can do it in ADO.Net 2.0 as
In your connection string there is an additional attribute named as MARS
and set it as true. MARS stands for Multiple Active Result Sets.
Ex :
string connectionString = "Data Source=MSSQL1;" +
"Initial Catalog=AdventureWorks;Integrated Security=SSPI" +
"MultipleActiveResultSets=True";rajankvns
- Sep 18th, 2011
Yes, 100% you can connect. help of-- Multiple Active Result Sets (MARS). more details with Example visit below Microsoft official website. -- http://msdn.microsoft.com/en-us/library/yf1a7f4f%28v=vs....
Ravi
- Sep 16th, 2011
Yes, you can connect two datareader to the same datasource, but one main thing is close the first datareader before using second one then only it's possible. The point is, we can have any number of d...
-
What is the use of HTTP Handlers in IIS?
Read Best Answer
Editorial / Best Answer
machud- Member Since Apr-2011 | Apr 10th, 2011
HTTP Handlers can be used to process custom requests that may not be in the standard supported format like .htm, .aspx, .asmx etc. One example will be RSS feed processing . One can write .rss? handler which can be configured in the IIS to accept and?delegate the processing to the custom handler written to produce customized output. There are 3 basic steps that need to be performed to make a HTTP handler work properly .
a. Create Handler calss which implements IHttpHandler interface or IHttpAsyncHandler for Asynchrounous handler. IsReusable property and the ProcessRequest method is must be implememented in the Handler class
b. Register the handler class in the web.config file of the application or machine.config
c. Specify the mapping in IIS (Website->Properties->configuration->mappings) add new extension with executable as "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_isapi.dll" ( assumes default installation)machud
- Apr 10th, 2011
HTTP Handlers can be used to process custom requests that may not be in the standard supported format like .htm, .aspx, .asmx etc. One example will be RSS feed processing . One can write .rss? handle...
-
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
Read Best Answer
Editorial / Best Answer
deepti705- Member Since Jan-2010 | Jan 2nd, 2010
Fill() method is use to fill the data through DataSource in DataSet
-
How is session dumped in ASP .Net?
Read Best Answer
-
How to connect Oracle database and MS Access to .Net framework?
Read Best Answer
Editorial / Best Answer
seemu123- Member Since May-2008 | Nov 11th, 2008
If you have used OleDB you can use an OleDB connectionstring, if you have
used SQLClient, you have to change it to the OracleClient (standard in
2003).seemu123
- Nov 11th, 2008
If you have used OleDB you can use an OleDB connectionstring, if you have used SQLClient, you have to change it to the OracleClient (standard in 2003).
-
Database Method
If we are not returning any records from the database, which method is to be used?
Read Best Answer
Editorial / Best Answer
Pendurti- Member Since Sep-2008 | Sep 11th, 2008
There is a method called Execute Non Query. This method executes the Update, Delete etc.
This does not return any rows but will give the number of rows affected.rakesh_mwisp
- Nov 5th, 2009
ExecuteNonQuery - this method returns no data at all. It is used mainly with Inserts and Updates of tables.
-
Database Access
Can we do database operations without using any of the ADO.net objects?This was an interview question
Read Best Answer
Editorial / Best Answer
amitdotchauhan- Member Since Jun-2010 | Jun 15th, 2010
Yes.
1. SQLCMD is the utility which supports command line interface to perform SQL operations. Output data in xml file & do opertions!
Refer http://msdn.microsoft.com/en-us/library/ms162773.aspx2. Alternate way to fetch data is enabling SQL server option which allows to provides data on web in XML format (IDK where it is but yes it was there in SQL 2k). Its data on http so you can read & process it just like a web service but cant perform operations.
I am sure there are other ways too! like
1. Create own database format other then SQL
2. Set up API in other application to fetch/process data in other application & set up custom components to store/process them.
Enjoy!
abhisuch
- Sep 29th, 2010
Accessing data from a database is called as database access. We can access data from database using several techniques such as DAO RDO ADO.NET etc.
amitdotchauhan
- Jun 15th, 2010
Yes.1. SQLCMD is the utility which supports command line interface to perform SQL operations. Output data in xml file & do opertions!Refer http://msdn.microsoft.com/en-us/library/ms162773.aspx2. A...
-
How can we retrieve the value which was selected from a combo box in a datagrid view.
The grid view consists of 3 columns which are combo Boxes. I want the string in the 1st column.
Read Best Answer
Editorial / Best Answer
veluworld- Member Since Jul-2007 | Aug 28th, 2008
((DropDownList)GV_chart.Rows[e.RowIndex].FindControl("Dcity1"));
Here GV_Chart is the id of Grid View And DCity is the Name of the dropdown listveluworld
- Aug 28th, 2008
((DropDownList)GV_chart.Rows[e.RowIndex].FindControl("Dcity1"));Here GV_Chart is the id of Grid View And DCity is the Name of the dropdown list
amitrms
- Jul 14th, 2008
Use this for fetching the values from combo boxfor (int i = 0; i < dataGridView1.Rows.Count; i++) &nbs...
-
What is meant my datarow versioning in ADO.Net. Where it is used?
Read Best Answer
Editorial / Best Answer
Lavanyaaru- Member Since Jan-2008 | Jan 30th, 2008
There are 3 versions for each DataRow object.
1.Original
2.Current
3.Proposed
The HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version exists, column values for it can be retrieved using one of the three overloads of the DataRow indexer
The Original version contains the values that were loaded into the row.
The Current version contains the latest version of the data, including the changes made since the data was originally loaded. The Original version isn't available for newly created rows.
A Proposed row version is made available while the row is in edit mode and contains the changes that have been made to the row while it was in edit mode
If CancelEdit( ) , RejectChanges() methods are called, the values in the Proposed version are simply discardedLavanyaaru
- Jan 30th, 2008
There are 3 versions for each DataRow object.1.Original2.Current3.ProposedThe HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version e...
-
How many App Domains an ASP.NET Worker Process creates if suppose 10 different users are logged into the web site
Read Best Answer
Editorial / Best Answer
nishant2200- Member Since Jan-2007 | Jan 7th, 2007
One AppDomain is created in the aspnet_wp.exe worker process per website. Inside that appdomain, user's state is kept separate from each other, and from then on server memory side state management can be segregated on basis of Session, Profile etc.
nishant2200
- Jan 7th, 2007
One AppDomain is created in the aspnet_wp.exe worker process per website. Inside that appdomain, user's state is kept separate from each other, and from then on server memory side state management can be segregated on basis of Session, Profile etc.
-
What is the difference between .Net framework and .Net Compact Framework?
Read Best Answer
Editorial / Best Answer
bb.geetha- Member Since May-2008 | Jun 12th, 2008
The .NET Compact Framework is a subset of the .NET Framework designed for small-footprint devices. It includes most, but not all of the base class library available in the full framework.
samina naaz
- Jun 30th, 2010
The .NET Compact Framework is a subset of the .NET Framework designed for small-footprint devices.
ptharak
- Oct 20th, 2008
DataREader is ued for readonly and forward .Dataset is used to either read and WriteWhenever sequential is read needed then you can go for DtaREader , it gives better performance than DataSEt.Using DataSEt you can get entire relationship of the tables and schema.
-
What are the steps to connect to a database?
Read Best Answer
Editorial / Best Answer
nishant2200- Member Since Jan-2007 | Jan 7th, 2007
1. Create a connection. This requires a connection string, which can be given declaratively or put in a well defined place like the .config files. Advantage of keeping in .config files is that it enables use of Connection Pooling by .Net framework, else even one small change in connection string will cause CLR to think it's not the same connection and will instantiate new connection for other request.
2. Open the connection and keep it open until done, typically done as using (con) { //use }
3. If using connected data model, create a SqlCommand object, decorate it with desired command, command type (stored procedure for eg), add any parameters and their values to the command, and then consume the command by using ExcuteReader or ExecuteScalar. In case of ExecuteReader, we will get back a handle to a fast-forward, read only pointer to the recordset. We can also decorate Command object with multiple recordsets in 2.0 and execute one by one (MARS - Multiple Active Record Sets)
4. If using disconnected data model, create a DataAdapter object, decorate it with desired SELECT, INSERT, UPDATE, DELETE commands, add parameters as necessary and then fill up a DataSet or DataTable using the DataAdapter. Subsequent SQL can be executed using insert, update, delete commands on the dataset.
ushalakshmi
- Apr 17th, 2008
TO Connect to a DatabaseFirst we need to have a namespace like System.Data.Sqlclientthen connect to database as follows1.Create connection using SqlConnection Sqlconnection con=new sqlconnection(...
johnjustin
- Apr 8th, 2008
1. Implements the base class for data access2. Create a connection3. Open that connection4. Create a data reader and execute the data reader with proper sql statements You can get the values of the record using the methods GetString, GetInt32 ....etc.
-
Explain the differences between ADO and ADO.NET, ASP and ASP.NET , VB and VB.NET
Read Best Answer
Editorial / Best Answer
ramakrishnag1982- Member Since Nov-2006 | Dec 12th, 2007
Asp:
* ASP is Interpreted language based on scripting languages like Jscript or VBScript.
* ASP has Mixed HTML and coding logic.
* Limited development and debugging tools available.
* Limited OOPS support.
* Limited session and application state management.
* Poor Error handling system.
* No in-built support for XML.
* No fully distributed data source support.
Asp.Net:
* ASP.Net is supported by compiler and has compiled language support.
* Separate code and design logic possible.
* Variety of compilers and tools available including the Visual studio.Net.
* Completely Object Oriented.
* Complete session and application state management.
* ?Full proof error handling possible.
* Full XML Support for easy data exchange.
* Fully distributed data source support.ramakrishnag1982
- Dec 12th, 2007
Asp:* ASP is Interpreted language based on scripting languages like Jscript or VBScript. * ASP has Mixed HTML and coding logic. * Limited development and debugging tools available. * Limited OOPS supp...
Guest
- Jan 4th, 2007
ADO1. This object model could be used even for non RDBMS products. We can read data from xml, excel, csv files also.2. ADO objects are dependent on OLEDB providers and OLEDB provider...
-
What are the advantages and disadvantages of using datalist ?
Read Best Answer
Editorial / Best Answer
spandanapotla- Member Since Mar-2008 | Apr 4th, 2008
Adv: the DataList's display is defined via templates,DataList allows for much more customization of the rendered HTML markup , by which it is more user-friendly displays of data.
DisAdv:
adding such functionality with the DataList takes more development time than with the DataGrid, as- The Edit/Update/Cancel buttons that can be created in a DataGrid via the EditCommandColumn column type, must be manually added to the DataList, and
- The DataGrid BoundColumn column types automatically use a TextBox Web control for the editing interface, whereas with the DataList you must explicitly specify the editing interface for the item being edited via the EditItemTemplate.
spandanapotla
- Apr 4th, 2008
Adv: the DataList's display is defined via templates,DataList allows for much more customization of the rendered HTML markup , by which it is more user-friendly displays of data.DisAdv: adding suc...
gouri
- Aug 29th, 2006
Hi,Datalist is updateable and datareader is not updateable
ADO.NET Interview Questions
Read Best Answer
Ans