-
What is ADO.NET
Read Best Answer
Editorial / Best Answer
Ranjit- Member Since Oct-2005 | Nov 28th, 2005
ADO.NET is the primary relational data access model for Microsoft .NET-based applications. It may be used to access data sources for which there is a specific .NET Provider, or, via a .NET Bridge Provider, for which there is a specific OLE DB Provider, ODBC Driver, or JDBC Driver. ADO.NET is sometimes considered an evolution of ADO technology, but it is important to note that some major changes were made between the two.
Pendurti
- Sep 11th, 2008
ADO.NET is something that allows us to interact with relational databases and other data sources. It is a technology that ASP.NET applications use to communicate with a database, whether we need to add a new customer record, make a purchase, or display a product catalog.
shravanmadhastu
- May 24th, 2008
ADO.NET stands Active X Data Objects.Net.It is used in microsoft.net to communicate with datastore.ADO.NET is inherited from System.Data.dll name spaceADO.NET has two componentsthey are 1. .Net Data p...
-
-
How to copy the contents from one table to another table and how to delete the source table in ado.net?
Read Best Answer
Editorial / Best Answer
samiksc- Member Since Oct-2005 | Jul 12th, 2007
The question can mean 2 tasks -
1. Copy one 'datatable' to another and delete the source 'datatable' OR
2. Copy one database table (say a table in sql server database) to another database table, and delete the source table which is in the SQL server database. This operation is to be performed using ADO.Net
Answers:
1. DataTable newOne = originalOne.Copy(); originalOne.Dispose(); -- Note that originalOne.Clear() will simply delete all rows from the table, but the table object with its structure will remain there.
2. Run DDL commands using 'ExecuteNonQuery' method of DataCommand object.
e.g. string cmdText1 = "create table newOne as select * from originalOne" (copy table to another)
string cmdText2 = "drop table originalOne";
DataCommand dataCmd = new SqlDataCommand(cmdText1, conn);
conn.Open();
dataCmd.ExecuteNonQuery();
dataCmd.CommandText = cmdText2;
dataCmd.ExecuteNonQuery();
conn.Close();sathin
- Oct 29th, 2009
This is definitely possible. I tried making it simple by talking two gridviews in the design part and writing the below code when you try creating a datatable do avoid the new keyword Imports S...
Dharmesh279
- Oct 18th, 2008
We can copy the contents from 1 table to another table by using Bulk Copy and delete a table by simply write the query of drop a table when we create sqlcommand object.
-
Retrieve two tables of data at a time by using data reader
One interview I faced a Q:how can i retrieve two tables of data at a time by using data reader?Data reader read and forward only, how is
it possible to get 2 tables of data at a timepeeyush Mishra
- Dec 20th, 2009
SqlCommand myCmd=new SqlCommand("Select Column1,Column2 From Table1;" + ...
vksingh24
- Nov 16th, 2009
This is possible to retrieve data from two tables using datareader.SqlDataReader rd=Command.ExecuteReader("SELECT * FROM Employee | Select * From Order");This will fetch the record from two tables Employee and Order
-
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.
-
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...
-
what is "View"?
what is "Stored procedure"?
what is "delegate"?
">What is "Connection string"?what is "View"?what is "Stored procedure"?what is "delegate"?
rohit chittora
- Aug 20th, 2011
view : it is a mirror image or shadow of table with some modification so that only the essential information is display hidden some information from end user. Store procedure : this are group of exec...
Praveen Chandra
- May 19th, 2011
1.Connection sting contains servername, database and credentials of db, without connection string we cannot working with a backend application2.View is similar to a table, user can modify the data in ...
-
How do you update a Dataset in ADO.Net and How do you update database through Dataset
brajesh gautam
- Feb 6th, 2012
In ADO.Net if you use the disconnect mode then local copy are already update but if we want to update a database type this program in visual studio sqlconncection = new sqlconection (" connection str...
lata negi
- Nov 4th, 2011
Code- SqlConnection conn = new SqlConnection("Server=__; DataBase=__; UID: __; Password: __");
- DataAdapter da;
- DataSet ds = new DataSet();
- da = new SqlDataAdapter("select * from employee", conn);
- ds = da.fill(ds);
- GridView.DataSource=ds;
- GridView.DataBind();
-
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 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.
-
Why edit is not possible in repeater??
amitdotchauhan
- Jun 15th, 2010
Repeater itself a presentation control, not the data editing control.Repeater still can support a multiple records updates which i have done to support some client requirements.Basically its not the b...
Varung5
- Jun 15th, 2010
Repeater control does not have default selecting and editing support. This control is just to read and display the information. This control has better performance. But if you want to enable the editi...
-
What is the default view of Data Grid?
Read Best Answer
Editorial / Best Answer
spandanapotla- Member Since Mar-2008 | Apr 2nd, 2008
The DataGrid default view is tabular form and optionally supports selecting, sorting, paging, and editing the data
-
What is difference in Record set and Dataset
Recordset provides data one row at a time.Dataset is a data structure which represents the complete table data at same time.Recordset has the logic to update and manipulate dataDataset is just a data store and manipulation is done through DataAdapters in .NET.
veluworld
- Aug 28th, 2008
Recordset is the Read only & forward only mechanism. But Dataset is the Editable. Recordset is connection oriented and Dataset need connection once to dump the data from the data base. Dataset holds more than one table at a time?but recordset holds only one.
ramakrishnag1982
- 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 t...
-
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...
-
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 can we load multiple tables in to Dataset?
TheDentist
- Apr 23rd, 2013
I know the DataAdapter provides this functionality but I prefer to create a SQL Statement that performs the merge and creates a single DataSet. The servers are usually high powered machines so by let...
Varung5
- Jun 15th, 2010
You can pass multiple select statements in data adapter separated by “;”.SqlDataAdapter dataAdapter = new SqlDataAdapter(“select * from table1;select * from table2”, connection);DataSet ds = new DataSet();dataAdapter.Fill(ds);
-
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...
-
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...
-
How can we add a check box or a dropdown list to a column in a datagrid?
Post your answer
ali1dc
- Dec 17th, 2008
you can use the same thing for different control:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"> <Columns> &l...
lohanigeit
- Oct 3rd, 2007
Add the checkbox or drop down in ur itemtemplate column & access it through it's ID.
-
How many records can take clustured index in sql server
Read Best Answer
Editorial / Best Answer
vvijaychandra- Jun 22nd, 2006
a clustered index is a special type of index that reorders the way the records in the table are physically stored . therefore the table can have only one clustered index.
Pendurti
- Sep 15th, 2008
FYI..Clustered index is something that deals with the columns but not the records.These define the physical sorting of the rows in the database in the storage media.A database table can have utmost on...
ushalakshmi
- Apr 17th, 2008
A clustered index is a special type of index that reorders the way records in the table are physically stored. Clustered index is created by default when we create a primary key on a column.Everyone k...
ADO.NET Interview Questions
Read Best Answer
Ans