Friday, 17 July 2009

Visual Studio NAnt AddIn

http://www.netlogics.ch/en/nantaddin.html It works with both VS2005 and VS2008

Friday, 10 July 2009

How to filter sp_who2 information

DECLARE @sp_who2 TABLE 
(
SPID INT,
Status VARCHAR(255) NULL,
Login SYSNAME NULL,
HostName SYSNAME NULL,
BlkBy SYSNAME NULL,
DBName SYSNAME NULL,
Command VARCHAR(255) NULL,
CPUTime INT NULL,
DiskIO INT NULL,
LastBatch VARCHAR(255) NULL,
ProgramName VARCHAR(255) NULL,
SPID2 INT,
REQUESTID INT
)

INSERT @sp_who2 EXEC sp_who2

SELECT * FROM @sp_who2
WHERE Status > 'BACKGROUND'

Wednesday, 8 July 2009

How to add website to search engines

Submit to Google

Submit to Microsoft BING

Submit to Yahoo (requires registration)

Tuesday, 7 July 2009

Favicon Editor

The web editor that provides the facilities to draw favicon or convert GIF, JPEG or PNG to favicon. Favicon Editor

Open Web Tools Directory

Directory of various tools for Web Developers Open Web Tools Directory

C# How to send email

using System.Net.Mail;

public class Email
{
public static void Send(string smtpHost, string from, string to, string cc,
string subject, string body, MailPriority priority, bool isBodyHTML)
{
SmtpClient client = new SmtpClient(smtpHost);
client.UseDefaultCredentials = true;

MailMessage message = new MailMessage();
message.From = new MailAddress(from);
message.Subject = subject;
message.Body = body;
message.Priority = priority;
message.IsBodyHtml = isBodyHTML;

string[] addressesTo = to.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string address in addressesTo)
{
message.To.Add(new MailAddress(address));
}

if (cc != null)
{
string[] addressesCc = cc.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string address in addressesCc)
{
message.CC.Add(new MailAddress(address));
}
}

client.Send(message);
}
}