Summary of recent ASP. NET problem and corresponding solution

1. Use SQL to count the number of characters specified in a string, example (count 0):

Select Len ('402301001'-len(replace('402301001 ','0',') ')

2. Using Forms authentication, the client local time is not able to log on to the system, the workaround:

FormsAuthentication.RedirectFromLoginPage The second parameter is set to FALSE,MSDN data: http://msdn.microsoft.com/zh-cn/library/ka5ffkce (v=vs.110). aspx

3. Web server cpu100%, which is the result of that site in IIS:

① first set the task Manager to view the way, adding PID display;

② Use the C:\windows\system32\inetsrv>appcmd list WP command to locate the specific site PID (here is the command in Server 2008, Server 2003 is the IISAPP-A command);

4. jQuery1.6 attr ("checked") invalid, correct wording:

Three ways of writing:if (elem.checked) or if ($ (elem). Prop ("checked")) or if ($ (elem). Is (": Checked"))

Official Document: http://api.jquery.com/attr/

5. N Multi-log4net log files can only be found with EditPlus. Workaround: Write the query with log Parser lizard or SQL SERVER

6. Web site prompts to access IIS metabase failure, workaround (command): Aspnet_regiis-ga ASPNET

7. Remote Desktop shuts down the explorer process, how to open the Remote Desktop Task Manager: Ctrl+shift+esc

8.. Version NET2.0 serialized dataset serialized as Json,json deserialized dataset:http://json.codeplex.com/

9. quickly generate an organization chart for Excel data: http://www.visio123.com/Visio_2010/Visiokuachengxushiyong/20130225/33.html

. Web. config upload file size setting (Windows Server 2008 is not the same as the previous Windows Server 2003 settings):

The Web. config in Windows Server 2003 is configured to add the following configuration under the system.web node:

<!-- 100MB  - <  maxrequestlength= "102400"  usefullyqualifiedredirecturl= "true"/ >

The Web. config in Windows Server 2008 also has to add the following configuration under the System.webserver node:

< Security >    < requestfiltering >        <  maxallowedcontentlength= "102400000"/>    </  Requestfiltering></security>

Specific setting method, reference: Http://www.cnblogs.com/henryhappier/archive/2010/09/20/1832098.html. The actual test found that the configuration of 102400000 20MB files on the exception, configured to 1024000000 is no problem ...

Summary of recent ASP. NET problem and corresponding solution