Wednesday, March 31, 2010
Sunday, March 28, 2010
Friday, March 26, 2010
Date Extract function of Oracle
select extract(day from date1) from table
select extract(month from date1) from table
select extract(year from date1) from table
select extract(month from date1) from table
select extract(year from date1) from table
Thursday, March 25, 2010
JSP request.setCharacterEncoding
Today I just find that what I have inserted into database (Chinese characters) is scrambled code.
Finally, the solution is
request.setCharacterEncoding("utf8");
JavaServer Page Implicit Objects
http://www.gulland.com/courses/JavaServerPages/jsp_objects.jsp
Finally, the solution is
request.setCharacterEncoding("utf8");
JavaServer Page Implicit Objects
http://www.gulland.com/courses/JavaServerPages/jsp_objects.jsp
Oracle Special Table - Dual
Oracle:
Dual is a special table with a garbage cell which is used for our queries.
For example,
select seq.nextval from dual
Dual is a special table with a garbage cell which is used for our queries.
For example,
select seq.nextval from dual
Wednesday, March 24, 2010
Friday, March 19, 2010
Useful .net 4.0 features
http://msdn.microsoft.com/en-us/library/ms171868%28VS.100%29.aspx
The following list describes additional new capabilities, improvements, and conveniences. Several of these are based on customer suggestions.
To support culture-sensitive formatting, the System.TimeSpan structure includes new overloads of the ToString, Parse, and TryParse methods, as well as new ParseExact and TryParseExact methods.
The new String.IsNullOrWhiteSpace method indicates whether a string is null, empty, or consists only of white-space characters. New overloads have been added to the String.Concat and String.Join methods that concatenate members of System.Collections.Generic.IEnumerable<(Of <(T>)>) collections.
The String.Concat method lets you concatenate each element in an enumerable collection without first converting the elements to strings.
The System.Guid structure now contains the TryParse and TryParseExact methods.
Secure Sockets Layer (SSL) support for the System.Net.Mail.SmtpClient and related classes.
Credentials for password-based authentication schemes such as basic, digest, NTLM, and Kerberos authentication in the System.Net..::.NetworkCredential class. To improved security, passwords may now be treated as System.Security.SecureString instances rather than System.String instances.
Ability to specify how a URI with percent-encoded values is converted and normalized in the System..::.Uri and System.Net.HttpListener classes. For more information, see the System.Net.Configuration.HttpListenerElement, System.Configuration.SchemeSettingElement, System.Configuration.SchemeSettingElementCollection, and System.Configuration.UriSection classes.
The following list describes additional new capabilities, improvements, and conveniences. Several of these are based on customer suggestions.
To support culture-sensitive formatting, the System.TimeSpan structure includes new overloads of the ToString, Parse, and TryParse methods, as well as new ParseExact and TryParseExact methods.
The new String.IsNullOrWhiteSpace method indicates whether a string is null, empty, or consists only of white-space characters. New overloads have been added to the String.Concat and String.Join methods that concatenate members of System.Collections.Generic.IEnumerable<(Of <(T>)>) collections.
The String.Concat method lets you concatenate each element in an enumerable collection without first converting the elements to strings.
The System.Guid structure now contains the TryParse and TryParseExact methods.
Secure Sockets Layer (SSL) support for the System.Net.Mail.SmtpClient and related classes.
Credentials for password-based authentication schemes such as basic, digest, NTLM, and Kerberos authentication in the System.Net..::.NetworkCredential class. To improved security, passwords may now be treated as System.Security.SecureString instances rather than System.String instances.
Ability to specify how a URI with percent-encoded values is converted and normalized in the System..::.Uri and System.Net.HttpListener classes. For more information, see the System.Net.Configuration.HttpListenerElement, System.Configuration.SchemeSettingElement, System.Configuration.SchemeSettingElementCollection, and System.Configuration.UriSection classes.
Thursday, March 18, 2010
Wednesday, March 17, 2010
ASP.net WebRequest Exception "System.Net.WebException: The server committed a protocol violation"
I encounter this error today.
And here is my stackoverflow post:
http://stackoverflow.com/questions/2460605/asp-net-webrequest-exception-system-net-webexception-the-server-committed-a-pro
Finally I set the request.KeepAlive=false to solve the problem.
And here is my stackoverflow post:
http://stackoverflow.com/questions/2460605/asp-net-webrequest-exception-system-net-webexception-the-server-committed-a-pro
Finally I set the request.KeepAlive=false to solve the problem.
Tuesday, March 16, 2010
Monday, March 15, 2010
ObjectDataSource Cache
Each ASP.NET application has its own data cache instance that’s shared across all pages and visitors. That means that the data stored in the data cache by the ObjectDataSource is likewise shared across all users who visit the page.
http://www.asp.net/learn/data-access/tutorial-58-cs.aspx
Using SQL Cache Dependencies
http://www.asp.net/learn/data-access/tutorial-61-cs.aspx
http://www.asp.net/learn/data-access/tutorial-58-cs.aspx
Using SQL Cache Dependencies
http://www.asp.net/learn/data-access/tutorial-61-cs.aspx
Check if a URL exists
http://stuff.seans.com/2009/01/05/using-httpwebrequest-for-asynchronous-downloads/
http://stackoverflow.com/questions/924679/c-how-can-i-check-if-a-url-exists-is-valid
http://blogs.microsoft.co.il/blogs/dorr/archive/2008/09/02/how-to-check-if-a-file-exists-over-http.aspx
http://www.developerfusion.com/code/4654/asynchronous-httpwebrequest/
http://stackoverflow.com/questions/924679/c-how-can-i-check-if-a-url-exists-is-valid
http://blogs.microsoft.co.il/blogs/dorr/archive/2008/09/02/how-to-check-if-a-file-exists-over-http.aspx
http://www.developerfusion.com/code/4654/asynchronous-httpwebrequest/
Sunday, March 14, 2010
Thursday, March 11, 2010
Efficiently Paging through data using the ASP.NET ListView Control
http://www.dotnetcurry.com/ShowArticle.aspx?ID=359&AspxAutoDetectCookieSupport=1
http://www.dotblogs.com.tw/walter/archive/2009/07/11/listview-datapager-with-objectdatasource.aspx
http://mosesofegypt.net/post/Building-Custom-Paging-with-LINQ2c-ListView2c-DataPager-and-ObjectDataSource.aspx
http://www.4guysfromrolla.com/articles/011310-1.aspx
SelectCoundMethod with Cache
http://msdn.microsoft.com/zh-cn/library/system.web.ui.webcontrols.objectdatasource.selectcountmethod.aspx
http://www.dotblogs.com.tw/walter/archive/2009/07/11/listview-datapager-with-objectdatasource.aspx
http://mosesofegypt.net/post/Building-Custom-Paging-with-LINQ2c-ListView2c-DataPager-and-ObjectDataSource.aspx
http://www.4guysfromrolla.com/articles/011310-1.aspx
SelectCoundMethod with Cache
http://msdn.microsoft.com/zh-cn/library/system.web.ui.webcontrols.objectdatasource.selectcountmethod.aspx
Sunday, March 7, 2010
Internet Explorer shows error when downloading excel file in SSL site
My post at stackoverflow today:
Internet Explorer shows error when downloading excel file in SSL site
http://stackoverflow.com/questions/2399203/internet-explorer-shows-error-when-downloading-excel-file-in-ssl-site
It's aboutthe Reponse Header's cache control.
Internet Explorer shows error when downloading excel file in SSL site
http://stackoverflow.com/questions/2399203/internet-explorer-shows-error-when-downloading-excel-file-in-ssl-site
It's aboutthe Reponse Header's cache control.
Subscribe to:
Posts (Atom)