Welcome To Latest Dot Net Interview Questions and Answer.

In this Blog you can find all to Dot Net Interview Question and Answer. you can find Scenario based ASP.Net, VB.Net, C# and SQL Server Interview Questions and answers. Dot Net Jobs, Dot Net Books. SQL Server Books, Dot Net Based Company. Dot Net and SQL Server Training Institute.

Visual Studio.Net advanced Interview Questions, SQL Server advanced Interview Questions, Latest Interview Questions,ASP.NET, SQL Server, VB.Net, C#.Net and ADO.NET Interview Questions.Scenario Based Interview Questions. Visual Studio.Net Books and SQL Server Books. Technical Interview Questions, HR Interview Questions

In this Blog You can Find ASP.NET Web Application Projects Idea , C# Windows Application Projects Idea. VB.Net Windows Application Projects Idea, SQL Server Data Base Concept.

Latest Dot Net Interview Questions Book

Dot Net Interview Questions Book 6th Edition  is written By Shiv Prasad Koirala.  He is working in MNC and has good Experience in Software Fields.




The Following Topics are covered in this Books. 

  Top 50 Technical and Non-technical Questions

 .Net Framework and .Net Interoperability

Threading & Remoting and Web Services

ASP.Net,  ASP.NET 2.0, .Net 3.5 and  ATLAS-AJAX

Caching Concepts,  OOPS and.Net Architecture

ADO.Net & SQL Server, XML, Reports

Localization and Globalization  & Project Management


Windows Communications and Foundations,Windows Presentation Framework and Windows Workflow Foundation

Sample Address Application Projects.

The book has more than 500 questions in Dot Net. The book Covers .Net 1.0, 1.1, 2.0,3.0, 3.5. 4.0

http://www.flipkart.com/net-interview-questions-cd-rom-6th/p/itmdyuqzdqx8cvqx?pid=9788183331470&affid=suresh0483
The Book is specially for Dot Net Developers who is looking for job. if you go through this book, you will get more confidence. Dot Net Interview Questions For Fresher and Experienced.

Dot Net Project Idea for Final Year Student

Here I am giving Some Project idea for Final Year Students.  Final Year Project Ideas for B.Tech & MCA.

You can choose which Technology you want to do  (VB.Net, C#.Net, ASP.Net,  SQL Server, Oracle, MySQL, and XML)

Final Year MCA/ M.Sc./ B.Tech/ B.E/ M.Tech Project Idea :


    School Management System

    College Manaegement System

    Online Tutoring System

    Human Resource Management System

    Mobile Ticket Reservation System

    Purchase Order System

    Online Recruitment systems

    Online Quiz System

    Real estate application softwares

    Leave management system

    Online Polling System

    Internet Banking System

    Online survey tool

    Recipe management system

    Meeting Scheduler System

    Online Test System



You can choose you want to do Web application or Window applications. if you want any Dot Net Projects idea, Post your Comments with email id. we will send you.


Dot Net Projects for Final Year MCA Students Bangalore, Dot Net Projects for Final Year B. Tech. Students Bangalore, Dot Net Projects for Final Year B.E. Students Bangalore, Dot Net  Project for Final Year Students Bangalore.

 

  Mca Final year, Dot Net Project Idea, Final Year Project Idea. New and Latest Dot Net Project Ideas, Computer Project Ideas,  Engineering Project, Science Fair Project Ideas, School Projects. Advanced Concept in Dot Net Projects

Advanced Interview Question in Dot Net

 Here  I am giving Advanced Dotnet Interview Questions. You should know about WPF, WCF, Design Patterns, N Tier Architecture,  Generics and Fundamentals of .Net FrameWork.


1. Explain about Generics?

2. In Assembly which work as GacBrowser ?

3. What are the consideration in deciding to use .NET Remoting or ASP.NET Web Services? 
 
4. Describe the Provider Model in ASP.NET 2.0?

5. What do you mean by three-tier architecture?

6. Does .NET CLR and SQL SERVER run in different process?

7. The IHttpHandler and IHttpHandlerFactory interfaces ?

8. When not to use Design Patterns

9 . When to use Design Patterns

10 . Benefits of Design Patterns

11. What are Design Patterns?     

12. What is difference between WCF and Web Services

13. What is Difference between WPF and Windows Forms.

14. What is WCF?

15. What is WPF?


if you are going for interview , Please prefer well. 3 + Years Experience Interview Questions.  
Advanced Interview Question in Dot Net, Interview questions, Asp.Net Interview Questions, ASP.Net, ASP.Net 2.0, ASP.Net 3.5, ASP.Net 4.0,3 + Years Experience Interview Questions
 

How to improve SQL Server Performance

I am giving some points to improve the SQL Server Performance.If you want to improve your application performance, you want to improve your  SQL Server Performance also.

1. Don' t use Select * from tablename. Use SELECT ColumnName FROM tablename instead of it.

Example : Use below Query

SELECT EmpName FROM EmpDetails.

2. Don't use Lower Case in SQL Server statements,

Example : Don't use : select ColumnName from tablename.
                Use Upper case : SELECT EmpName FROM EmpDetails.

3. Don't use "IN", "NOT IN" , "DISTINCT"  in your query. if not required .

4. Don't use "Cross Join" if not required

5. Don't  use Having Clause if not required .

6. Don't  use Cursor if not required

It is very important for increase the performance of the SQL Server.

If you want to improve your SQL Server, you need follow the above tips.

It will help you.

I will add some more point in SQL Server Performance. Thanks for spending your valuable time.
if you have any doubts or any suggestion, Post your comments.

State Management Questions

State Management Questions

1. What is ViewState?
ViewState allows the state of objects (serializable) to be stored in a hidden field on the page. ViewState is transported to the client and back to the server, and is not stored on the server or any other external source. ViewState is used the retain the state of server-side objects between postabacks.

2. What is the lifespan for items stored in ViewState?
Item stored in ViewState exist for the life of the current page. This includes postbacks (to the same page).


3. What does the "EnableViewState" property do? Why would I want it on or off?
It allows the page to save the users input on a form across postbacks. It saves the server-side values for a given control into ViewState, which is stored as a hidden value on the page before sending the page to the clients browser. When the page is posted back to the server the server control is recreated with the state stored in viewstate.


4. What are the different types of Session state management options available with ASP.NET?
ASP.NET provides In-Process and Out-of-Process state management. In-Process stores the session in memory on the web server. This requires the a "sticky-server" (or no load-balancing) so that the user is always reconnected to the same web server. Out-of-Process Session state management stores data in an external data source. The external data source may be either a SQL Server or a State Server service. Out-of-Process state management requires that all objects stored in session are serializable.

Web Service Questions

Web Service Questions

1. What is the transport protocol you use to call a Web service?
SOAP (Simple Object Access Protocol) is the preferred protocol.

2. True or False: A Web service can only be written in .NET?
False

3. What does WSDL stand for?
Web Services Description Language.

4. Where on the Internet would you look for Web services?
http://www.uddi.org

5. True or False: To test a Web service you must create a Windows application or Web application to consume this service?
False, the web service comes with a test page and it provides HTTP-GET method to test.

Web Control Class in ASP.Net 4.0

Few Basic Standard Control included in the WebControl Class :

Button Control
CheckBox Control
Label Control
Textbox Control
FileUpload Control
Image Control
ImageButton Control
RadioButton Control

I will explain this control (Web Control Class in ASP.Net 4.0) later

My Profile

I have 4 years Experience .Net and SQL Server. I am working as software engineer in private company Bangalore. I have faced many interviews. Here I am Sharing My Interview experience (Technical, HR and Written Test). This Blog is useful for .Net Developers and Freshers. My hobbies I like to play Foot ball, to read some books, to Learn new technologies. I have Experienced in Asp.Net 2.0, C#.Net, VB.Net, SQL Server and Xml.