-
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 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 .
-
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.
-
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...
-
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
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...
-
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.
ADO.NET Interview Questions
Read Best Answer
Ans