<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5998782275654434983</id><updated>2026-04-11T11:33:40.067-07:00</updated><category term="Dot Net Inteview Questions"/><category term="Interview questions"/><category term="ASP.Net"/><category term="ASP.Net 2.0"/><category term="Asp.Net Interview Questions"/><category term="SQL Server Interview questions"/><category term=".NEt 4.0 Framework"/><category term="Basic .Net Framework Questions and answer"/><category term="C#"/><category term="Dot Net Projects"/><category term="Introduction ASP.Net 2.0"/><category term="Structure"/><category term=".Net Remoting Interview Question and answer"/><category term="3 + Years Experience Interview Questions"/><category term="ACID"/><category term="ADO.NET"/><category term="ADO.NET Interview Questions and answer"/><category term="ASP.NET Security"/><category term="ASP.Net 3.5"/><category term="ASP.Net 4.0"/><category term="Advanced C# questions"/><category term="Advanced Interview Question in Dot Net"/><category term="Aggregate Functions in SQL SERVER 2008"/><category term="Asp.Net Interview Questions and answer"/><category term="Atomicity"/><category term="CLR"/><category term="Class"/><category term="Common Language Runtime"/><category term="Connection Pooling in ADO.NET"/><category term="ConnectionString"/><category term="Consistency"/><category term="Delegates"/><category term="Destructor"/><category term="Difference Between Classes and Structs"/><category term="Differnce between ASP.Net Vs ASP"/><category term="Dot Net Interview Questions Book"/><category term="Dot Net Project Idea"/><category term="Durability"/><category term="Final Year Project Idea."/><category term="HTML"/><category term="Indexes in SQL Server"/><category term="Interview questions for .NET Framework"/><category term="Isolation"/><category term="Mca Final year"/><category term="Namespace"/><category term="Object Oriented Programming Concept"/><category term="Reference types"/><category term="SQL Server"/><category term="SQL Server 2008 Advantages"/><category term="SQL Server Basic Databases"/><category term="State Management Questions"/><category term="Strong Name"/><category term="Style Sheet"/><category term="The Garbage Collection"/><category term="The Garbage Collector in .Net"/><category term="Types of Indexes"/><category term="UDDI"/><category term="Value types"/><category term="WDSL"/><category term="WEB SERVICES AND REMOTING"/><category term="Web Control Class  in ASP.Net 4.0"/><category term="Web Service Questions"/><category term="What is a static class?"/><category term="XHTML"/><category term="XML"/><category term="XSLT"/><category term="Xml Documents"/><category term="improve SQL Server Performance"/><category term="static member of class"/><title type='text'>Latest Dot Net Interview Questions</title><subtitle type='html'>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</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>44</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-6506225869737153846</id><published>2011-08-19T08:10:00.000-07:00</published><updated>2014-06-23T00:44:55.636-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Asp.Net Interview Questions"/><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Interview Questions Book"/><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Inteview Questions"/><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Projects"/><title type='text'>Latest Dot Net Interview Questions Book</title><content type='html'>&lt;div&gt;
Dot Net Interview Questions Book 6th Edition&amp;nbsp; is written By Shiv Prasad Koirala.&amp;nbsp; He is working in MNC and has good Experience in Software Fields.&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;iframe frameborder=&quot;0&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;http://www.flipkart.com/affiliate/displayWidget?affrid=WRID-140350874996324365&quot; style=&quot;height: 240px; width: 120px;&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;b&gt;The Following Topics are covered in this Books.&amp;nbsp;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp; Top 50 Technical and Non-technical Questions &lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;.Net Framework and .Net Interoperability&lt;br /&gt;
&lt;br /&gt;
Threading &amp;amp; Remoting and Web Services&lt;br /&gt;
&lt;br /&gt;
ASP.Net,&amp;nbsp; ASP.NET 2.0, .Net 3.5 and&amp;nbsp; ATLAS-AJAX&lt;br /&gt;
&lt;br /&gt;
Caching Concepts,&amp;nbsp; OOPS and.Net Architecture&lt;br /&gt;
&lt;br /&gt;
ADO.Net &amp;amp; SQL Server, XML, Reports &lt;br /&gt;
&lt;br /&gt;
Localization and Globalization&amp;nbsp; &amp;amp;  Project Management&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Windows Communications and Foundations,Windows Presentation Framework and Windows Workflow Foundation&lt;br /&gt;
&lt;br /&gt;
Sample Address Application Projects.&lt;br /&gt;
&lt;br /&gt;
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 &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.flipkart.com/net-interview-questions-cd-rom-6th/p/itmdyuqzdqx8cvqx?pid=9788183331470&amp;amp;affid=suresh0483&quot; rel=&quot;nofollow&quot; target=&quot;_blank&quot;&gt;&lt;img alt=&quot;http://www.flipkart.com/net-interview-questions-cd-rom-6th/p/itmdyuqzdqx8cvqx?pid=9788183331470&amp;amp;affid=suresh0483&quot; border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZAEKIFTrhWbtb2umJkWYkI6IbHNIoWUWqfAACaK63P5CWg9sq4t0P9kfnoPDBrAkC2PEr4nOGGL1twBjtmlmajTe1uowQwnnSpB_L7rWKc_GrpBk24QQEklKzb1CsNmJ1Cs-WSmjl8A8/s1600/Dot+Net+Interview+Questions+Book.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
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.  </content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/6506225869737153846/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/dot-net-interview-questions-book-by.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6506225869737153846'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6506225869737153846'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/dot-net-interview-questions-book-by.html' title='Latest Dot Net Interview Questions Book'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZAEKIFTrhWbtb2umJkWYkI6IbHNIoWUWqfAACaK63P5CWg9sq4t0P9kfnoPDBrAkC2PEr4nOGGL1twBjtmlmajTe1uowQwnnSpB_L7rWKc_GrpBk24QQEklKzb1CsNmJ1Cs-WSmjl8A8/s72-c/Dot+Net+Interview+Questions+Book.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-8453484831740218892</id><published>2011-08-15T04:43:00.000-07:00</published><updated>2011-08-15T04:54:55.790-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Project Idea"/><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Projects"/><category scheme="http://www.blogger.com/atom/ns#" term="Final Year Project Idea."/><category scheme="http://www.blogger.com/atom/ns#" term="Mca Final year"/><title type='text'>Dot Net Project  Idea for Final Year Student</title><content type='html'>Here I am giving Some Project idea for Final Year Students.&amp;nbsp; &lt;span class=&quot;st&quot;&gt;&lt;i&gt;Final Year Project Ideas&lt;/i&gt; for B.Tech &amp;amp; MCA.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
You can choose which Technology you want to do&amp;nbsp; (VB.Net, C#.Net, ASP.Net,&amp;nbsp; SQL Server, Oracle, MySQL, and XML)&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Final Year MCA/ M.Sc./ B.Tech/ B.E/ M.Tech Project Idea :&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; School Management System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; College Manaegement System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online Tutoring System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Human Resource Management System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Mobile Ticket Reservation System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Purchase Order System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online Recruitment systems&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online Quiz System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Real estate application softwares&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Leave management system&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online Polling System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Internet Banking System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online survey tool&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Recipe management system&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Meeting Scheduler System&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Online Test System&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
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.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;h1 style=&quot;font-size: 12px;&quot;&gt;&lt;b&gt;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&amp;nbsp; Project for Final Year Students  Bangalore.&lt;/b&gt;&lt;/h1&gt;&lt;h1 style=&quot;font-size: 12px;&quot;&gt;&lt;b&gt;&amp;nbsp;&lt;/b&gt;                 &lt;/h1&gt;&amp;nbsp;&lt;span style=&quot;font-size: xx-small;&quot;&gt; Mca Final year, Dot Net Project Idea, Final Year Project Idea. New and Latest &lt;/span&gt;&lt;span style=&quot;font-size: xx-small;&quot;&gt;Dot Net Project Ideas, Computer Project Ideas,&amp;nbsp; Engineering Project, Science Fair Project Ideas, School Projects. Advanced Concept in Dot Net Projects &lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/8453484831740218892/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/dot-net-project-idea-for-final-year.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8453484831740218892'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8453484831740218892'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/dot-net-project-idea-for-final-year.html' title='Dot Net Project  Idea for Final Year Student'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-6490180483793244406</id><published>2011-08-07T12:02:00.000-07:00</published><updated>2011-08-07T12:02:06.467-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="3 + Years Experience Interview Questions"/><category scheme="http://www.blogger.com/atom/ns#" term="Advanced Interview Question in Dot Net"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.Net"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.Net 2.0"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.Net 3.5"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.Net 4.0"/><category scheme="http://www.blogger.com/atom/ns#" term="Asp.Net Interview Questions"/><category scheme="http://www.blogger.com/atom/ns#" term="Interview questions"/><title type='text'>Advanced Interview Question in Dot Net</title><content type='html'>&lt;span style=&quot;font-family: verdana;&quot;&gt;&amp;nbsp;Here&lt;b&gt;&amp;nbsp; &lt;/b&gt;&lt;/span&gt;&lt;span style=&quot;font-family: verdana;&quot;&gt;I am giving &lt;/span&gt;&lt;span style=&quot;font-family: verdana;&quot;&gt;Advanced Dotnet Interview Questions. &lt;/span&gt;You should know about WPF, WCF, Design Patterns, N Tier Architecture,&amp;nbsp; Generics and Fundamentals of .Net FrameWork. &lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;1. Explain about Generics?&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt; &lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;2. In Assembly which work as GacBrowser ?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;3. What are the consideration in deciding to use .NET Remoting or ASP.NET Web Services?&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt; &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;4. Describe the Provider Model in ASP.NET 2.0?&lt;/span&gt;&lt;span style=&quot;font-size: 85%;&quot;&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: 85%;&quot;&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;5. What do you mean by three-tier architecture?&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;6. Does .NET CLR and SQL SERVER run in different process?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;7. The IHttpHandler and IHttpHandlerFactory interfaces ?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;8. When not to use Design Patterns&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;9 . When to use Design Patterns&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;10 . Benefits of Design Patterns&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;11. What are Design Patterns?&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;12. What is difference between WCF and Web Services&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;13. What is Difference between WPF and Windows Forms.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;14. What is &lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;WCF?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;15. &lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt; What is &lt;/span&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt;WPF?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: xx-small;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;if you are going for interview , Please prefer well. 3 + Years Experience Interview Questions&lt;/span&gt;. &amp;nbsp; &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: verdana; font-size: xx-small;&quot;&gt;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&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: verdana;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-size: 85%;&quot;&gt;&lt;span style=&quot;font-family: verdana; font-weight: bold;&quot;&gt; &lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/6490180483793244406/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/advanced-interview-question-in-dot-net.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6490180483793244406'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6490180483793244406'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/advanced-interview-question-in-dot-net.html' title='Advanced Interview Question in Dot Net'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-6880117707577610611</id><published>2011-08-07T10:43:00.000-07:00</published><updated>2011-08-19T07:32:12.000-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="improve SQL Server Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="Interview questions"/><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server"/><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server Interview questions"/><title type='text'>How to improve SQL Server Performance</title><content type='html'>I am giving some points to improve the SQL Server Performance.If you want to improve your application performance, you want to improve your&amp;nbsp; SQL Server Performance also.&lt;br /&gt;
&lt;br /&gt;
1. Don&#39; t use Select * from tablename. Use SELECT ColumnName FROM tablename instead of it.&lt;br /&gt;
&lt;br /&gt;
Example : Use below Query&lt;br /&gt;
&lt;br /&gt;
SELECT EmpName FROM EmpDetails.&lt;br /&gt;
&lt;br /&gt;
2. Don&#39;t use Lower Case in SQL Server statements,&lt;br /&gt;
&lt;br /&gt;
Example : Don&#39;t use : select ColumnName from tablename.&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Use Upper case : SELECT EmpName FROM EmpDetails.&lt;br /&gt;
&lt;br /&gt;
3. Don&#39;t use &quot;IN&quot;, &quot;NOT IN&quot; , &quot;DISTINCT&quot;&amp;nbsp; in your query. if not required .&lt;br /&gt;
&lt;br /&gt;
4. Don&#39;t use &quot;Cross Join&quot; if not required &lt;br /&gt;
&lt;br /&gt;
5. Don&#39;t&amp;nbsp; use Having Clause if not required .&lt;br /&gt;
&lt;br /&gt;
6. Don&#39;t&amp;nbsp; use Cursor if not required &lt;br /&gt;
&lt;br /&gt;
It is very important for increase the performance of the SQL Server.&lt;br /&gt;
&lt;br /&gt;
If you want to improve your SQL Server, you need follow the above tips.&lt;br /&gt;
&lt;br /&gt;
It will help you.&lt;br /&gt;
&lt;br /&gt;
I will add some more point in SQL Server Performance. Thanks for spending your valuable time.&lt;br /&gt;
if you have any doubts or any suggestion, Post your comments.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/6880117707577610611/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/how-to-improve-sql-server-performance.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6880117707577610611'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6880117707577610611'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/08/how-to-improve-sql-server-performance.html' title='How to improve SQL Server Performance'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-3011579643595113117</id><published>2011-07-24T09:50:00.005-07:00</published><updated>2011-07-24T09:50:36.083-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ASP.Net"/><category scheme="http://www.blogger.com/atom/ns#" term="State Management Questions"/><title type='text'>State Management Questions</title><content type='html'>&lt;b&gt;State Management Questions&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;1. What is ViewState?&lt;/b&gt;&lt;br /&gt;
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. &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;2. What is the lifespan for items stored in ViewState?&lt;/b&gt;&lt;br /&gt;
Item stored in ViewState exist for the life of the current page.  This includes postbacks (to the same page). &lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;3. What does the &quot;EnableViewState&quot; property do?  Why would I want it on or off?&lt;/b&gt;&lt;br /&gt;
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. &lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;4. What are the different types of Session state management options available with ASP.NET?&lt;/b&gt;&lt;br /&gt;
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  &quot;sticky-server&quot; (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.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/3011579643595113117/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/state-management-questions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3011579643595113117'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3011579643595113117'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/state-management-questions.html' title='State Management Questions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-5572231991693503082</id><published>2011-07-24T09:49:00.000-07:00</published><updated>2011-07-24T09:49:04.311-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="UDDI"/><category scheme="http://www.blogger.com/atom/ns#" term="WDSL"/><category scheme="http://www.blogger.com/atom/ns#" term="Web Service Questions"/><title type='text'>Web Service Questions</title><content type='html'>&lt;b&gt;Web Service Questions&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;1. What is the transport protocol you use to call a Web service?&lt;/b&gt;&lt;br /&gt;
SOAP (Simple Object Access Protocol) is the preferred protocol. &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;2. True or False: A Web service can only be written in .NET?&lt;/b&gt;&lt;br /&gt;
False &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;3. What does WSDL stand for?&lt;/b&gt;&lt;br /&gt;
Web Services Description Language. &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;4. Where on the Internet would you look for Web services?&lt;/b&gt;&lt;br /&gt;
http://www.uddi.org &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;5. True or False: To test a Web service you must create a Windows application or Web application to consume this service?&lt;/b&gt;&lt;br /&gt;
False, the web service comes with a test page and it provides HTTP-GET method to test.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/5572231991693503082/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/web-service-questions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/5572231991693503082'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/5572231991693503082'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/web-service-questions.html' title='Web Service Questions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-6865394665153816757</id><published>2011-07-24T09:29:00.000-07:00</published><updated>2011-07-24T09:29:07.228-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".NEt 4.0 Framework"/><category scheme="http://www.blogger.com/atom/ns#" term="Web Control Class  in ASP.Net 4.0"/><title type='text'>Web Control Class  in ASP.Net 4.0</title><content type='html'>Few Basic Standard Control included in the WebControl Class :&lt;br /&gt;
&lt;br /&gt;
 Button Control&lt;br /&gt;
 CheckBox Control&lt;br /&gt;
 Label Control&lt;br /&gt;
 Textbox Control&lt;br /&gt;
 FileUpload Control&lt;br /&gt;
 Image Control&lt;br /&gt;
 ImageButton Control&lt;br /&gt;
 RadioButton Control&lt;br /&gt;
&lt;br /&gt;
I will explain this control (Web Control Class  in ASP.Net 4.0) later</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/6865394665153816757/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/web-control-class-in-aspnet-40.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6865394665153816757'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6865394665153816757'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2011/07/web-control-class-in-aspnet-40.html' title='Web Control Class  in ASP.Net 4.0'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-5679914372666522969</id><published>2010-01-15T00:07:00.001-08:00</published><updated>2011-07-24T09:34:36.353-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server Interview questions"/><title type='text'>SQL Server Interview questions</title><content type='html'>This section will contain SQL Server Interview Questions and Answers. &lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;1. How to optimize stored procedures in SQL Server?&lt;/b&gt;&lt;br /&gt;
Ans: I. Use where clause&lt;br /&gt;
II. Select only required fields&lt;br /&gt;
III. Do join on indexed key fields&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;2. What is the difference between Stored procedure and User defined functions?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
3. Why should we go for Stored Procedures? Why not direct queries?&lt;br /&gt;
Ans: SP are precompiled and contain an execution plan with it. Hence, they are faster.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;4. How many NULL values we can have in a Unique key field in SQL Server?&lt;/b&gt;&lt;br /&gt;
Ans: Only one. In case of Oracle, we can have multiple NULL values in a Unique key field.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;5. What is correlated subquery?&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;6. What is an index. What are the types?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Indexes in databases are very much similar to Indexes in Books. Indexes help in searching data faster.&lt;br /&gt;
&lt;br /&gt;
Types: Clustered Index&lt;br /&gt;
Non-Clustered Index&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;7. What is the difference between a clustered index and a non-clustered index?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Clustered:&lt;br /&gt;
1 Only one clustered index allowed per table&lt;br /&gt;
2 Physically rearranges the data&lt;br /&gt;
3 For use on columns that are frequently searched for range of data&lt;br /&gt;
&lt;br /&gt;
Non-clustered:&lt;br /&gt;
1 Upto 249 non-clustered index allowed per table&lt;br /&gt;
2 Doesn’t rearrange the data. Keeps a pointer to the data.&lt;br /&gt;
3 For use on columns that are searched for single value.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;8. What is a join? What are the types of joins?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Joins are used to retrieve data from multiple tables.&lt;br /&gt;
&lt;br /&gt;
Following are the types of joins:&lt;br /&gt;
Inner join&lt;br /&gt;
Left outer join&lt;br /&gt;
Right outer join&lt;br /&gt;
Full outer join&lt;br /&gt;
Cross join&lt;br /&gt;
&lt;b&gt;9. What is a transaction?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
A SQL transaction is a sequence of operations performed as a&lt;br /&gt;
single unit of work. If all the tasks are completed successfully, then the transaction is committed (saved). If a single task fails, the transaction is rolled back (discarded).&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;10. What is ACID property of transaction?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
A SQL transaction must exhibit ACID property, i.e Atomicity, Consistency, Isolation, and Durability.&lt;br /&gt;
&lt;br /&gt;
Atomicity: A transaction is always treated as a single unit of work, i.e. either all the tasks are performed or none of them, no intermediate stage.&lt;br /&gt;
Consistency: When a transaction is completed, it must leave all datain a consistent state. Isolation: Modifications made by a transaction must be isolated from the modifications made by other transactions. Durability: After a transaction is completed, it’s effects are permanently in place in the system.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;11. What is SET NOCOUNT ON?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
When we perform a SELECT, INSERT, UPDATE or DELETE query, it returns a COUNT (number of rows affected) when SET NOCOUNT OFF. If SET NOCOUNT ON, it doesn’t return the COUNT.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;12. How to delete exactly duplicate records from a table?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
There are many ways. Simplest answer is:&lt;br /&gt;
i. Let the table tab1 contains duplicate records.&lt;br /&gt;
ii. Insert distinct records from tab1 in a temporary table #temp&lt;br /&gt;
INSERT INTO #temp&lt;br /&gt;
SELECT DISTINCT * FROM tab1&lt;br /&gt;
iii. Delete all rows from original table tab1&lt;br /&gt;
DELETE FROM tab1&lt;br /&gt;
iv. Insert from temporary table&lt;br /&gt;
INSERT INTO tab1&lt;br /&gt;
SELECT * FROM #temp&lt;br /&gt;
Try other solutions yourself.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;13. How to get nth highest salary from employee table.&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
The query below demonstrates how to find the 5th highest salary. Replace 5 with any integer to get nth salary.&lt;br /&gt;
&lt;br /&gt;
SELECT TOP 1 SALARY&lt;br /&gt;
FROM (SELECT DISTINCT TOP 5 SALARY&lt;br /&gt;
FROM EMPLOYEE ORDER BY SALARY DESC) a&lt;br /&gt;
ORDER BY SALARY ASC&lt;br /&gt;
&lt;br /&gt;
Please post your comments here. Also, post your questions to get an answer.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/5679914372666522969/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-interview-questions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/5679914372666522969'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/5679914372666522969'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-interview-questions.html' title='SQL Server Interview questions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-7040385540516352849</id><published>2010-01-14T23:45:00.000-08:00</published><updated>2011-08-07T11:30:21.552-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Indexes in SQL Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Interview questions"/><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server Interview questions"/><category scheme="http://www.blogger.com/atom/ns#" term="Types of Indexes"/><title type='text'>What is the use of indexes and what are the types of indexes available in SQL Server?</title><content type='html'>&lt;b&gt;What is the use of indexes and what are the types of indexes available in SQL Server? &lt;/b&gt;&lt;br /&gt;
Indexes are used to find data quickly when a query is processed in any relational database. Indexes improve performance by 10 to 500 times.&lt;br /&gt;
Index can improve the performance in following operations:&lt;br /&gt;
&lt;br /&gt;
* Find the records matching with WHERE clause&lt;br /&gt;
&lt;br /&gt;
UPDATE Books SET Availability = 1 WHERE SubjectId =12&lt;br /&gt;
DELETE FROM Books WHERE Price &amp;lt;10&lt;br /&gt;
SELECT * FROM Books WHERE Price BETWEEN 50 AND 80&lt;br /&gt;
* Sorting the result with ORDER BY&lt;br /&gt;
&lt;br /&gt;
SELECT * FROM Books ORDER BY Price DESC&lt;br /&gt;
* Grouping records and aggregate values&lt;br /&gt;
&lt;br /&gt;
SELECT Count(*) as Units, Price FROM Books GROUP BY Price&lt;br /&gt;
&lt;br /&gt;
There are two types of indexes available in SQL Server: clustered and non-clustered&lt;br /&gt;
&lt;b&gt;Clustered index&lt;/b&gt;&lt;br /&gt;
Clustered index physically reorders the records of a table. Therefore a table can have only one clustered index. Usually a clustered index will be created on the primary key of a table.&lt;br /&gt;
&lt;b&gt;Non – Clustered Index&lt;/b&gt;&lt;br /&gt;
Non – Clustered index are stored in the order of the index key values, but the information in the table is stored in a different order. Means logical sorting of data not Physical. In SQl Server 2005 a table can have 249 non-clustered indexes.&lt;br /&gt;
&lt;b&gt;Composite Indexes&lt;/b&gt;&lt;br /&gt;
A composite index is an index on two or more columns. Both clustered and non-clustered indexes can be composite indexes. If you have composite index on Price and BookName then take can take advantage of it like this:&lt;br /&gt;
SELECT BookName, Price FROM Products ORDER BY UnitPrice BookName, Price DESC</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/7040385540516352849/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-use-of-indexes-and-what-are.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/7040385540516352849'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/7040385540516352849'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-use-of-indexes-and-what-are.html' title='What is the use of indexes and what are the types of indexes available in SQL Server?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-3571387564687588691</id><published>2010-01-14T23:44:00.003-08:00</published><updated>2011-07-24T09:40:53.396-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="static member of class"/><title type='text'>What is static member of class?</title><content type='html'>&lt;b&gt;What is static member of class? &lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
A static member belongs to the class rather than to the instances of the class. In C# data fields, member functions, properties and events can be declared static. When any instances of the class are created, they cannot be used to access the static member.&lt;br /&gt;
To access a static class member, use the name of the class instead of an instance variable&lt;br /&gt;
Static methods and Static properties can only access static fields and static events.&lt;br /&gt;
&lt;br /&gt;
Like: int i = Car.GetWheels;&lt;br /&gt;
Here Car is class name and GetWheels is static property.&lt;br /&gt;
&lt;br /&gt;
Static members are often used to represent data or calculations that do not change in response to object state.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/3571387564687588691/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-static-member-of-class.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3571387564687588691'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3571387564687588691'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-static-member-of-class.html' title='What is static member of class?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-6880033375509101409</id><published>2010-01-14T23:44:00.001-08:00</published><updated>2011-07-24T11:33:10.628-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="What is a static class?"/><title type='text'>What is a static class?</title><content type='html'>&lt;b&gt;What is a static class? &lt;/b&gt;&lt;br /&gt;
We can declare a &lt;b&gt;static class&lt;/b&gt;. We use static class when there is no data or behavior in the class that depends on object identity. A static class can have only static members. We can not create instances of a static class using the new keyword. &lt;b&gt;.NET Framework &lt;/b&gt;Common Language Runtime (&lt;b&gt;CLR&lt;/b&gt;) loads Static classes automatically when the program or namespace containing the class is loaded.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Here are some more features of static class&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
* Static classes only contain static members.&lt;br /&gt;
* Static classes can not be instantiated. They cannot contain Instance Constructors&lt;br /&gt;
* Static classes are sealed.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/6880033375509101409/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-static-class.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6880033375509101409'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/6880033375509101409'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-static-class.html' title='What is a static class?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-2217429094868184226</id><published>2010-01-14T23:43:00.002-08:00</published><updated>2011-07-24T11:31:43.127-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="CLR"/><category scheme="http://www.blogger.com/atom/ns#" term="Common Language Runtime"/><category scheme="http://www.blogger.com/atom/ns#" term="The Garbage Collection"/><category scheme="http://www.blogger.com/atom/ns#" term="The Garbage Collector in .Net"/><title type='text'>What is the basic functionality of Garbage Collector in Microsft.Net?</title><content type='html'>The &lt;b&gt;Common Language Runtime&lt;/b&gt; (CLR) requires that you create objects in the managed heap, but you do not have to bother with cleaning up the memory once the object goes out of the scope or is no longer needed. The&lt;b&gt; Microsoft .NET Framework Garbage Collector&lt;/b&gt; provides memory management capabilities for managed resources. &lt;b&gt;The Garbage Collector&lt;/b&gt; frees objects that are not referenced and reclaims their memory. You should set your references to Nothing(null) as soon as you are done with them to ensure your objects are eligible for collection as soon as possible.&lt;br /&gt;
&lt;b&gt;Here are the list of some tasks performed by the Garbage collector:&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
* &lt;b&gt;Garbage collector&lt;/b&gt; reserves a piece of memory as the application starts for the managed heap.&lt;br /&gt;
* &lt;b&gt;Garbage collector &lt;/b&gt;controls the managed heap memory currently used and available to an application.&lt;br /&gt;
* &lt;b&gt;Garbage collector&lt;/b&gt; allocates memory for new objects within the application.&lt;br /&gt;
* &lt;b&gt;The Garbage Collector &lt;/b&gt;attempts to reclaim the memory of objects that are not referenced.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/2217429094868184226/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-basic-functionality-of-garbage.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/2217429094868184226'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/2217429094868184226'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-basic-functionality-of-garbage.html' title='What is the basic functionality of Garbage Collector in Microsft.Net?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-252522986007828673</id><published>2010-01-14T23:43:00.001-08:00</published><updated>2011-07-24T11:34:36.418-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ACID"/><category scheme="http://www.blogger.com/atom/ns#" term="Atomicity"/><category scheme="http://www.blogger.com/atom/ns#" term="Consistency"/><category scheme="http://www.blogger.com/atom/ns#" term="Durability"/><category scheme="http://www.blogger.com/atom/ns#" term="Isolation"/><title type='text'>Explain ACID properties of the database?</title><content type='html'>All Database systems which include transaction support implement ACID properties to ensure the integrity of the database. ACID stands for Atomicity, Consistency, Isolation and Durability&lt;br /&gt;
&lt;br /&gt;
* &lt;b&gt;Atomicity&lt;/b&gt;: Each transaction is said to be “atomic.” If one part of the transaction fails, the entire transaction fails. Modifications on the data in the database either fail or succeed.&lt;br /&gt;
&lt;br /&gt;
* &lt;b&gt;Consistency&lt;/b&gt;: This property ensures that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database’s consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules.&lt;br /&gt;
&lt;br /&gt;
*&lt;b&gt; Isolation:&lt;/b&gt; It requires that multiple transactions occurring at the same time not impact each other’s execution.&lt;br /&gt;
&lt;br /&gt;
* &lt;b&gt;Durability&lt;/b&gt;: It ensures that any transaction committed to the database will not be lost.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/252522986007828673/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/explain-acid-properties-of-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/252522986007828673'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/252522986007828673'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/explain-acid-properties-of-database.html' title='Explain ACID properties of the database?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-8248957095740498099</id><published>2010-01-14T23:42:00.002-08:00</published><updated>2011-07-24T11:37:17.899-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="HTML"/><category scheme="http://www.blogger.com/atom/ns#" term="Style Sheet"/><category scheme="http://www.blogger.com/atom/ns#" term="XHTML"/><category scheme="http://www.blogger.com/atom/ns#" term="XML"/><category scheme="http://www.blogger.com/atom/ns#" term="Xml Documents"/><category scheme="http://www.blogger.com/atom/ns#" term="XSLT"/><title type='text'>What is the use of XSLT?</title><content type='html'>&lt;b&gt;&amp;nbsp;What is the use of XSLT?&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;XSLT &lt;/b&gt;stands for Extensible Stylesheet Language Transformations. This language used in XSL style sheets to transform XML documents into other XML documents.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;XSLT&lt;/b&gt; is based on template rules which specify how&lt;b&gt; XML&lt;/b&gt; documents should be processed. An &lt;b&gt;XSLT&lt;/b&gt; processor reads both an XML document and an XSLT style sheet. Based on the instructions the processor finds in the XSLT style sheet, it produce a new XML document. With XSLT we can also produce HTML or XHTML from XML document. With XSLT we can add/remove elements and attributes, rearrange and sort elements, hide and display elements from the output file. Converting XML to HTML for display is probably the most common application of XSLT today.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/8248957095740498099/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-use-of-xslt.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8248957095740498099'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8248957095740498099'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-use-of-xslt.html' title='What is the use of XSLT?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-3658498514162503362</id><published>2010-01-14T23:42:00.001-08:00</published><updated>2011-07-24T11:40:09.453-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".NEt 4.0 Framework"/><category scheme="http://www.blogger.com/atom/ns#" term="Strong Name"/><title type='text'>What is a Strong Name in Microsoft Visual Studio.Net?</title><content type='html'>&lt;b&gt;What is a Strong Name in Microsoft Visual Studio.Net? &lt;/b&gt;&lt;br /&gt;
In Microsoft Visual Studio.Net a strong name consists of the assembly&#39;s identity. The strong name guarantees the integrity of the assembly. Strong Name includes the name of the .net assembly, version number, culture identity, and a public key token. It is generated from an assembly file using the corresponding private key.&lt;br /&gt;
Steps to create strong named assembly:&lt;br /&gt;
&lt;br /&gt;
To create a strong named assembly you need to have a key pair (public key and a private key) file.&lt;br /&gt;
&lt;br /&gt;
Use sn -k KeyFile.snk&lt;br /&gt;
&lt;br /&gt;
Open the dot net project to be complied as a strong named assembly. Open AssembyInfo.cs/&lt;br /&gt;
&lt;br /&gt;
AssembyInfo.vb file. Add the following lines to AssemblyInfo file.&lt;br /&gt;
&lt;br /&gt;
[Assembly: AssemblyVersion(&quot;1.0.*&quot;)]&lt;br /&gt;
&lt;br /&gt;
[assembly: AssemblyDelaySign(false)]&lt;br /&gt;
&lt;br /&gt;
[assembly: AssemblyKeyFile(&quot;..\\..\\KeyFile.snk&quot;)]&lt;br /&gt;
&lt;br /&gt;
Compile the application, we have created a strong named assembly.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/3658498514162503362/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-strong-name-in-microsoftnet.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3658498514162503362'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3658498514162503362'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-strong-name-in-microsoftnet.html' title='What is a Strong Name in Microsoft Visual Studio.Net?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-2611242820154431538</id><published>2010-01-14T23:39:00.001-08:00</published><updated>2011-07-24T11:43:31.202-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Class"/><category scheme="http://www.blogger.com/atom/ns#" term="Destructor"/><category scheme="http://www.blogger.com/atom/ns#" term="Difference Between Classes and Structs"/><category scheme="http://www.blogger.com/atom/ns#" term="Structure"/><title type='text'>What is the difference between classes and structs in Microsoft.Net?</title><content type='html'>&lt;b&gt;What is the difference between classes and structs in Microsoft.Net? &lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
# A &lt;b&gt;struct&lt;/b&gt; is a value type, while a &lt;b&gt;class&lt;/b&gt; is a reference type.&lt;br /&gt;
&lt;br /&gt;
# When we instantiate a &lt;b&gt;class&lt;/b&gt;, memory will be allocated on the heap. When&lt;b&gt; struct &lt;/b&gt;gets initiated, it gets memory on the stack.&lt;br /&gt;
&lt;br /&gt;
# &lt;b&gt;Classes&lt;/b&gt; can have explicit parameter less constructors. But &lt;b&gt;structs&lt;/b&gt; cannot have this.&lt;br /&gt;
&lt;br /&gt;
# &lt;b&gt;Classes&lt;/b&gt; support inheritance. But there is no inheritance for structs. A &lt;b&gt;struct&lt;/b&gt; cannot inherit from another struct or class, and it cannot be the base of a class. Like classes, structures can implement interfaces.&lt;br /&gt;
&lt;br /&gt;
# We can assign null variable to&lt;b&gt; class&lt;/b&gt;. But we cannot assign null to a &lt;b&gt;struct&lt;/b&gt; variable, since &lt;b&gt;structs&lt;/b&gt; are value type.&lt;br /&gt;
&lt;br /&gt;
# We can declare a &lt;b&gt;destructor&lt;/b&gt; in class but can not in &lt;b&gt;struct.&lt;/b&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/2611242820154431538/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-difference-between-classes-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/2611242820154431538'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/2611242820154431538'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-difference-between-classes-and.html' title='What is the difference between classes and structs in Microsoft.Net?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-8097223947158284199</id><published>2010-01-14T23:38:00.001-08:00</published><updated>2011-07-24T11:46:39.776-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Connection Pooling in ADO.NET"/><category scheme="http://www.blogger.com/atom/ns#" term="ConnectionString"/><title type='text'>What is the purpose of Connection Pooling in ADO.NET?</title><content type='html'>&lt;b&gt;What is the purpose of Connection Pooling in ADO.NET?&lt;/b&gt;&lt;br /&gt;
Connection pooling enables an application to use a connection from a pool of connections that do not need to be re-established for each use. Once a connection has been created and placed in a connection pool, an application can reuse that connection without performing the complete connection creation process.&lt;br /&gt;
&lt;br /&gt;
By default, the connection pool is created when the first connection with a unique connection string connects to the database. The pool is populated with connections up to the minimum pool size. Additional connections can be added until the pool reaches the maximum pool size.&lt;br /&gt;
&lt;br /&gt;
When a user request a connection, it is returned from the pool rather than establishing new connection and, when a user releases a connection, it is returned to the pool rather than being released. But be sure than your connections use the same connection string each time. Here is the Syntax&lt;br /&gt;
&lt;br /&gt;
conn.ConnectionString = &quot;integrated Security=SSPI; SERVER=192.168.0.123; DATABASE=MY_DB; Min Pool Size=4;Max Pool Size=40;Connect Timeout=14;&quot;;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/8097223947158284199/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-purpose-of-connection-pooling.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8097223947158284199'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8097223947158284199'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/what-is-purpose-of-connection-pooling.html' title='What is the purpose of Connection Pooling in ADO.NET?'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-1655464309495612334</id><published>2010-01-14T23:36:00.002-08:00</published><updated>2011-07-24T11:49:51.815-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><category scheme="http://www.blogger.com/atom/ns#" term="Delegates"/><title type='text'>Explain the Delegates in C#.</title><content type='html'>&lt;b&gt;&lt;/b&gt;&lt;br /&gt;
Delegates in C# are objects which points towards a function which matches its signature. Delegates are reference type used to encapsulate a method with a specific signature. Delegates are similar to function pointers in C++; however, delegates are type-safe and secure.&lt;br /&gt;
Here are some features of delegates:&lt;br /&gt;
&lt;br /&gt;
* A delegate represents a class.&lt;br /&gt;
* A delegate is type-safe.&lt;br /&gt;
* We can use delegates both for static and instance methods&lt;br /&gt;
* We can combine multiple delegates into a single delegate.&lt;br /&gt;
* Delegates are often used in event-based programming, such as publish/subscribe.&lt;br /&gt;
* We can use delegates in asynchronous-style programming.&lt;br /&gt;
* We can define delegates inside or outside of classes. &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Syntax of using delegates&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
//Declaring delegate&lt;br /&gt;
delegate void SampleDelegate(string message);&lt;br /&gt;
&lt;br /&gt;
// declare method with same signature:&lt;br /&gt;
static void SampleDelegateMethod(string message) { Console.WriteLine(message); }&lt;br /&gt;
&lt;br /&gt;
// create delegate object&lt;br /&gt;
SampleDelegate d1 = SampleDelegateMethod;&lt;br /&gt;
&lt;br /&gt;
// Invoke method with delegate&lt;br /&gt;
d1(&quot;my program&quot;);</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/1655464309495612334/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/explain-delegates-in-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/1655464309495612334'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/1655464309495612334'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/explain-delegates-in-c.html' title='Explain the Delegates in C#.'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-3608151967322977665</id><published>2010-01-14T23:36:00.001-08:00</published><updated>2011-07-24T11:49:31.502-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Namespace"/><category scheme="http://www.blogger.com/atom/ns#" term="Reference types"/><category scheme="http://www.blogger.com/atom/ns#" term="Structure"/><category scheme="http://www.blogger.com/atom/ns#" term="Value types"/><title type='text'>Value types VS Reference types C#</title><content type='html'>&lt;b&gt;What is difference between Value types and Reference types in VB.NET or C# (Value types VS Reference types)&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
C# provides two types—class and structure, class is a reference type while the other is a value type. Here is difference between Value types and Reference types.&lt;br /&gt;
&lt;br /&gt;
Value types directly contain their data which are either allocated on the stack or allocated in-line in a structure. Reference types store a reference to the value&#39;s memory address, and are allocated on the heap. With reference types, an object is created in memory, and then handled through a separate reference—rather like a pointer.&lt;br /&gt;
&lt;br /&gt;
Reference types can be self-describing types, pointer types, or interface types. Primitive types such as int, float, bool and char are value types.&lt;br /&gt;
&lt;br /&gt;
Variables that are value types each have their own copy of the data, and therefore operations on one variable do not affect other variables. Variables that are reference types can refer to the same object; therefore, operations on one variable can affect the same object referred to by another variable.&lt;br /&gt;
&lt;br /&gt;
Value types have a default implied constructor that initializes the default value. Reference types default to a null reference in memory.&lt;br /&gt;
&lt;br /&gt;
Value types derive from System.ValueType. Reference types derive from System.Object.&lt;br /&gt;
&lt;br /&gt;
Value types cannot derive a new type from an existing value type, except for structs. Reference types can derive a new type from an existing reference type as well as being able to implement interfaces.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/3608151967322977665/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/value-types-vs-reference-types-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3608151967322977665'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3608151967322977665'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/value-types-vs-reference-types-c.html' title='Value types VS Reference types C#'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-3544257356040670346</id><published>2010-01-14T23:35:00.002-08:00</published><updated>2011-07-24T11:51:04.440-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server 2008 Advantages"/><title type='text'>SQL Server 2008 advantages for Developers</title><content type='html'>Microsoft has released a new version of its popular Database management system (SQL Server). It is Microsoft SQL Server 2008. So what are the benefits of SQL SERVER 2008 for Developers &amp;amp; Programmers.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SQL Management Studio improvements including IntelliSense.&lt;br /&gt;
&lt;br /&gt;
New Data Types for just dates or times (no more storing time when you only need the date).&lt;br /&gt;
&lt;br /&gt;
New Hierarchical data support .IsDescendent(), that can automatically pull a hierarchical view of data (no more custom recursive queries).&lt;br /&gt;
&lt;br /&gt;
New Grouping Sets statement which enables you to automatically group dimensions in a query for easy aggregation and reporting.&lt;br /&gt;
&lt;br /&gt;
New Merge statement which provides automatic insert/update semantics for keeping multiple data sources in sync.&lt;br /&gt;
&lt;br /&gt;
New data types and support for Geodata and geometry.&lt;br /&gt;
&lt;br /&gt;
New support for optimizing &quot;empty&quot; or row/column tables using the sparse keyword.&lt;br /&gt;
&lt;br /&gt;
New FileStream attribute that enables you to include files that are stored in the server file system, but can be managed by SQL Server.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/3544257356040670346/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-2008-advantages-for.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3544257356040670346'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/3544257356040670346'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-2008-advantages-for.html' title='SQL Server 2008 advantages for Developers'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-8678261421781656579</id><published>2010-01-14T23:35:00.001-08:00</published><updated>2011-07-24T11:52:13.736-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL Server Basic Databases"/><title type='text'>SQL Server Basic Databases</title><content type='html'>SQL Server Interview Question. Name the Basic or Default Databases of SQL SERVER and What are their functions and use.?&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Microsoft SQL SERVER Provides 4 default databases&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The tempdb holds temporary objects such as global and local temporary tables and stored procedures. The model is essentially a template database used in the creation of any new user database created in the instance.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/8678261421781656579/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-basic-databases.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8678261421781656579'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8678261421781656579'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/sql-server-basic-databases.html' title='SQL Server Basic Databases'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-414593211818006334</id><published>2010-01-14T23:34:00.001-08:00</published><updated>2011-07-24T11:53:11.010-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Aggregate Functions in SQL SERVER 2008"/><title type='text'>Aggregate Functions in SQL SERVER 2008</title><content type='html'>&lt;b&gt;What are Aggregate functions? Explain Aggregate functions in SQL SERVER 2008 with example.&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Aggregate functions are applied to a group of data values from a column. Aggregate functions always return a single value.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;SQL SERVER 2008 / Transact-SQL supports following aggregate functions:&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;AVG:&lt;/b&gt; Calculates the arithmetic mean (average) of the data values contained within a column. The column must contain numeric values.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;MAX and MIN:&lt;/b&gt; Calculate the maximum and minimum data value of the column, respectively. The column can contain numeric, string, and date/time values.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;SUM: &lt;/b&gt;Calculates the total of all data values in a column. The column must contain numeric values.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;COUNT:&lt;/b&gt; Calculates the number of (non-null) data values in a column. The only aggregate function not being applied to columns is COUNT(*). This function returns the number of rows (whether or not particular columns have NULL values).&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;COUNT_BIG: &lt;/b&gt;New and Analogous to COUNT, the only difference being that COUNT_BIG returns a value of the BIGINT data type.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Aggregate function Example:&lt;/b&gt;&lt;br /&gt;
SELECT ProjectName, SUM(budget) TotalBudget FROM Project_Tbl GROUP BY ProjectName;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/414593211818006334/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/aggregate-functions-in-sql-server-2008.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/414593211818006334'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/414593211818006334'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2010/01/aggregate-functions-in-sql-server-2008.html' title='Aggregate Functions in SQL SERVER 2008'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-1277292806483018819</id><published>2009-12-16T20:59:00.001-08:00</published><updated>2011-08-14T09:49:07.840-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Inteview Questions"/><title type='text'>Dot Net Inteview Questions -V</title><content type='html'>I have&amp;nbsp; added Few Asp.Net Interview Questions and Answer&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q81. What technique is used to figure out that the page request is a postback?&lt;/b&gt;&lt;br /&gt;
Ans. The IsPostBack property of the page object may be used to check whether the page request is a postback or not. IsPostBack property is of the type Boolean.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q82. Which event of the ASP.NET page life cycle completely loads all the controls on the web page?&lt;/b&gt;&lt;br /&gt;
Ans. The Page_load event of the ASP.NET page life cycle assures that all controls are completely loaded. Even though the controls are also accessible in Page_Init event but here, the viewstate is incomplete.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q83. How is ViewState information persisted across postbacks in an ASP.NET webpage?&lt;/b&gt;&lt;br /&gt;
Ans. Using HTML Hidden Fields, ASP.NET creates a hidden field with an ID=&quot;__VIEWSTATE&quot; and the value of the page&#39;s viewstate is encoded (hashed) for security.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q84. What is the ValidationSummary control in ASP.NET used for?&lt;/b&gt;&lt;br /&gt;
Ans. The ValidationSummary control in ASP.NET displays summary of all the current validation errors.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q85. What is AutoPostBack feature in ASP.NET?&lt;/b&gt;&lt;br /&gt;
Ans. In case it is required for a server side control to postback when any of its event is triggered, then the AutoPostBack property of this control is set to true.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q86. What is the difference between Web.config and Machine.Config in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Web.config file is used to make the settings to a web application, whereas Machine.config file is used to make settings to all ASP.NET applications on a server(the server machine).&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q87. What is the difference between a session object and an application object?&lt;/b&gt;&lt;br /&gt;
Ans. A session object can persist information between HTTP requests for a particular user, whereas an application object can be used globally for all the users.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q88. Which control has a faster performance, Repeater or Datalist?&lt;/b&gt;&lt;br /&gt;
Ans. Repeater.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q89. Which control has a faster performance, Datagrid or Datalist?&lt;/b&gt;&lt;br /&gt;
Ans. Datalist.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q90. How to we add customized columns in a Gridview in ASP.NET?&lt;/b&gt;&lt;br /&gt;
Ans. Make use of the TemplateField column.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q91. Is it possible to stop the clientside validation of an entire page?&lt;/b&gt;&lt;br /&gt;
Ans. Set Page.Validate = false;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q92. Is it possible to disable client side script in validators?&lt;/b&gt;&lt;br /&gt;
Ans. Yes. simply EnableClientScript = false.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q93. How do we enable tracing in .NET applications?&lt;/b&gt;&lt;br /&gt;
Ans. &amp;lt;%@ Page Trace=&quot;true&quot; %&amp;gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q94. How to kill a user session in ASP.NET?&lt;/b&gt;&lt;br /&gt;
Ans. Use the Session.abandon() method.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q95. Is it possible to perform forms authentication with cookies disabled on a browser?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, it is possible.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q96. What are the steps to use a checkbox in a gridview?&lt;/b&gt;&lt;br /&gt;
Ans. &lt;itemtemplate&gt;&lt;br /&gt;
&lt;asp:checkbox autopostback=&quot;True&quot; id=&quot;CheckBox1&quot; oncheckedchanged=&quot;Check_Clicked&quot; runat=&quot;server&quot;&gt;&lt;/asp:checkbox&gt;&lt;br /&gt;
&lt;/itemtemplate&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q97. What are design patterns in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. A Design pattern is a repeatitive solution to a repeatitive problem in the design of a software architecture.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q98. What is difference between dataset and datareader in ADO.NET?&lt;/b&gt;&lt;br /&gt;
Ans. A DataReader provides a forward-only and read-only access to data, while the DataSet object can carry more than one table and at the same time hold the relationships between the tables. Also note that a DataReader is used in a connected architecture whereas a Dataset is used in a disconnected architecture.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q99. Can connection strings be stored in web.config?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, in fact this is the best place to store the connection string information.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q100. Whats the difference between web.config and app.config?&lt;/b&gt;&lt;br /&gt;
Ans. Web.config is used for web based asp.net applications whereas app.config is used for windows based applications.&lt;br /&gt;
&amp;nbsp;if you want any interview question, post your comments, we will send you.&lt;br /&gt;
&lt;br /&gt;
You can refer following link .Net Interview Question.&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot.html&quot;&gt;Dot Net Inteview Questions -I&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-ii.html&quot;&gt;Dot Net Inteview Questions -II&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iii.html&quot;&gt;Dot Net Inteview Questions -III&lt;/a&gt;&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iv.html&quot;&gt;Dot Net Inteview Questions -IV&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-v.html&quot;&gt;Dot Net Inteview Questions -V&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
If you have any questions or suggestion, Post your Comments.&amp;nbsp; </content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/1277292806483018819/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-v.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/1277292806483018819'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/1277292806483018819'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-v.html' title='Dot Net Inteview Questions -V'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-4016526653277430920</id><published>2009-12-16T20:58:00.002-08:00</published><updated>2011-07-24T10:50:04.785-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Inteview Questions"/><title type='text'>Dot Net Inteview Questions -IV</title><content type='html'>&lt;b&gt;Q61. Is a delegate a type-safe functions pointer?&lt;/b&gt;&lt;br /&gt;
Ans. Yes&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q62. What is the return type of an event in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. There is No return type of an event in .NET.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q63. Is it possible to specify an access specifier to an event in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, though they are public by default.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q64. Is it possible to create a shared event in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, but shared events may only be raised by shared methods.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q65. How to prevent overriding of a class in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Use the keyword NotOverridable in VB.NET and sealed in C#.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q66. How to prevent inheritance of a class in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Use the keyword NotInheritable in VB.NET and sealed in C#.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q67. What is the purpose of the MustInherit keyword in VB.NET?&lt;/b&gt;&lt;br /&gt;
Ans. MustInherit keyword in VB.NET is used to create an abstract class.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q68. What is the access modifier of a member function of in an Interface created in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. It is always public, we cant use any other modifier other than the public modifier for the member functions of an Interface.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q69. What does the virtual keyword in C# mean?&lt;/b&gt;&lt;br /&gt;
Ans. The virtual keyword signifies that the method and property may be overridden.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q70. How to create a new unique ID for a control?&lt;/b&gt;&lt;br /&gt;
Ans. ControlName.ID = &quot;ControlName&quot; + Guid.NewGuid().ToString(); //Make use of the Guid class&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q71A. What is a HashTable in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. A Hashtable is an object that implements the IDictionary interface, and can be used to store key value pairs. The key may be used as the index to access the values for that index.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q71B. What is an ArrayList in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Arraylist object is used to store a list of values in the form of a list, such that the size of the arraylist can be increased and decreased dynamically, and moreover, it may hold items of different types. Items in an arraylist may be accessed using an index.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q72. What is the value of the first item in an Enum? 0 or 1?&lt;/b&gt;&lt;br /&gt;
Ans. 0&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q73. Can we achieve operator overloading in VB.NET?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, it is supported in the .NET 2.0 version, the &quot;operator&quot; keyword is used.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q74. What is the use of Finalize method in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. .NET Garbage collector performs all the clean up activity of the managed objects, and so the finalize method is usually used to free up the unmanaged objects like File objects, Windows API objects, Database connection objects, COM objects etc.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q75. How do you save all the data in a dataset in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Use the AcceptChanges method which commits all the changes made to the dataset since last time Acceptchanges was performed.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q76. Is there a way to suppress the finalize process inside the garbage collector forcibly in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. Use the GC.SuppressFinalize() method.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q77. What is the use of the dispose() method in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. The Dispose method in .NET belongs to IDisposable interface and it is best used to release unmanaged objects like File objects, Windows API objects, Database connection objects, COM objects etc from the memory. Its performance is better than the finalize() method.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;Q78. Is it possible to have have different access modifiers on the get and set methods of a property in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. No we can not have different modifiers of a common property, which means that if the access modifier of a property&#39;s get method is protected, and it must be protected for the set method as well.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q79. In .NET, is it possible for two catch blocks to be executed in one go?&lt;/b&gt;&lt;br /&gt;
Ans. This is NOT possible because once the correct catch block is executed then the code flow goes to the finally block.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q80. Is there any difference between System.String and System.StringBuilder classes?&lt;/b&gt;&lt;br /&gt;
Ans. System.String is immutable by nature whereas System.StringBuilder can have a mutable string in which plenty of processes may be performed.&lt;br /&gt;
You can refer following link .Net Interview Question.&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot.html&quot;&gt;Dot Net Inteview Questions -I&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-ii.html&quot;&gt;Dot Net Inteview Questions -II&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iii.html&quot;&gt;Dot Net Inteview Questions -III&lt;/a&gt;&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iv.html&quot;&gt;Dot Net Inteview Questions -IV&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-v.html&quot;&gt;Dot Net Inteview Questions -V&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/4016526653277430920/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iv.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/4016526653277430920'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/4016526653277430920'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iv.html' title='Dot Net Inteview Questions -IV'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5998782275654434983.post-8177607169524728950</id><published>2009-12-16T20:58:00.001-08:00</published><updated>2011-07-24T10:50:20.252-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Dot Net Inteview Questions"/><title type='text'>Dot Net Inteview Questions -III</title><content type='html'>&lt;b&gt;Q41. How to instruct the garbage collector to collect unreferenced data?&lt;/b&gt;&lt;br /&gt;
Ans. We may call the garbage collector to collect unreferenced data by executing the System.GC.Collect() method.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q42. How can we set the Focus on a control in ASP.NET?&lt;/b&gt;&lt;br /&gt;
Ans. txtBox123.Focus(); OR Page.SetFocus(NameOfControl);&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q43. What are Partial Classes in Asp.Net 2.0?&lt;/b&gt;&lt;br /&gt;
Ans. In .NET 2.0, a class definition may be split into multiple physical files but partial classes do not make any difference to the compiler as during compile time, the compiler groups all the partial classes and treats them as a single class.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q44. How to set the default button on a Web Form?&lt;/b&gt;&lt;br /&gt;
Ans. &lt;asp:form defaultbutton=&quot;btnGo&quot; id=&quot;form1&quot; runat=&quot;server&quot;&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q45.Can we force the garbage collector to run?&lt;/b&gt;&lt;br /&gt;
Ans. Yes, using the System.GC.Collect(), the garbage collector is forced to run in case required to do so.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q46. What is Boxing and Unboxing?&lt;/b&gt;&lt;br /&gt;
Ans. Boxing is the process where any value type can be implicitly converted to a reference type object while Unboxing is the opposite of boxing process where the reference type is converted to a value type.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q47. What is Code Access security? What is CAS in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. CAS is the feature of the .NET security model that determines whether an application or a piece of code is permitted to run and decide the resources it can use while running.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q48. What is Multi-tasking?&lt;/b&gt;&lt;br /&gt;
Ans. It is a feature of operating systems through which multiple programs may run on the operating system at the same time, just like a scenario where a Notepad, a Calculator and the Control Panel are open at the same time.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q49. What is Multi-threading?&lt;/b&gt;&lt;br /&gt;
Ans. When an application performs different tasks at the same time, the application is said to exhibit multithreading as several threads of a process are running.2&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q50. What is a Thread?&lt;/b&gt;&lt;br /&gt;
Ans. A thread is an activity started by a process and its the basic unit to which an operating system allocates processor resources.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q51. What does AddressOf in VB.NET operator do?&lt;/b&gt;&lt;br /&gt;
Ans. The AddressOf operator is used in VB.NET to create a delegate object to a method in order to point to it.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q52. How to refer to the current thread of a method in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. In order to refer to the current thread in .NET, the Thread.CurrentThread method can be used. It is a public static property.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q53. How to pause the execution of a thread in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. The thread execution can be paused by invoking the Thread.Sleep(IntegerValue) method where IntegerValue is an integer that determines the milliseconds time frame for which the thread in context has to sleep.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q54. How can we force a thread to sleep for an infinite period?&lt;/b&gt;&lt;br /&gt;
Ans. Call the Thread.Interupt() method.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
Q55. What is Suspend and Resume in .NET Threading?&lt;/b&gt;&lt;br /&gt;
Ans. Just like a song may be paused and played using a music player, a thread may be paused using Thread.Suspend method and may be started again using the Thread.Resume method. Note that sleep method immediately forces the thread to sleep whereas the suspend method waits for the thread to be in a persistable position before pausing its activity.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q56. How can we prevent a deadlock in .Net threading?&lt;/b&gt;&lt;br /&gt;
Ans. Using methods like Monitoring, Interlocked classes, Wait handles, Event raising from between threads, using the ThreadState property.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q57. What is Ajax?&lt;/b&gt;&lt;br /&gt;
Ans. Asyncronous Javascript and XML - Ajax is a combination of client side technologies that sets up asynchronous communication between the user interface and the web server so that partial page rendering occur instead of complete page postbacks.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q58. What is XmlHttpRequest in Ajax?&lt;/b&gt;&lt;br /&gt;
Ans. It is an object in Javascript that allows the browser to communicate to a web server asynchronously without making a postback.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q59. What are the different modes of storing an ASP.NET session?&lt;/b&gt;&lt;br /&gt;
Ans. InProc (the session state is stored in the memory space of the Aspnet_wp.exe process but the session information is lost when IIS reboots), StateServer (the Session state is serialized and stored in a separate process call Viewstate is an object in .NET that automatically persists control setting values across the multiple requests for the same page and it is internally maintained as a hidden field on the web page though its hashed for security reasons.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Q60. What is a delegate in .NET?&lt;/b&gt;&lt;br /&gt;
Ans. A delegate in .NET is a class that can have a reference to a method, and this class has a signature that can refer only those methods that have a signature which complies with the class.&lt;/asp:form&gt;&lt;br /&gt;
&lt;br /&gt;
You can refer following link .Net Interview Question.&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot.html&quot;&gt;Dot Net Inteview Questions -I&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-ii.html&quot;&gt;Dot Net Inteview Questions -II&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iii.html&quot;&gt;Dot Net Inteview Questions -III&lt;/a&gt;&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iv.html&quot;&gt;Dot Net Inteview Questions -IV&lt;/a&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-v.html&quot;&gt;Dot Net Inteview Questions -V&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://dotnetxpertsforum.blogspot.com/feeds/8177607169524728950/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iii.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8177607169524728950'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5998782275654434983/posts/default/8177607169524728950'/><link rel='alternate' type='text/html' href='http://dotnetxpertsforum.blogspot.com/2009/12/dot-net-inteview-questions-iii.html' title='Dot Net Inteview Questions -III'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>