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.
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...
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.
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...
Tier 3 Microsoft Support Engineer Interview
I just got out of a panel interview at Microsoft. There were three interviewers and me the interviewee. Two of the individuals asked the bulk of the questions and the other took notes. I noticed a distinctive style to each interviewers roles for the interview. One person asked fairly easy straight-forward technique and process questions.The other would ask troubleshooting scenario questions. For example,...
Microsoft Interview Questions
Aug 24th, 2017
Apr 21st, 2019
Mar 25th, 2015
Sep 8th, 2022
Sep 8th, 2022
Jun 16th, 2014
Oct 28th, 2017
Mar 26th, 2018
Aug 26th, 2016
Jun 1st, 2011
Dec 1st, 2022
Oct 12th, 2018