-
Normalization in sql
Explain the normalization and why it is done. explain the case when we avoid the normalization in database.
-
What exactly happens when ASPX page is requested from Browser?
Following are the steps which occur when we request a ASPX page :- vThe browser sends the request to the webserver. Let us assume that the webserver at the other end is IIS. vOnce IIS receives the request he looks on which engine can serve this request.When I mean engine means the DLL who can parse this page or compile and send a response back to browser. Which request to map to is decided by file...
-
Object to generate XML
What are the various methods provided by the dataset object to generate XML? Note:- XML is one of the most important leap between classic ADO and ADO.NET.So this question is normally asked more generally how can we convert any data to XMLformat. Best answer is convert in to dataset and use the below methods. vReadXMLRead’s a XML document in to Dataset. vGetXMLThis is a function which returns the...
-
How can we fine tune the command object when we are expecting a single row or a single value ?
Again CommandBehaviour enumeration provides two values SingleResult and SingleRow.If you are expecting a single value then pass “CommandBehaviour.SingleResult” and the query is optimized accordingly, if you are expecting single row then pass“CommandBehaviour.SingleRow” and query is optimized according to single row.
-
Want to force the data reader to return only schema of the datastore rather than data ?
pobjDataReader = pobjCommand.ExecuteReader(CommandBehavior.SchemaOnly)
-
How can we force the connection object to close after my datareader is closed ?
Command method Executereader takes a parameter called as CommandBehavior wherein we can specify saying close connection automatically after the Datareader is close. pobjDataReader = pobjCommand.ExecuteReader(CommandBehavior.CloseConnection)
-
What is the use of command objects and what are the methods provided by the command object ?
They are used to connect connection object to Datareader or dataset. Following are the methods provided by command object ExecuteNonQuery :- Executes the command defined in the Command Text property against the connection defined in the Connection property for a query that does not return any row (an UPDATE, DELETE or INSERT). Returns an Integer indicating the number of rows affected by the query.ExecuteReader...