Thursday, August 22, 2013

Difference between Stored Procedure and Function In Sql

Hello Friends, Today I am writing this post because of this is very important question in interview  Inside procedure we can use DML (Insert /Update/Delete) statements, But Inside function we can not use DML statements. Procedure can have both input\output parameters,  But Function can have only input parameter. We can use Try-Catch Block in Stored Procedure, But In Function We can not use Try-Catch block. We can not use Stored Procedure in Select statement, But In Function We can use in Select statement. Stored Procedure can return 0 or n values (max 1024), But Function...


Wednesday, August 21, 2013

12 Steps To Create C# Documentation Using Xml Using SandCastle

C# Documentation Using Xml Hello Friends, Today I am writing this post because of creating a documentation of coding for .Net developers.  Documentation will to understand code standard, programming tricks and project that is created by other. C# Documentation Using Xml 1.    First of all Programmer/Developer have to write xml comment         code  in Source  file. Example: /// <summary> /// The constructor sets the name, age and cash /// </summary> /// <param name="name">The name of the guy</param> ///...


Tuesday, August 20, 2013

ASP.NET Application and Page life cycle

Hi Friends,  Welcome in DotNet Developers Cafe. This is my first post. So, read it and enjoy... The ASP.Net life cycle could be divided into two groups: Application Life Cycle Page Life Cycle ASP.Net Application Life Cycle: The application life cycle has the following stages: User makes a request for accessing application resource, a page. Browser sends this request to the web server. A unified pipeline receives the first request and the following events take place: An object of the ApplicationManager class is created. An object of...