ADO.NET - ASP.NET (MCQ) questions and answers

ANSWER: Use DataViev object with each sort

Explanation:
DataView.Sortproperty allow you to sort data. Using a DataView, you can show the data in a table with different sort orders.

Example.
In this example our table name is StudentMaster.
public partial class Default5 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("provide connection string");
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
string query = "select * from StudentMaster";
da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
DataView dv = new DataView();
dv = ds.Tables[0].DefaultView;
dv.Sort = "studName";
DataTabledt = dv.Table;
GridView1.DataSource = dt;
GridView1.DataBind();
}
}

ANSWER: All of the above

Explanation:
A DataTable is an in-memory representation of a single database table that contains DataRow and DataColoumn objects.
Serialization is the process of converting an object into a stream of bytes so you can store or transmit the object. Only those objects can be serialized those have SerializableAttribute.
There are two types of serialization binary and XML serialization.

ANSWER: It is the type of column or data in SQL Server that the command expects.

Explanation:
No explanation is available for this question!

ANSWER: Input, Output, InputOutput

Explanation:
There are three types of parameters that you can use in a .NET Framework and those are Input, Output, InputOutput .
Parameters are like variables that you can use to pass and return values between your application and a database. The types of parameters are defined by SqlDbTypeenumeration. It contains a list of the types available in SQL Server. These parameter values are pass to SQL statements and stored procedures. SQL Server uses the @ symbol as a prefix to denote parameters.
Parameters are Input parameters by default. You can change its direction by using ParameterDirection property.

Example:
SqlParameterparaObj = new SqlParameter();
paraObj.ParameterName = "@TotalCost";
paraObj.SqlDbType = SqlDbType.Money;

ANSWER: 2, 3

Explanation:
Input parameter is used to send data from the application to the database. You can also use input parameter in where clause. By default the parameter direction is input type. Parameters are created by using Parameter class.

ANSWER: Set the Command.CommandTextproperty to multiple SQL statements delimited by a semicolon.

Explanation:
You can execute more than one SQL statements delimited by a semicolon.
For this you have to set the CommandText property of a Command object to multipleSQL statements separated by semicolons (;). After calling the ExecuteReader method, theDataReader will hold the number of result sets equal to the number of SQL statements executed.

Example:
String sqlQuery = ”select * from table1; select * from table2”;
SqlConnection con = new SqlConnection(connectionString);
SqlCommandcmd = new SqlCommand ();
Con.Open();
SqlDataReaderdr = cmd.ExecuteReader();

While(dr.read())
{
// Process the table1
}
Dr.NextResult();

While(dr.read())
{
// Process the table2

}

ANSWER: 2, 4

Explanation:
No explanation is available for this question!

ANSWER: 2, 4

Explanation:
You can execute stored procedure by using Command object.
SqlCommandcmd = new SqlCommand();
cmd.Connection = ConnectionString;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "stored procedure name ";

ANSWER: 2, 3

Explanation:
You can provide yes, no, true, SSPI and false value to Integrated Security property of connection string according to the requirement. If Integrated Security= truethen current Windows account credentials are used for authentication. SSPI is equivalent to specifying True.

ANSWER: 2, 4

Explanation:
SqlException.Message and SqlError.Messageproperty contains the actual error message returned by SQL Server.