Interview 26/10/2010 bangalore company

1.what is IL ?
2.what is JIT ?
3.What is CLR ?
4.What is Profiler ?
5.What is polymerfisim in C# ?
6.What is difference between virtual and New ?
7.what is dispose ? why it is used ? when it is used ?
8.What is the coding standard of the code are you follow Microsoft coding  standard ?
9.How security maintained by the CLR ?
10.Define your profile(Resume) ?
11.What is Finalize ?
12.What is GC.SuppressFinalize ?
13.What is Idisposable interface ?
 


Q.What is IL ?
Ans- MSIL is a platform independent language meaning that it does not dependent on the type of platform,
all the code written in .Net will first be converted into intermediate language and then .net compiler compiles it and generate a machine language code.
Main advantages of intermediate language
Intermediate language is independent of any language and hence there is possibility to create applications with modules that were written in different programming language supported by .net,
This means that we can develop different modules in an application in different programming language and can compile the application.

Q What's the difference between override and new in C#? 
http://www.dotnetinterviewfaqs.com/difference-between-override-and-new-in-polymorphism.aspx
We can use new or override to rewrite a method in an child class.
But what is the difference between new and override?
*****************************************
DerivedType derivedInstance = new DerivedType();
BaseType baseVar = derivedInstance;
baseVar.CallMethod();
------------------------------------------------------------------------
If the DerivedType.CallMethod() is defined as "new", the above code will
code the BaseType version. If it is defined as "override", it wil call the
DerivedType version.

If you are using inheritance to get polymorphism, you probably want
override.
**************************************************
http://bytes.com/topic/c-sharp/answers/261357-what-difference-between-new-override

Fundaments in WCF

Please follow these URL For Fundamental thing in WCF
1.  http://www.dotnetspider.com/forum/194633-Fundaments-WCF.aspx
 2. http://www.aspskills.com/windows-communication-foundation-wcf/397/
Difference between WCF and Web service 
1.   http://www.aspskills.com/difference-between-wcf-and-web-service/388/
wcf interview questions 
1.   http://www.aspskills.com/wcf-interview-questions/571/

How to create SUB REPORT

Create a Main Report
inside the main report drag and drop the subreport and link with the partcular report throw the General Tab.
in visibility tab just choose the Visible option.
In Parameter tab just put the parameter name of report.
In output tab just choose "Auto"

In case of no records please display the message "No Records" in SSRS

=sum(Fields!ward1.Value)
in the report i was devloped on interesting thing suppose the dataset is not returned any records in this case as per the requirement we need to show "No open work is there" ort this type of message
Solutions:-Insert a Text Box then open the properties of the text box
Text box properties screen will displaying
click on the Visibility Tab
write code on the Expression =iif(rownumber("DataSet4") > 0,true,false)
it means if the dataset have records then dispaly the text box
similarly you need to disable to the table where we display the data which is returned from the Dataset4
same press click on the Visibility Tab
=iif(IsNothing("DataSet4"),"test",false)
it means it datase4 have no records then no need to show the table

Create Group in SSRS 2005

Click on the row and select Edit group or create group
Grouping and Sorting Properties Box will display.
Name-put the name of the group
Group on-put the filed name on that base you want to create group
check Include group header.
Click in the "Visibility" Tab
on that interface select Hidden option and checked Visibility can be toggled by another report item
Report item chose the text box

How change the color of row in SSRS Reports

=iif(RowNumber(Nothing) mod 2, "Beige", "WhiteSmoke")
by using this code in expression the color of the row changed 1st row "Beige" and 2nd row "WhiteSmoke"
=FormatCurrency(Fields!Total_DO_Value.Value,2)
The above expression is used for the Currency Format
=IIF(Fields!Contractual_StartDate.Value IS Nothing, "" ,FormatDateTime(Fields!Contractual_StartDate.Value,2))
The above expression is used if StartDate is nothing then display blank space i not then display the date.

 

Interesting Issue in SSRS(10/06/2010)Benefits Report

One interesting issue is coming when i was developing one report in SSRS package.
What is it ?
I was used three procedure,I've one main procedure inside main procedure two other procedure is used.
when I'm executing  main procedure two sub procedure throwing errors.if i am executing other two sub procedure separately it was not showing any errors.

after that the main procedure also working fine what is the cause i was not find out till now today i'm trying to find out  what is the cause. of this type of error.