ASP .Net
Asp.Net Faqs, Asp.Net interview questions,
What is normalization? What are different types of normalization?
Dec 9th
It is set of rules that have been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization.
Benefits of normalizing your database will include:
- Avoiding repetitive entries
- Reducing required storage space
- Preventing the need to restructure existing tables to accommodate new data.
- Increased speed and flexibility of queries, sorts, and summaries.
Note :- During interview people are expect to answer maximum of three normal forms and that’s what is expected practically. Actually you can normalize database to fifth normal form. But believe this book will answer three normal forms that will More >
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
Dec 9th
Following are some major differences between a stored procedure and user defined functions:-
- UDF can be executed using the “SELECT” clause while SP’s can not be.
- UDF can not be used in XML FOR clause but SP’s can be used.
- UDF does not return output parameters while SP’s return output parameters.
- If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
- UDF can not make permanent changes to server environments while SP’s can change some of the server environment.
What is the main difference between MSML and .NET Framework XML classes?
Dec 9th
MSXML supports XMLDOM and SAX parsers while .NET framework XML classes support XML DOM and XML readers and writers.
MSXML supports asynchronous loading and validation while parsing. For instance you can send synchronous and asynchronous calls to a remote URL. But as such there is not direct support of synchronous and asynchronous calls in .NET framework XML. But same can be achieved by using “System.Net” namespaces.
What is the main difference between Gridlayout and FlowLayout ?
Dec 6th
GridLayout provides absolute positioning for controls placed on the page. Developers that have their roots in rich-client development environments like Visual Basic will find it easier to develop their pages using absolute positioning, because they can place items exactly where they want them. On the other hand, FlowLayout positions items down the page like traditional HTML. Experienced Web developers favor this approach because it results in pages that are compatible with a wider range of browsers.
If you look in to the HTML code created by absolute positioning you can notice lot of DIV tags. While in Flow layout you can More >
How do we configure “WebGarden”?
Dec 6th
“Web garden” can be configured by using process model settings in “machine.config” or “Web.config” file. The configuration section is named <processModel> and is shown in the following example. The process model is enabled by default (enable=”true”). Below is the snippet from config file.
<processModel
enable=”true”
timeout=”infinite”
idleTimeout=”infinite”
shutdownTimeout=”0:00:05″ requestLimit=”infinite” requestQueueLimit=”5000″ memoryLimit=”80″
webGarden=”false” cpuMask=”12″ userName=”” password=””
logLevel=”errors”
clientConnectedCheck=”0:00:05″
/>
From the above processmodel section for web garden we are concerned with only two attributes “webgarden” and “cpuMask”.
webGarden :- Controls CPU affinity. True indicates that processes should be affinitized to the corresponding CPU. The default is False.
cpuMask:- Specifies which processors on a multiprocessor server are eligible to run ASP.NET processes. The cpuMask value More >
What is the difference between “Web farms” and “Web garden”?
Dec 6th
“Web farms” are used to have some redundancy to minimize failures. It consists of two or more web server of the same configuration and they stream the same kind of contents. When any request comes there is switching / routing logic which decides which web server from the farm handles the request. For instance we have two servers “Server1” and “Server2” which have the same configuration and content. So there is a special switch which stands in between these two servers and the users and routes the request accordingly.
What are the steps to create a windows service in VB.NET ?
Dec 6th
Windows Services are long-running executable applications that run in its own Windows session, which then has the ability to start automatically when the computer boots and also can be manually paused, stopped or even restarted.
Following are the steps to create a service :-
? Create a project of type “Windows Service”.
How to use a checkbox in a datagrid?
Dec 6th
Following are the steps to be done :-
? In ASPX page you have to add Itemtemplate tag in datagrid. <ItemTemplate>
<asp:CheckBox id=”CheckBox1″ runat=”server” AutoPostBack=”True” OnCheckedChanged=”Check_Clicked”></asp:CheckBox>
</ItemTemplate>
? If you look at the Itemtemplate we have “OnCheckChanged” event. This “OnCheckChanged” event has “Check_Clicked” subroutine is actually in behind code. Note this method which is in behind code should either be “protected” or “public”
? Following below is the subroutine which defines the method
Protected Sub Check_Clicked(ByVal sender As Object, ByVal e As EventArgs) ‘ do something
End Sub
The above steps should be defined in short to the interviewer which will give a quick feeling of your practical More >
If cookies are not enabled at browser end does form Authentication work?
Dec 6th
No, it does not work.
