Free SEO Toolkit:
http://www.microsoft.com/web/seo/
http://weblogs.asp.net/scottgu/archive/2010/04/20/tip-trick-fix-common-seo-problems-using-the-url-rewrite-extension.aspx
Tuesday, May 29, 2012
Monday, May 28, 2012
How choose random records in database by SQL
MS SQL Server:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY NEWID()
Do not use:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY RAND()
MS Access:
SELECT TOP 1 Field1 , ..., FieldN
FROM Table1
ORDER BY Rnd(Field1)
Reference:
http://www.carlj.ca/2007/12/16/selecting-random-records-with-sql/
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY NEWID()
Do not use:
SELECT TOP 1 Field1, ..., FieldN
FROM Table1
ORDER BY RAND()
MS Access:
SELECT TOP 1 Field1 , ..., FieldN
FROM Table1
ORDER BY Rnd(Field1)
Reference:
http://www.carlj.ca/2007/12/16/selecting-random-records-with-sql/
Friday, May 25, 2012
Load partial page in jquery and ASP.Net MVC
http://miroprocessordev.blogspot.ca/2012/05/load-partial-page-in-jquery-and-aspnet.html
$('#usersdiv').load('/home?name=' + $(this).val() + ' #usersdiv');
public class HomeController
{
public ActionResult Index(String name = "")
{
List<user> users = GetUsers()
.Where(u => u.Name.ToLower().StartWith(name.ToLower())
|| String.IsNullOrEmpty(search)).ToList();
return view(users);
}
}
Subscribe to:
Posts (Atom)