November 2016 - SharePointCafe.Net

How to maintain page scroll position after page post back in asp.net

March 21, 2024November 30, 2016 by sharepointcafe

In this blog, I will write about How to maintain page scroll position after page post back in ASP.Net. Suppose there is a page with a huge number of inputs and in one case some error/exception occurs at bottom of the page. But in the postback, the page scroll position moved to the top. In … Read more

Differences between Stored Procedure and Functions

November 24, 2016 by sharepointcafe

Very frequent question asked in interview is Differences between Stored Procedure and Functions.Below are the differences between these 2. 1) Functions must return a value. Stored procedure need not be.2) Stored procedures can be called using EXEC command where as Functions can be called from another SQL Statement.3) Stored Procedures are precompiled. Functions are not precompiled.4) Generally Stored procedures are … Read more