How to open more than one datareader at a time
Use different data reader variable
Use different data reader and connection variable
Cannot be done
SHOW ANSWERWhat is the advantage of disconnected mode of ADO.Net in ASP.Net?
Automatically dump data at client PC
Not necessary to connect with server
User data can update and retrieve in dataset and when connection connected, update values with server
All of the above
SHOW ANSWERWhich namespace would you use if you need to create an ASP.NET application with Microsoft SQL Server 2000 as the database.
System.Data.SQLServer
System.Data.SQLClient
1. System.Data.OleDb
System.Data.Microsoft
SHOW ANSWERHow can you load an XML file directly into a DataSet
By setting the XML property of the DataSet class
By using the GetXML() method of the DataSet classSet
By using the ReadXml() method of the DataSet class
1You cannot load an XML file directly into a DataSet
SHOW ANSWERBy using which of the following web server control can be retrieved from a relational database?
ObjectDatasource
Sqldatasourse
Accessdatasource
Xmldatasource
SHOW ANSWERWhich SqlCommand execution returns the value of the first column of the first row from a table?
ExecuteNonQuery
ExecuteReader
ExecuteXmlReader
ExecuteScalar
SHOW ANSWERWhich SqlCommand execution returns the number of effected records in the table?
ExecuteNonQuery
ExecuteReader
ExecuteXmlReader
ExecuteScalar
SHOW ANSWERThe best way for handling exception when dealing with a database connection?
Implement a try / catch block that catches System.Exceptions.
Implementing custom error page.
Implement a try / catch block that catches individual exception types, such as SQLException.
Display an error message.
SHOW ANSWERWhich ADO.NET class provide Disconnected Environment?
DataReader
DataSet
Command
None of the above.
SHOW ANSWERWhich ADO.NET class provide Connected Environment?
DataReader,command
DataSet,dataadapter
Command,dataset
None of the above
SHOW ANSWERWhat are the Command Object Methods?
ExecuteNonQuery
ExecuteReader
ExecuteScalar
All of the above.
SHOW ANSWERA____block enclose the code that could throw an exception.
Try
Catch
Exception
Error
a and b
SHOW ANSWERWhat is the sequential procedure in working with databases?
Open the database, interact with the db, close the database |
Open a connection, interact with the db, close the connection |