Telerik Grid Item 的客制化文件

http://www.telerik.com/help/aspnet/grid/grdinsertingvaluesusercontrolformtemplate.html

生活哲學

好好活，慢慢拖，一年還有幾萬多；
不要攀，不要比，不要自己氣自己；
少吃鹽，多吃醋，少打麻將多散步；
按時睡，按時起，跑步跳舞健身體；
父是天，母是地，盡孝父母要牢記；
夫妻愛，子女孝，家和比啥都重要；
行點善，積點德，多做善事多積德；
只要能吃飯，錢就不會斷；
不怕賺錢少，就怕走得早；
官再大，錢再多，閻王照樣土裡拖；

利用 Trigger 來限制登錄 SQL Server

網路找到的文章

不從特定 IP 不准某帳號登入 SQL Server

CREATE TRIGGER [connection_limit_trigger]
ON ALL SERVER
WITH EXECUTE AS 'I7Administrator'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'sa' AND
not exists  (SELECT * FROM sys.dm_exec_connections
            WHERE client_net_address = ’127.0.0.1′
            and session_id=@@SPID)
    ROLLBACK;
END;

–ENABLE TRIGGER [connection_limit_trigger] ON ALL SERVER

其中
ORIGINAL_LOGIN() -- 系統函數, 目前登錄的 帳號
sYS.DM_EXEC_CONNECTIONS -- 目前連線的動態表格
@@SPID -- 目前登錄的 Session ID

Web Performance Tips

Useful page from WEB 

While developing any web site, one should keep some points in mind.

1) Set debug=false under compilation as follows:

<compilation default Language="c#" debug="false">

2) Use Server.Transfer instead of Response.Redirect.

3) Always check Page.IsValid when using Validator Controls

4) Use Foreach loop instead of For loop for String Iteration.

5) Use Client-Side Validation. (but not all the time you have to validate even on the server side)

6) Check “Page.IsPostBack”. To avoid repetition code execution.

7) GIF and PNG are similar, but PNG typically produces a lower file size. (True, but some browsers not supporting PNG format)

8) Use the AppOffline.htm when updating binaries

9) Turn off Tracing unless until required. (by default it's off, use on the pages where it's required)

<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>

10) Precompiled pages and disable AutoEventWireup; setting the AutoEventWireup attribute to false in the Machine.config file.

11) Turn off Session State, if not required.

<sessionstate timeout="20" cookieless="false" mode="Off" stateconnectionstring="tcpip=127.0.0.1:42424" sqlconnectionstring="data source=127.0.0.1;Trusted_Connection=no">

12) Select the Release mode before making the final Build for your application.

This option is available in the Top Frame just under the Window Menu option. By default, the Mode is Debug

13) Disable ViewState when not required.

EnableViewState="false"

14) Avoid frequent round trips to the Database.

15) Use Caching to improve the performance of your application.

16) Validate all Input received from the Users.

17) Use Finally Method to kill resources. (But not in the case of using)

18) The String and Stringbuilder Magic.

It is nice to use Stringbuilder instead of String when string are Amended. Strings occupy different memory location in every time of amended where stringbuilder use single memory location

19) Never use object value directly; first get object value in local variable and then use. It takes more time then variable reading.

20) Avoid Exceptions: Use If condition (if it is check proper condition)

21) Code optimization:  Avoid using code like x = x +1; it is always better to use x+=1.

22) Data Access Techniques: DataReaders provide a fast and efficient method of data retrieval. DataReader is much faster than DataSets as far as performance is concerned

23) Before doing a bulky ASP code processing, you can check to make sure Response.IsClientConnected.

24) As always, avoid session variables because each ASP page runs in a different thread and session calls will be serialized one by one. So, this will slow down the application. Instead of session variables you can use the QueryString collection or hidden variables in the form which holds the values.

25) Enabling buffering will improve the performance, like

<% response.buffer=true %>

Then use:

<% response.flush=true %> 

26) Use Repeater control instead of DataGrid , DataList, Because It is efficient, customizable, and programmable.

27) Data listing is more time consume when large data are retrieve from database.

Paging will display only particular data but take load of all data.

Fetch only data that is needed for current page.

28) Avoid Inline JavaScript and CSS

29) Use single css file instead of multiple css file.

Try your best to combine all your CSS based classes into a single .css file as lot of .css files will cause a large amount of requests, regardless of the file sizes.

.css files are normally cached by browsers, so a single and heavy .css file doesn’t cause a long wait on each page request.

Inline .css classes could make HTML heavy, so again: go ahead with a single.css file.

30) Reduce cookie size

31) Compress CSS, JavaScript and Images

Online compressors are available; to compress file please refers following web and Replace your file content with optimize code.

http://iceyboard.no-ip.org/projects/css_compressor for CSS compression

www.xtreeme.com/javascript-optimizer/ . For JS Compression

32 .Use Cache appropriately

i. Page output caching:

<%@ OutputCache Duration="3600" VaryByParam="none" %>

ii. Page fragment caching:

Write a Page output caching code into each User Control

iii. Data caching:

<script language="C#" runat="server">

Protected void Page_Load (Object src, EventArgs e) {

DataView dv = (DataView) Cache. Get ("EmployeesDataView");

If (dv == null) { // wasn't thereSqlConnection conn =

new SqlConnection ("server=localhost;uid=sa;pwd=;database=Test");

SqlDataAdapter da =new SqlDataAdapter ("select * from Employees", conn);

Dataset ds = new DataSet();da.Fill(ds, "Employees");

dv = ds.Tables["Employees"].DefaultView;

Cache.Insert ("EmployeesDataView", dv);conn.Close();}

Else

Response.Write ("<h2>Loaded employees from data cache! </h2>");

lb1.DataSource = dv;

lb1.DataTextField = "Name";

lb1.DataValueField = "Age";

DataBind () ;}

</script>

33) Use server side compression software such as Port80shttp://www.port80software.com/products/httpzip/  

34) Usage of "using" and I don't know why it's not yet published.

35) Don't make the member variables public or proteted, try to keep private and use public/protected as properties.

36) Use strString=string.Empty instead of strString="" . [And perhaps instead of strString=null also (?)]

37) Make your page files as light as possible. That is try to avoid unnecessary markups, e.g. use div elements instead of tables.

38) Write static messages in div and make it visible when necessary. This is faster than letting server set Text property of your label or div.

39) Retrieve data from database at once, if possible. Don't add up to database trip as far as possible. For this, combine the datafields from different tables and select them.

40) Use short ID name for WebControl.