Answered Questions

  • 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...

  • What is Partial class

    Star 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.

  • What is the difference between data reader and data adapter ?

    Star 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.