Web App: Caching
Concept How many caching form does ASP.NET have? Page level output caching The simplest form of caching, output caching simply keeps a copy of the […]
Day: October 26, 2017
SQL: How to use “order by” with “select distinct”?
A query with SELECT DISTINCT can be rewritten using GROUP BY. So this [sql] SELECT DISTINCT city FROM HR.Employees WHERE country = N’USA’ AND region […]
Web App: Access Limitation
Concept DB design 1 “users” table [sql] 1 AA 2 BB [/sql] “authority_groups” table [sql] group_auto name 1 Admin 2 Writer [/sql] “authority_group_items” table [sql] […]
Web App: Common area – Menu, Header, Footer
Concept ASP.NET Use ASCX file. A file with the ASCX file extension is an ASP.NET Web User Control file. Basically, ASCX files make it easy […]